Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started