(Solved) : Case Study Qrentals Database System Qrentals Qr Private Owned Business Located Large City Q30233599 . . . .

Case Study: QRentals database system

QRentals (QR) is a private-owned business located in a largecity that specializes in car hire service.

The management of QR has approached you to build a relationaldatabase that will be used as the

most critical backend software component in their enterprisemanagement system so that the

relevant business data will be recorded appropriately andfurther information query will be processed

efficiently. The proposed database system requires efficientlyto track all QR’s vehicles, customers,

employees and relevant rental activities. Consider the followinguser requirements carefully and

design a database conceptual schema (i.e. E-R model) to supportsuch an application.

The company owns a large number of cars for hire.