Question: Draw Entity-Relationship Diagram and write the Relational Data Model for the following business: IT Specialists is a company that provides IT courses in programming, database
Draw Entity-Relationship Diagram and write the Relational Data Model for the following business:
IT Specialists is a company that 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 always taught by exactly one teaching team, and each teaching team teaches one or more sections.
Each trainee enrolled in a section has an enrollment number (e.g., seat number) for the section, an attendance preference (i.e., virtual or in-person), and a final grade for the section.
Each teaching team is identified by a unique number (teamNo), 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.
Each instructor on a teaching team is assigned a teaching role such as primary, support, or part-time instructor. Furthermore, the date the instructor was first assigned to the team needs to be recorded.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
