The manager of a video hire shop uses a relational database management system to operate the business. Separate database files hold details of customers, video films and loans. Customers can hire as many films as they wish.
(a) For each of the files mentioned above identify the key fields and list other appropriate fields that would be required to enable this system to be maintained with minimum redundancy.