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?
Step by Step Answer:
Database Design Using Entity Relationship Diagrams
ISBN: 9781032017181
3rd Edition
Authors: Sikha Saha Bagui, Richard Walsh Earp