Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IT Specialists is a company to provide IT training in programming, database development and Web applications. Business rules include: The company offers five technology courses.

IT Specialists is a company to provide IT training in programming, database development and Web
applications. Business rules include:
The company offers five technology courses.
Each course is identified by a unique course number (cNo) and course name (cName).
At least one and up to three sections of each course can be offered in each training period; this
relationship is described by the training period (period).
Each section is identified by a unique pair of course number (cNo) and section number (sNo),
and a room location (room).
Each section can enroll up to 100 trainees and a section much have at least 20 trainees to be
offered.
Each trainee is identified by a unique trainee number (tNo) and name (tName), and each trainee
is restricted to enroll up to five sections of courses.
The company has 30 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 teaching team is identified by a unique number (mNo) and a team color (color), and
consists of 2 to 4 instructors.
Each section is taught by exactly one teaching team, and each teaching team teaches exactly one
section.

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

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions