We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these are 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 ERD diagram is given in the picture below. The question now is: 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. also Create the DDL statements to create the tables described in your modifies ER diagram.
We want to maintain a
has a number of schools and each school is characterized by its school-code which is unique, name
and campus location. Schools employ professors who are characterized by their unique staff-id, name
and the school they work for. A school offers courses that are characterized by their course-code which
is unique, course name and the school. There are subjects offered within the faculty and these are
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
ERD diagram is given in the picture below. The question now is:
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.
also
Create the DDL statements to create the tables described in your modifies ER diagram.
![Staff-id
School-idD
School-id)Sch-name
name
Stseet
Caty
State
Sch_location
1
employs
Poo fessor
İSchool
Country
feache
Subi id
have
Counce id
tite Subjec"
Subjects
has
Course
(Courel -name
M
School-id
emsolled
enooled
School-id)
in
Students
Phone
Studentid
(Shudent_namg
Addres
(Street City
State Country
Multi-campus sragional coniverenty](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4a622e42-9975-43f0-9a5a-28d03ad5b939%2Fc752825b-12c3-4521-84a8-52f7410b4d3d%2Fz344lpr_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)