Coit20247 The Business Rules Answers Assessment Answers
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
• use consistent and appropriate naming for entities and attributes as specified in the unit text book.
Some business rules or other aspects of the case study may not be clear to you when you read the case study. If this is the case, then you should either approach your lecturer or tutor for clarification, or you may simply make an assumption and then develop your ERD accordingly. For example, the case study might not mention all relevant participation information (also called minimum cardinalities). If so, you may make an assumption about what the minimum cardinalities might reasonably be, and then show them in your ERD accordingly.
Answer:
Assumptions and Business Rules
In QRentals database design following assumptions are used-
- There will be only one category for one car. A car cannot be categorized into more than one category.
- The customer enquiry will be stored into the database with customer detail.
- The complete booking detail will also be stored into the database e.g. booking cost, locations, vehicle category etc.
- There will be only one work location for one employee.
- If customer does not complete the booking, still the customer detail will be saved with corresponding enquiry.
- The parking locations may be different for one car.
Logical Design
Category (FieldCategory, FieldHireRate)
Car (FieldRegNumber, FieldMake, FieldModel, FieldManufacturedYear, FieldNoOfSeats, FieldCategory, FieldImage)
Foreign Key (FieldCategory) References Category (FieldCategory)
Location (FieldLocationID, FieldAddress, FieldCity, FieldState, FieldPostcode)
ParkingLocations (FieldRegNumber, FieldLocationID)
Foreign Key (FieldRegNumber) References Car (FieldRegNumber)
Foreign Key (FieldLocationID) References Location (FieldLocationID)
Employee (FieldEmployeeID, FieldFirstName, FieldLastName, FieldDOB, FieldPhone, FieldSkill, FieldAnnualSalary, FieldLocationID)
Foreign Key (FieldLocationID) References Location (FieldLocationID)
CarInsurance (FieldRegNumber, FieldPolicyNumber, FieldPremiumAmount, FieldInsurerName, FieldPolicyStartDate, FieldPolicyExpiryDate)
Foreign Key (FieldRegNumber) References Car (FieldRegNumber)
Customer (FieldCustomerID, FieldCustomerName, FieldLicenseNumber, FieldAddress, FieldPhone)
Individual (FieldCustomerID, FieldIsInsurance)
Corporate (FieldCustomerID, FieldOrganization, FieldABN, FieldIsSpecialDeal)
Enquiry (FieldID, FieldDescription, FieldEnquiryDate, FieldEmployeeID, FieldCustomerID, FieldCategory)
Foreign Key (FieldCategory) References Category (FieldCategory)
Foreign Key (FieldEmployeeID) References Employee (FieldEmployeeID)
Foreign Key (FieldCustomerID) References Customer (FieldCustomerID)
Booking (FieldReservationNumber, FieldDescription, FieldBookingDate, FieldStartDate, FieldEndDate, FieldPickupLocation, FieldDropOffLocation, FieldRegNumber, FieldEmployeeID, FieldCustomerID, FieldCategory, FieldCost)
Foreign Key (FieldCategory) References Category (FieldCategory)
Foreign Key (FieldRegNumber) References Car (FieldRegNumber)
Foreign Key (FieldEmployeeID) References Employee (FieldEmployeeID)
Foreign Key (FieldCustomerID) References Customer (FieldCustomerID)
References
Oracle (2000). Drawing the Entity Relationship Diagram.
Smartdraw (2016). Entity Relationship Diagram.
Buy Coit20247 The Business Rules Answers Assessment Answers Online
Talk to our expert to get the help with Coit20247 The Business Rules Answers Assessment 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.
