he database business rules

are:

The database stores information about each teaching

Room

with the following attributes:

BuildingID

,

RoomID

and

Capacity

.

A

Room

can be one of two types:

Lab

and

Classroom

, and cannot be both

simultaneously

.

Each

Lab

has an attribute

LabType

(Network

, Web Design, Software Development etc.).

Each

Classroom

has an attribute:

BoradType

(wall

-

mounted board, mobile whiteboard,

glass board, chalkboard etc.)

A

Room

can have

none, one or several

Media

with the following attributes:

MediaType

(projector, microphone, online media stream

, printer, TV etc.).

A

Lab

has computers

of one or several types

. A

Computer

has the following attributes:

ComputerType

(Apple, Windows PC, Linux PC, Laptop, Tablet etc.),

Description

,

MemorySize

,

ProcessorSpeed

.

A

Teacher

has the following attributes:

ID

,

Name

,

Rank

and

Email

.

Each

Session

has the following attributes:

DayOfWeek

,

StartTime

and

EndTime

.

Each course

Unit

has the following attributes:

UnitID

,

UnitDescription

and

Credits

.

A

Unit

might have none, one

or several prerequisites.

A

Unit

can have one or several classes depending on a number of students.

A

Class

has attributes:

ClassID

and

EnrollmentLimit

.

A

Teacher

teaches none, one or several

Classes

of a

Unit

.

A

Session

is assigned to a

Teacher

.

A

Schedule

is created for each

Year

and

Semester

. A

Schedule

links

Sessions

, Rooms

and

corresponding

Classes

.

A

Teacher

uses none, one or several types of

Media

.

Your assignment

submission

consists of two parts.

Part 1. Conceptual Model

Identify

Entities

Identify entity supertypes and subtypes and their types, inheritance, and

discriminators.

Describe relationships between entities and their cardinalities

Identify entity primary keys

Draw a Conceptual Model Entity

-

Relationship diagram

Part 2.

Logical Model

Describe data attributes and their types for each entity

Redesign the Conceptual model removing many

-

to

-

many relationships

(if any)

Identify

primary, composite (if any) and

foreign keys

(if any)

for each entity

if there are any one

-

to

-

one rel

ationships then describe them

Draw a Logical Model diagram