Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

More Books

Students also viewed these Databases questions

Question

2. Employment agency (for scholarship-holders).

Answered: 1 week ago

Question

HOW IS MARKETING CHANGING WITH ARTIFITIAL INTELIGENCE

Answered: 1 week ago

Question

Different types of Grading?

Answered: 1 week ago

Question

Explain the functions of financial management.

Answered: 1 week ago

Question

HOW MANY TOTAL WORLD WAR?

Answered: 1 week ago