0 Download2 Pages / 270 Words
Add in library
Click this icon and make it bookmark in your library to refer it later.
GOT IT
In QRentals database design following assumptions are used-
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)
Oracle (2000). Drawing the Entity Relationship Diagram.
Smartdraw (2016). Entity Relationship Diagram.
To View this & another 50000+ free samples. Please put your valid email id.
Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.
Upload
Unique Document
Document
Under Evaluation
Get Money
into Your Wallet
Total 2 pages, 1 USD Per Page
To export a reference to this article please select a referencing stye below:
My Assignment Help. (2021). Database Design And Development. Retrieved from https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/database-with-customer-detail.html.
"Database Design And Development." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/database-with-customer-detail.html.
My Assignment Help (2021) Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/database-with-customer-detail.html
[Accessed 22 April 2021].
My Assignment Help. 'Database Design And Development' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/database-with-customer-detail.html> accessed 22 April 2021.
My Assignment Help. Database Design And Development [Internet]. My Assignment Help. 2021 [cited 22 April 2021]. Available from: https://myassignmenthelp.com/free-samples/coit20247-database-design-and-development/database-with-customer-detail.html.
MyAssignmenthelp.com has appointed best assignment experts who are wizards of words. Our writers know every trick of crafting high quality write-ups within a short period. With years of experiences, we have become one of the most prolific assignment help services in the USA. We deliver custom-made help to students with writing different types of assignments. We guarantee total need-based and timely service, and this is why increasing numbers of students prefer to buy assignment online.
Answer A USB Type-C connection is a port which is available on the MacBook which has mandatory headphone jack; it is responsible for taking care of power, data transfers and display output. Thunderbolt was developed with a promise of leaving behind the USB ports. Because according to the developers of Intel and Apple it was must fatter and the data transfer rate was faster than USBs (Intel, 2015). Along with this, it helps users to connect to ...
Read More
Answer: The database given was normalized to achieve a better database. Normalization of the database involved following the following steps; Ensuring no entity has any repeating groups to normalize the relations to 1NF. Ensuring all entities achieved as a result of normalization to 1NF have no partial dependencies thus normalizing them to 2NF. This involves making sure that an entity has only one candidate key that the other keys depend o...
Read More
Answer: The database should be able to store the details of all the courses in the system and each course in the system should be identified with a unique identity that would be helpful in distinguishing the different entries in the tables. The database should be able to store the details of all the students each data should be identified by a unique identification key. The database should be able to store the details of the enro...
Read More
Answer: Part 1: Use Case Realisation for the ‘Record New Tour’ Use Case 1.1 Analysis Class Diagram: In the paradigm of software engineering, the class diagram is a part of UML that represents the static structure of an application. The class diagram, as the name suggests, represents the classes of the application. These classes has attributes and operations. The class diagram are mainly used for describing the element...
Read More
Answer: Assumption: - A APPLIED_STAFF has many QUALIFICATION_DETAIL and a QUALIFICATION_DETAIL is related to many APPLIED_STAFF. Here many too many relationships occur. So I create a new table that is STAFF_QUALIFICATION. Here a staff has one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is related to one and only one APPLIED_STAFF. A qualification is related to one or many STAFF_QUALIFICATION and each STAFF_QUALIFICATION is ...
Read More
Just share requirement and get customized Solution.
Orders
Overall Rating
Experts
Our writers make sure that all orders are submitted, prior to the deadline.
Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.
Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.
Our writers can provide you professional writing assistance on any subject at any level.
Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.
440 Order Completed
99% Response Time
1692 Order Completed
98% Response Time
647 Order Completed
98% Response Time
Get all your documents checked for plagiarism or duplicacy with us.
Get different kinds of essays typed in minutes with clicks.
Calculate your semester grades and cumulative GPa with our GPA Calculator.
Balance any chemical equation in minutes just by entering the formula.
Calculate the number of words and number of pages of all your academic documents.
Our Mission Client Satisfaction
received 72 marks this is first assignment which i have received above 70 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.
Australia
received 74 marks this is first assignment which i have received above 74 i have given so many assignment after this i received a good marks. but expected is 85 above as i had paid too much money.
Australia
received 69 marks this is first assignment which i have received above 69 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.
Australia
Literally a life saver with everything going on. It was my first time seeking for assignment help and was really pleased. I definitely will recommend to others and use this platform again.
Australia
Say hello to our new app
