You want to create a database about businesses. Each business will have a name, address, the business

Question:

You want to create a database about businesses. Each business will have a name, address, the business phone number, the owner's phone number, and the frst names of the employees who work at the business. Draw the ER diagram using the Chen-like model and then write the English description for your diagrams. Compare the English to your diagrams and state any assumptions you made when drawing the diagrams. Map your diagrams to a relational database.
Which attributes would you consider composite attributes in this database? Which attributes would you consider multivalued attributes in this database? Could there be any derived attributes? What would be good keys?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Design Using Entity Relationship Diagrams

ISBN: 9781032017181

3rd Edition

Authors: Sikha Saha Bagui, Richard Walsh Earp

Question Posted: