Part 1 Draw an ERD for MyCollege. You can do it using paper and pencil, or...

 

Transcribed Image Text:

Part 1 Draw an ERD for MyCollege. You can do it using paper and pencil, or using a tool to draw ERDs. If you use a tool, please mention the name and url. Note: DO NOT USEA TOOL THAT TRANSFORMS DIRECTLY YOUR ERD INTO RELATIONS. If you do you will not understand how to draw an ERD. The ERD will capture the following information: MyCollege has several schools. Each school has a unique Dean. Deans are not shared between schools. Each school has several departments. A department belongs to one school only. Departments offer majors. Departments offer courses. A course can be offered by several departments. Several sections (classes) of the same course can be offered. Each department has a unique chair and several professors. A chair is a professor. A professor teaches up to 3 classes. A professor could teach O class due to release time for research or administration. Students enroll in up to 5 (different) classes a semester. The minimum number of classes a student can take is 1. A student can have 1 or 2 majors. If information is missing, please ask for it in the discussion board. Part 2 Transform your ERD into a set of relations. Be sure to show the primary keys and foreign keys. Part 1 Draw an ERD for MyCollege. You can do it using paper and pencil, or using a tool to draw ERDs. If you use a tool, please mention the name and url. Note: DO NOT USEA TOOL THAT TRANSFORMS DIRECTLY YOUR ERD INTO RELATIONS. If you do you will not understand how to draw an ERD. The ERD will capture the following information: MyCollege has several schools. Each school has a unique Dean. Deans are not shared between schools. Each school has several departments. A department belongs to one school only. Departments offer majors. Departments offer courses. A course can be offered by several departments. Several sections (classes) of the same course can be offered. Each department has a unique chair and several professors. A chair is a professor. A professor teaches up to 3 classes. A professor could teach O class due to release time for research or administration. Students enroll in up to 5 (different) classes a semester. The minimum number of classes a student can take is 1. A student can have 1 or 2 majors. If information is missing, please ask for it in the discussion board. Part 2 Transform your ERD into a set of relations. Be sure to show the primary keys and foreign keys.

Answer rating: 100% (QA)

Lets break down the requirements given in the question and create an Entity Relationship Diagram ERD followed by transforming the ERD into a set of re... View the full answer