create a conceptual shema, logical schema, physical schema and ER diagram for every case in the study material PDF file for each one.

Cable channels Case

Description

A movie has a title and year and can be broadcasted on several channels. A cable

package has a unique id$,$ and a price. Each package can be considered in several different

channels. Each channel has a channel number and name. Each channel contains several

packages. Each channel broadcast several movies and has a schedule for that $($in a

specific day and time$).$ The duration of a broadcast is also important. Create a conceptual

schema to satisfy these requirements.

University Case

In a University there are departments, courses, instructors and students. Instructors

teaches courses and students take courses, Students are either scholarship students or

non$-$scholarship. Scholarship students have a scholarship percentage information. Also

there are three types of students graduate, undergraduate and vocational school $(2$ years$)$

students. Graduate students are either master student or phd student.

A student have an ID$,$ name and sumame, entrance year. An instructor also have an ID$,$

Social security number, name and surname Master and Phd students additionally have

undergraduate graduation year and an instructor must be assigned as a thesis advisor. A

department has instructors and courses offered. Create a conceptual schema to satisfy

these requirements.

Atil$$m University Case

Atilim University keeps track of insurance information of vehicles in the university. A

vehicle can be a car or a track. A car is identified by its license plate number, production

year and producer name $($make$).$ A track is also identified by its license plate number.

production year and its capacity. The insurance company records the owners of these

vehicles. The owner of a vehicle can be a person who is recorded by social security

number, and name. Each vehicle has insurance by an insurance company. The insurance

companies are followed by the company name and phone number. Each vehicle must

have insurance. The insurance is recorded by it maximum lost cost and maximum damage

information. Design a conceptual database model to satisfy these requirements of the

organization.