Coit20247 Database Design And Development Assessment Answer

Answer:

Assumptions and Business rules

The following assumptions are made for the development of the ER Diagram.

• The customers have all the necessary document and the licence that is required for booking the car from the QR Rental system.
• It is also assumed that more than one employee is assigned to a car for the management of the service and delivery of the car to the customer who have booked the car for rental.
• It is assumed that the database administrator would add the details of the customer and the employee accurately in the database table for the management of the errors in the database.
• It is assumed that each of the car is insured with an insurance policy and the information system is used for recording the details of the insurance for reducing the effort of management.

The business rules identified for the development of the information system are listed below:

• Categorizing the cars into different segments such as SUV, Sedan, Luxury limos, etc. and the location of the parking of the car should be recorded into the information system for increasing the security of the cars.
• The cost of hiring the cars should also be recorded for the calculation of the rental cost.
• The processing time of each of the request of the customer or the employee using the system should be minimum and the database tables should be connected with each other using the foreign key such that the accurate result of the query can be generated.  
• All the details of the cars, employees and the customers should be recorded in the database such that it can be used by the organization to improve the current business process.

References

Arasu, A., Babcock, B., Babu, S., Cieslewicz, J., Datar, M., Ito, K., Motwani, R., Srivastava, U. and Widom, J., 2016. Stream: The stanford data stream management system. In Data Stream Management (pp. 317-336). Springer Berlin Heidelberg.

Bhatt, S., Manadhata, P.K. and Zomlot, L., 2014. The operational role of security information and event management systems. IEEE Security & Privacy, 12(5), pp.35-41.

Buede, D.M. and Miller, W.D., 2016. The engineering design of systems: models and methods. John Wiley & Sons.

Dabbagh, M. and Lee, S.P., 2014. An approach for integrating the prioritization of functional and nonfunctional requirements. The Scientific World Journal, 2014.

Dennis, A., Wixom, B.H. and Tegarden, D., 2015. Systems analysis and design: An object-oriented approach with UML. John Wiley & Sons.

Di Sarno, C., Garofalo, A., Matteucci, I. and Vallini, M., 2016. A novel security information and event management system for enhancing cyber security in a hydroelectric dam. International Journal of Critical Infrastructure Protection, 13, pp.39-51.