Database Fundamentals Activity 2: Write Specification from ER Diagram Write out the Business Rules for the following Entity-Relationship Diagram. You do not need to describe the attributes. Ensure you include all cardinalities & participation constraints. Identify weak/strong relationships. Use regular English (not database speak). city street name description part-num address Manufacturer 1 made-by m Part m quantity ID name contains m Customer 1 m order Order order-pum
Added by Calvin B.
Close
Step 1
The diagram shows four main entities: Manufacturer, Part, Customer, and Order. Show more…
Show all steps
Your feedback will help us improve your experience
Ivan Kochetkov and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Mini Final Project Part 1: Due [6/23/2020] 1. Select a topic to design. 2. Design ER Diagram. 3. Define Entity-Relationship schema. Marking Scheme: ER Diagram i. Is the ER Diagram clear? Yes No ii. Match the style from class? Yes No iii. Is the cardinality accurate? Yes No iv. Match the structure from the DDL scripts? Yes No v. Missing Relationships? Yes vi. Does the ER Diagram have Many-Many Relationships? Yes No vii. Is the diagram in the Third Normal Form? Yes No Comments: No Minimum Requirements: - 4 Entities - Minimum of 4 Attributes per Entity - Each table must include a primary key - Database must use a minimum of 3 foreign keys
Akash M.
Q4. Consider the EER diagram for a car dealer database in the following figure. Employ the mapping rules to map the EER diagram to a relational database schema and indicate the primary key (underline) in each relation.
Aarya B.
Consider the EER diagram for a car dealer database in the following figure. Employ the mapping rules to map the EER diagram to a relational database schema and indicate the primary key (underline) in each relation. [2.2][3] CAR Engine_size VEHICLE TRUCK Tonnage Model Date SUV No_seats SALE SALESPERSON CUSTOMER Address Figure 9.9 EER diagram for a car dealer. State Street Ssn Name
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD