COIT20247 Database Design and Development
In this assignment, you need to create an Entity Relationship (ER) diagram relevant to the above case study and optionally perform logical design to produce appropriate 3NF Relations.
The attributes for various entities have not been purposely described in the case study so that the students are encouraged to further research and list the pertinent attributes in addition to the required identifier for each and every entity in their ERD.
1 Draw an appropriate ER diagram
Use the symbols as prescribed in your unit-textbook to draw the ER diagram (ERD) for the above case study.
Your ERD must
- show all necessary entities, attributes and relationships
- show identifiers/identifying attributes as necessary
- show multi-valued attributes, if any
- show participation and cardinality
- show associative entities, if appropriate
- show weak entities, if any
- use the notation described in the set text
1 Identified entities (including super type and sub type entities), associative entities, weak entities (if any) and named appropriately
2 Provided appropriate attributes
3 Provided identifiers/identifying attributes
4 Drawn correct relationships between entities and named them appropriately
5 Used proper symbols for
- entities including super type and sub type; associative entities; weak entities if any
- relationships
- identifying attributes
- min and max cardinalities for the relationships
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.
Buy COIT20247 Database Design and Development Answers Online
Talk to our expert to get the help with COIT20247 Database Design and Development Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.