Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Select one of the following enterprises: - A public library database that consists of a number of different physical library locations. OR You can choose
Select one of the following enterprises: - A public library database that consists of a number of different physical library locations. OR You can choose any enterprise that implements a database. Step 0: Write down all the assumptions you have made for the E-R model. Step 1: Model the data for the enterprise you have selected using Entity-Relation (E-R) diagrams. There must be a minimum of 5 entity sets. Step 2: Identify the following in your design (if there is any): - Keys - Constraints - these include: Referential Integrity (Foreign Key) Not Null Constraints Check Constraints Default Constraints Unique Constraints
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started