Ongwari Dress Ltd wants to set up a database of its stock of wedding clothing that...

   

Transcribed Image Text:

Ongwari Dress Ltd wants to set up a database of its stock of wedding clothing that it hires out. For every item of clothing stocked, they need to record a unique item number, its name (e.g. waistcoat, bow tie), the date it was purchased, whether it is currently hired out, its location (e.g. "drawer 3, box 4") and the hire charge of that item. It is your job to design the database structure. (a) Draw up a two-column list, field names in the left-hand column and the corresponding data types in the right-hand column. (12 marks) (b) How could you find the total hire charge value of items currently hired out? (4 marks) (c) How might you set about recording which customer has hired out an item? (4 marks) Ongwari Dress Ltd wants to set up a database of its stock of wedding clothing that it hires out. For every item of clothing stocked, they need to record a unique item number, its name (e.g. waistcoat, bow tie), the date it was purchased, whether it is currently hired out, its location (e.g. "drawer 3, box 4") and the hire charge of that item. It is your job to design the database structure. (a) Draw up a two-column list, field names in the left-hand column and the corresponding data types in the right-hand column. (12 marks) (b) How could you find the total hire charge value of items currently hired out? (4 marks) (c) How might you set about recording which customer has hired out an item? (4 marks)