(e) Referring to the following descriptions, draw the ER diagrams of the entities "Course", "Student", "Department", "Professor" and their relationships using Crow's Foot Model. For the relationship, mark both the cardinality and the connectivity. You do not need to list the attributes of each entity, and do not need to mark the primary and foreign keys. Note that the ER diagram must be drawn in the form that can be directly implemented in the relation database. • Each student belongs to one department. Each professor works for a department. One professor serves as the head of the department which he/she works in. Each department must have a head. • Each student can take several courses at the same time. The student may not take any course. • Each professor teaches multiple courses. Each course is taught by one professor. The professor may not teach any course. • Each professor supervises at least one student. Each student is supervised by one professor.
Added by Christopher T.
Close
Step 1
First, let's start with the entities: Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 99 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
Given the E-R diagram on the following page, list the names of the entities, attributes, keys, and relationships being used. 2. For each entity, give a formal written description, including all of its attributes and its key. 3. For each relationship, give a formal written description of both directions of the relationship, including its cardinality.
Akash M.
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
The following figure shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. NOTE: In the EMPLOYEE entity, you can assume an additional attribute EmpType that serves as a subtype discriminator. Transform the EER diagram into a 3NF relation schema and show all the dependencies.
Aarya B.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD