Question: 4. Draw the Entity Relationship Diagram (ERD) as explained below. Be sure to show cardinality in both directions using Crows Foot notation. Do NOT include

4. Draw the Entity Relationship Diagram (ERD) as
4. Draw the Entity Relationship Diagram (ERD) as explained below. Be sure to show cardinality in both directions using Crows Foot notation. Do NOT include the fields/attributes or keys for each entity. Do not include any additional entities and or relationships to your ERDs than what is describcd below: (25 points) Use software to draw the following F.RD. Do not draw/sketch it by hand. The ERD is to be cmbedded/copicd inte your final esam Micreseft Werd file. You are NOT to submit a separate file for this E.RD. Make sure it is large enough so I can read it. NEWTON University is divided into several schools: Humanities, Political Science, Engineering, and Physical Education. Each SCHOOL is administered by a dean who is a PROFESSOR. Each professor can be the dean of oaly one school and a professor is not required to be the dean of any school. Each school comprises several departments. For example, the Engineering school has a Drafting department, a Prototyping department, and a Mechanical department. The smallest number of departments operated by a school is one, and the largest number of departments is many (indeterminate). On the other hand, each DEPARTMENT belongs to only a single school. That is, the minimum number of schools to which a department belongs is one, as is the maximum number. Page 4 of 5 ITEC 630 Summer 2022 Each department may offer courses. For example, the Drafting department offers courses such as Introduction to Drafting, Compass Use, and Drafting with Software. If NEWTON University had some departments that were classified as "research only" they would not offer courses; therefore, the COURSE entity would be optional to the DEPARTMENT entity. A CLASS is a section of a COURSE. That is, a department may offer several sections (elasses) of the same Drafting course. Each of those classes is taught by a PROFESSOR at a given time in a given place. CLASS is eptional to COURSE. Each DEPARTMENT should have one or more PROFESSORs assigned to it. One and only one of those PROFESSORs chairs the department, and no professor is required to accept the chair position. Therefore, DEPARTMENT is optional to PROFESSOR in the "chairs" relationship. Each PROFESSOR may teach up to three classes; each CLASS is a section of a COURSE. A PROFESSOR may also be en a research contract and teach no classes at all

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!