Drawing appropriate ER diagram
Explanation of Business rules and Assumptions
Designed ERD assumptions: The aforementioned are hypotheses that were taken into account based on the CQUnited database system case study:
- Assumption 1: There may be different parking spaces within a country, where a substantial number of propertys may be parked.
- Assumption 2: Within specific cities, one staff will be able to take care of the organization's tracking/storage of property information.
- Assumption 3: There are two classes, such as employees and clients, to separate individuals. Responsibilities will be allocated based on the position.
- Assumption 4: Executives seem to be the main accountable individual liable for the storage of reservation/departure of property records.
Description based on Business Rules
The provided contextual inquiry of the CQUnited database assignment help explain various provisions, taking into account the final objective of making a property rental strategy. This ERD is therefore formed in perspective of the fact that the company chooses with the objective that the information table can legally describe. In view of the scenario depicted, conceivable presumptions are acknowledged before outlining the ERD. In perspective of all these suspicions, the laws of the company are altered in this assignment, for example
- Preserving Details of the Property: The CQUnited database assignment help construct the distinct approach arrangements as set out in the preconditions. The points of the relevance of CQUnited database strategies are placed with an exemplary policy number in the database structure so that data surplus can be avoided. The customers of the organisation allow their provisions to be tracked as well as maintained by using the impressive consumer ID structure.
- Encrypting the Property's booking details: ERD is preparing a database structure that will enable CQUnited database system suppliers to track their registered scheme through outstanding Identity Documents of staffs." Alongside this, official customers or even the group's greater management can easily see the expert's points of contention via their outstanding property IDs. The operator's points of interest will be placed in the framework via various parameters arrangements, such as specialist ID and name, address of the operator, subtle specialist components, etc.
- Encrypting details of property rental: The CQUnited database scheme requires storing the order registration in the context for greater cooperation as well as monitoring. Throughout this manner, the ERD has planned in such a manner that the implementation allows clients, for instance, reservation date, property number, rental IDs with either a property reserving Identification number, to set aside strategy enrollment.
- Encrypting client details: This ERD is also planned to allow the client to withdraw the property from both the CQUnited database scheme in addition to many other leasing items through the help of database assignment.
Creation of Logical Design
Property Category (Category_Name (pk), Daily_Price)
Property Insuarance (Policy_Number (pk), Registration_Number (fk), Amount_Of_Premium, Insurer_Name, Policy_Start_Date, Expiry_Date)
Property Booking (Reservation_Number (pk), Registration_Number (fk), Category_Name (fk), Booking_Date, Booking_Description, Customer_ID (fk), Enquiry_ID (fk))
Location (Location_ID (pk), Location_Address, Location_Name)
Property (Registration_Number (pk), Builder, Model, Manufacturing_Date, Number_Of_Seats, Location_ID (fk), Category_Name (fk), Vehicle_Image)
QR_People (People_Id (pk), People_Category, Employee_ID (fk), Customer_ID (fk))
Customers (Customer_ID (pk), IndividualID (fk), CorpotrateID (fk), Full_Name, License_Number, Address, Phone_Number)
Employee (Employee_Id (pk), Salary, Last_Name, First_Name, DOB, Skill_Level, Annual_Salary, Rental_Employee_ID (fk), Booking Employee_ID (fk))
Booking Employee (Booking_Employee_ID (pk), Employee_Name, Main-Duty)
Rental Employee (Rental_Employee_ID (pk), Employee_Name, Main-Duty)
Corporate Customer (Corprate_ID (pk), Orga nization_Name, ABN, Travel_Deal_Validity)
Individual Customer (Individual_ID (pk), Individual_Name, Personal_Life_Insuarance_Details)
Enquiry (Enquiry_ID (pk), Customer_ID (fk), Issue)
Rental Details (Rental_ID (pk), Reservation_Number (fk), Booking_Date, Booking_Duration
Checkin_Time, Property_Location, Property_Cost, Property_Image, Rent_Employee_ID (fk))
Bibliography
Di Luca, M., Maccari, G., Maisetta, G., and Batoni, G. (2015). BaAMPs: The database of biofilm-active antimicrobial peptides. Biofouling. https://doi.org/10.1080/08927014.2015.1021340
Erwin, D. (2015). Industrial chemical process design. Statewide Agricultural Land Use Baseline 2015. https://doi.org/10.1017/CBO9781107415324.004
Frazer, K., Callinan, J. E., Mchugh, J., van Baarsel, S., Clarke, A., Doherty, K., and Kelleher, C. (2016). Legislative smoking bans for reducing harms from secondhand smoke exposure, smoking prevalence and tobacco consumption. Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD005992.pub3
Gilson, M. K., Liu, T., Baitaluk, M., Nicola, G., Hwang, L., and Chong, J. (2016). BindingDB in 2015: A public database for medicinal chemistry, computational chemistry and systems pharmacology. Nucleic Acids Research. https://doi.org/10.1093/nar/gkv1072
IEA. (2015). World Energy Outlook 2015 - Electricity Access Database. World Energy Outlook.
Iheozor-Ejiofor, Z., Worthington, H. V., Walsh, T., O'Malley, L., Clarkson, J. E., Macey, R., ... Glenny, A. M. (2015). Water fluoridation for the prevention of dental caries. Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD010856.pub2
Kranke, P., Bennett, M. H., Martyn-St James, M., Schnabel, A., Debus, S. E., and Weibel, S. (2015). Hyperbaric oxygen therapy for chronic wounds. Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD004123.pub4
Liddle, S. D., and Pennick, V. (2015). Interventions for preventing and treating low-back and pelvic pain during pregnancy. Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD001139.pub4
Lourenço, J. R., Cabral, B., Carreiro, P., Vieira, M., and Bernardino, J. (2015). Choosing the right NoSQL database for the job: a quality attribute evaluation. Journal of Big Data. https://doi.org/10.1186/s40537-015-0025-0
MacArthur, J., Bowler, E., Cerezo, M., Gil, L., Hall, P., Hastings, E., ... Parkinson, H. (2017). The new NHGRI-EBI Catalog of published genome-wide association studies (GWAS Catalog). Nucleic Acids Research. https://doi.org/10.1093/nar/gkw1133
Pillai Riddell, R. R., Racine, N. M., Gennis, H. G., Turcotte, K., Uman, L. S., Horton, R. E., ... Lisi, D. M. (2015). Non-pharmacological management of infant and young child procedural pain.
Cochrane Database of Systematic Reviews. https://doi.org/10.1002/14651858.CD006275.pub3
Riemann, D., Hertenstein, E., and Schramm, E. (2016). Mindfulness-based cognitive therapy for depression. The Lancet. https://doi.org/10.1016/S0140-6736(16)00660-7
