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