Question 3: Create the DDL statements to create the tables described in your modified ER diagram in Question 2
Note to Expert: I had asked this question before and was answered by someone, thank you! But I think the expert was mistaken for question 2 and question 1 answer and I don't know if the answer he provided for question 3 is based on question 2 or not. So I had to ask this question again. I did not understand the previous answer. Thank You!
These questions are in sequence and the previous question needs to be referred to answer the next question:
This is the previous question that was asked
Question 1(question to be answered at the end):
Create the Entity-Relationship (ER) Diagram for the following scenario:
We want to maintain a
characterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id which is unique, name, address and phone.
The following business rules apply
• A course must belong to only one school, but a school may have many courses
• A student must be enrolled in a course, but a course may have 0 or more students
• A course must have one or more subjects, but a subject may be taught as part of many courses
• A student may be enrolled in many subjects, and a subject may have many students enrolled in it
• A subject must be taught by a professor, and a processor may teach many subjects
• A professor is employed by only one school, and a school may employ many professors
Answer in the picture
Question 2 (question to be answered at the end):
What can you say about the relationships between Courses and Subject, and Courses and Students? Will there be any problems in creating a Relational Database from your ER diagram? If there is, then describe how you will address this and re-draw the ER diagram.
Updated answer in the picture.
Question 3: Create the DDL statements to create the tables described in your modified ER diagram in Question 2
Step by step
Solved in 3 steps