A company that specializes in IT training needs a data model for the following r

Question

A company that specializes in IT training needs a data model for the following requirements. The company has 30 instructors. The company offers three semester terms per year. The company offers up to five courses per term. Each term has a maximum enrollment of 100 students. Each course has one assigned instructor per term. Occasionally, a course will be assigned two instructors per term. An instructor cannot teach more than two courses per term. In addition to teaching courses, an instructor may be assigned to do research projects each term. Each course has a maximum enrollment of 30 students. Each student is required to take one course per term and may take up to three courses per term. Required: Develop an Entity-Relationship Diagram that would represent the necessary entities and their relationships including entity names, relationship names, relationship direction arrows, and multiplicity notation for each entity in each relationship.

Explanation / Answer

Here entities are

company

instructor

semester

course

student

Research Project

assumtions : <|---- Agreegation Relationship(whole part relation)

--1--relation name---1-- One to One

---1..x -- relation name --1..x -- 1..x to 1..x

---1..* -- relation name --- 1...*-- many to many

E--R Diagram--------------------------------------------------

company<|--1--(Agreegation Relation)--30-- instructor(i.e insructor is a part of company)

company --1--(Association relation)Offers terms per year--3---semester

campany ---1--(Association Relation) Offers per term----5----course

semester <---1----(Association Relation) Enrollment----1...100---Student

course <-----1-----(Asscociation Relation)assigned per term -----1---->instructor

instructor <-----1-------(association Relation)teaches per term ----1..2-- course

instructor ------1-------(Association Relation)Assigned to do -----1..*------- Research Project

course ------1-------(Association Relation)Enroll ------1...30 -----Student

Student ------1------(Association Relation)can take ----1..3----Courses

please if u want a consolidated diagram then just redraw the diagram with taking each entity once and join the line as above metioned..

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.