Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create an Entity Relationship ( ER ) diagram Assume that you are designing a small relational database system. First, choose one of the following: Customer
Create an Entity Relationship ER diagram
Assume that you are designing a small relational database system. First, choose one of the following:
Customer management system for a small business eg plumbing company, travel agency, lawn care services, music lessons, moving services, laundry services, etc.
Hotel reservation system
Restaurant order management system
Student class enrollment system in a college
Used car dealership sales system
Pizza delivery order system
Real estate agents system
Bookstore system
Small online shopping mall system eg clothes, shoes, candies, etc.
Other
Draw a conceptuallevel ER diagram for the selected system using Chen's notation.
Identify three to five entities
Identify at least three attributes for each entity
Identify a primary key or foreign keys for each entity solid underline for a primary key; dashed underline for a foreign key
Create necessary relationships between entities. For the connectivity, you should place M or N on each relationship line.
For this assignment, you may draw the diagram by hand or use a drawing program.
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