A small DVD rental store is to use a database to track its rentals and customer contacts. The database will comprise of the following tables:
•A Customer table containing information about each Customer;
•A DVD_Titles table containing information about each DVD title;
•A Rental table containing information about the rentals that are taking place.
(a)Define and explain appropriate fields for each table indicating the data types. Use examples where necessary.
i would be grateful if someone could answer me question (a).. thanks
this is not homework, im looking at past exams and im trying to understand the questions and then revise so i can be prepared for the exam
Georgiaboy17 says
In the customer data base I would use the following fields: customer number, last name, first name, address, phone number, zip code
In the dvd titles table I wold have the following:Title, Director, Rating, Movie Length, Reviews, Actors and Actresses in the movie.
As far as the rentals table maybe, customer number, movie title, date and time.
Poohshoes says
do your own homework
jab_hawk1 says
Do your own homework. Answers are nice but you have to learn it yourself
Colanth says
What work have you already done? We’ll help you, we won’t do your work for you.
BeaverDono says
Yeah.. do your own homework…
Freaky Firman says
Customer –
Customer_ID – Number
First_Name – char(60)
Last_Name – char(60)
Street_Num – char(255)
City – char(60)
Remark – char(255)
DVD_Titles –
Title_ID – Number
Title – char(255)
Description – char(255)
Rental
Transaction_Date – DateTime
Transaction – char(60) –‘Rent or Return
Title_ID – Number –‘Connect to Title_id in DVD_Titles
Customer_ID – Number –‘Connect to Customer_ID in Customer