Hi Guys!
Am revising for my upcoming exam. I was trying a question in the past papers. It read:
A power-tool hire company requires an object-relational (e.g. Oracle) database to record details of their tools and rentals. Customer details, including their name, address and telephone number, must be recorded for each rental. A deposit for loss or damage to the tool is taken against a credit or debit card.
Each type of power-tool owned by the company is classified as either 'mains powered', or generator- powered', and the daily rental cost is to be stored for each tool type (not separately for each tool). Minimum attributes to be stored in the database, in addition to those mentioned above, are the make and model of the tool type (e.g. Bosch PT105), and the start and end dates of the rental.
Q(a) Give type and table definitions for the three object types in part a). In particular: use the REF data type to implement the relationships between the types, and define appropriate primary keys for each of the tables.