Question: ISDS 3110: Data and Information Management LAB #5: M:M Data Modeling Part I. Review examples on Many-to-Many data modeling lab slides. Part II. Draw ER
ISDS 3110: Data and Information Management LAB #5: M:M Data Modeling Part I. Review examples on Many-to-Many data modeling lab slides. Part II. 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 company's 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 (No) 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 (No), and a trainee has other information such as name (tName), email, supervisor's name, and supervisor's 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 (No) 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
Get step-by-step solutions from verified subject matter experts
