Questions and Answers of Database Design Using Entity Relationship Diagrams

Why is reverse engineering important?
Come up with an ER diagram for the following relational database:
Come up with an ER diagram for the following relational database:
Come up with an ER diagram for the following relational database:
Come up with an EER diagram for the following database:
What do mandatory attributes (in the Barker/Oracle-like model) translate into in the Chen-like model? Discuss with examples.
What do optional attributes (in the Barker/Oracle-like model) translate into in the Chen-like model? Discuss with examples.
How are the primary keys shown diagrammatically in the Barker/ Oracle-like model?
How is the optional relationship shown diagrammatically in the Barker/Oracle-like model?
How is the many relationship shown diagrammatically in the Barker/Oracle-like model?
Show the following using the Barker/Oracle-like notation:a. A movie theater must show many movies, and movies must be shown in a movie theater.b. A movie theater may show many movies, and movies may
How are recursive relationships shown in the Barker/Oracle-like model?
Why is it difficult to show M:N relationships in the Barker/ Oracle-like model?
How are the foreign keys treated in the Barker/Oracle-like model?
Does the Barker-like model or the Oracle-like model have the concept of the weak entity? Discuss.
Show the following using the Barker/Oracle-like notation: For a student, we are trying to store the student’s name, address, phone, books (that is, books the student borrows from the library). Map
Does the Barker/Oracle-like notation have the concept of the multivalued attribute? Discuss.
Redraw Figure 8.17a using the Barker/Oracle notation. Map this to a relational database and show some sample data.
Redraw Figure 8.7 using the Barker/Oracle notation. Map this to a relational database and show some sample data.

Showing 200 - 300 of 219

1
2
3