video rental company.

ASSIGNMENT QUESTION

The following scenario, describes the data requirements for a video rental company.

The video rental company has several branches throughout Malaysia. The data held on each branch is the branch address made up of street, city, state, and postcode, and the telephone number. Each branch is given a branch number, which is unique throughout the company. Each branch is allocated staff. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company. Each branch has a stock of videos. The data held on a video is the video number, title, category, daily rental, cost and status. A video is given a category such as Action, Adult, Children, Drama, Horror, or Documentary. The status indicates whether a specific copy of a video is available for rent. Before hiring a video from the company, a customer must first register as a member of a local branch. The data held on a member is the first and last name, address, and the date that the member registered at a branch. Each member is given a member number, which is unique throughout all branches of the company. Once registered, a member is free to rent videos, up to a maximum of ten at any one time. The data held on each video rented is the rental number, the customer number, the video number and the dates the video is rented out and returned. The rental number is unique throughout the company.

(a) Identify the objects that can be represented as TABLES and attributes of object that can represent columns in the database schema for this company. Write SQL statements to create the tables.
(b) Given the following information in Table 1 and table 2. Write SQL statements to insert data into table.

Table 1: Information about Branch
Branch number
Street
City
State
Postcode
Telephone number
10001
23, Jalan Tenggiri
Seremban
Negeri Sembilan
70000
+606777444
10002
3A, Jalan Maju
Kajang
Selangor
43500
+603888999
10003
56, Jalan Setia
Cheras
Kuala Lumpur
56000
+603777222

Table 2: Information about Video
Video number
Title
Category
Daily rental
Cost
Status
2001
Kung Fu Panda 3
Action
25
150
Available
2002
Racing Extinction
Documentary
30
350
Not available
2003
The Witch
Horor
35
200
Available

Accurately write correct and complete SQL codes
(50)

Provide SQL Command for creating the following TABLES:
Branch
Provide SQL Command for creating the following tables:
Staff
Provide SQL Command for creating the following tables:
Video
Provide SQL Command for creating the following tables:
Customer
Provide SQL Command for creating the following tables:
Rental

Provide SQL Command for data insertion in Branch and Video.

Order from us and get better grades. We are the service you have been looking for.