Question: Design a database for an enterprise of your choice. Include the following in a word doc.
No answer yet for this question.
Ask a Tutor
Question:
Question:
Design a database for an enterprise of your choice. Include the following in a word doc.
A description of the enterprise. What is the purpose of the database?
Identify at least four major entities. Provide a list of the entities and a short description for each entity.
Draw a complete ER Diagram Showing:
The entities with their attributes, and primary keys
Relationships among the entities, and their attributes
Cardinality constraints
Total / partial participation
Weak entities and discriminator.
4.Reduce the ER diagram to relational schemas.
5.Describe the schemas using DDL.
6.Are your schemas in BCNF? Explain. If not, decompose them into BCNF.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6685b0c9afb09_5776685b0c98e8e5.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6685b0c9f2f9a_5776685b0c9e255a.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6685b0ca66d96_5786685b0ca44cd7.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/6685b0cacd0ad_5786685b0ca9d2dd.jpg)
Posted Date: