Data Base Management System Lecture 7

Main note

Number Of tabless

The number of tables will be the number of attributes that are multi valued + elements.

One to Many

When theres a one to many relations there is always a foreign key. No need for additional Table if the relation is 1 to many

Weak Entity

The weak entity is the one with double squares and the relation that is in weak to strong relation is in a double diamond.

Test

Used relational Operators to complete a few Queries.

References

Information

• date: 2024.08.14
• time: 15:21