Question: Draw ER diagram and write the relational data model for the following business: IT Specialists IT Specialists is a company to provides IT courses in

Draw ER diagram and write the relational data model for the following business:

  1. IT Specialists

IT Specialists is a company to provides IT courses in programming, database development, and Web applications. The companys business rules include:

  • Each course is identified by a unique course number (cNo), and other course attributes include: course name (cName), course description, pre-requisites.
  • At least one and up to many sections can be offered of each course.
  • Each section is identified by its unique pairing of course number (cNo) and section number (sNo). Other attributes of section include a room location (room).
  • Each section can enroll up to 100 trainees, and each trainee can be enrolled in 0 to 5 sections.
  • Each trainee is identified by a unique trainee number (tNo), and a trainee has other information such as name (tName), email, supervisors name, and supervisors email that is necessary to maintain.
  • Each section is taught by exactly one teaching team, and each teaching team teaches multiple sections.
  • Each teaching team is identified by a unique number (mNo), and a team has a team color (color) and a team name. Each teaching team consists of 1 to 4 instructors.
  • Each instructor is identified by a unique number (iNo) and name (iName) and each instructor can be assigned to 0, 1, or 2 teaching teams.

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!