Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A university college decided to create a database to schedule classes. The database business rules are: i The database stores information about each teaching Room

image text in transcribed
A university college decided to create a database to schedule classes. The database business rules are: i The database stores information about each teaching Room with the following attributes: Buildinng, RoomlD and Capacity. 0 A Room can be one of two types: Lab and Classroom, and cannot be both simultaneouslv. a Each Lab has an attribute LabTvpe (Network, Web Design, Software Development etc). a Each Classroom has an attribute: BoradTvpe [wall-mounted board, mobile whiteboard, glass board, chalkboard etc.) o A Room can have none, one or several Media with the following attributes: MediaTvpe (projector, microphone, online media stream, printer, TV etc). o A Lab has computers of one or several types. A Computer has the following attributes: ComputerTvpe (Apple, Windows PC, Linux PC, Laptop, Tablet etc.',l, Description, MemorvSize, ProcessorSpeed. - A Teacher has the following attributes: ID, Name, Rank and Email. In Each Session has the following attributes: DavOfWeel-c, StartTime and EndTime. a Each course Unit has the following attributes: UnitlD, UnitDescription and Credits. - A Unit might have none, one or several prerequisites. c A Unit can have one or several classes depending on a number of students

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

Step: 3

blur-text-image

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

Financial Accounting An Integrated Approach

Authors: Ken Trotman, Michael Gibbins, Elizabeth Carson

6th Edition

0170349683, 9780170349680

Students also viewed these Mathematics questions