7:18
HW # 1 - Entity HW
Due today at 11:59 PM
Instructions
Entity Types . 1
Entity Sets : 2
Design a database for a video rental company.
The company has several branches distributed in the city.
Branch data is the branch number where each branch in the
company has its own number, branch phone number. In
addition, there are data on the branch address which consists
of area name, street name, PO box, postal code.
The company's branches rent videos to customers.
Video data: video number, video title, category, status (leased
or not rented), names of the people involved (eg movie
actors), director's name, daily rent.
Before the video is rented to the customer, he/she is required
to register his/her data in the company's branch as a
customer where a special number is given and his/her data is
stored in the database. Customer data: customer number,
customer name, phone number.
My work
