ISDD+Data+Dictionary

media type="custom" key="28096831"


 * Questions**

1. A sports centre has a number of sports facilities that can be hired out to teams. Identify suitable values for Q1 - Q15

Notes
 * Hourly Hire Cost is between £1.50 and £30 and this information must be stored
 * The maximum Facility Capacity is 100 and this information must be stored
 * It is useful to store the sport (Sport) that the facility is being used for, but not essential
 * Facilities can be booked between 10am and 8pm
 * Payment Method can be either: Credit Card, Debit Card, Cash or Cheque and this information must be stored
 * A booking cannot be made without a contact number



2. A car rental company want to develop a database to store information about the cars they are renting out as follows:
 * CAR ( __ registration_number __, make, model, location)
 * CUSTOMER ( __ customer_number __, customer_name, customer_address)
 * RENTAL ( __ rental_id __, customer_number*, rental_date, rental_duration, registration_number*)

Notes
 * Rental ID is a 6 character code of letters and numbers (e.g. T147XA)
 * Customer Number is an 8 digit numeric code (e.g. 00198812)
 * Rental duration should be no more than 7 days

Produce a data dictionary for this database.