1. Use MYSQL workbench to create database in MYSQL server. Create EER diagram in MYSQL
Workbench. Use MSQL workbench to create ad EER diagram (tables, relationships, PK, FK, indexes)
based on your logical database design (5 Marks)
2. Create database tables and any appropriate database views, stored procedures, triggers. Then,
enter hypothetical data records with into your tables (minimum 5 records in each table) (10 Marks)
3. Create Form using LibreBase or MySQL Work Bench (5 marks)
3.1 Create a Form for Car4U Manager to enter the information about Car4U cars
3.2 Create a Form for Car4U Manager to enter information about the Staff
3.3 Create a Form for Staff to enter the car rental information
4. Create the following Queries (MySQL Work Bench or LibreBase): (10 Marks)
Query 1: Give last name of all customers who are now renting a car from our company.
Query 2: Give make and colour of all cars currently rented out.
Query 3: For each completed rental, give the rental price and rental id.
Query 4: List last name of all managers.
Query 5: List last and first names of all customers.
Query 6: Give a query that answers the question “Is any of our employee also our customer”?
Query 7: List customers sorted by their rental history (measured in Days) from high to low.
Query 8: Find rental id of all completed rentals.
Query9: Find the value of the cheapest (completed) rental. Utilise query 3 as the inner query.
3
Query 10: Give makes of the cars that have never been rented.
Since all our papers are written from scratch, the papers we submit are plagiarism free and we strictly adhere to lecturer’s instructions. Our writers are highly qualified from all over the world and include graduates and professors from most of the largest and known universities in the world. Once you have assigned us your assignment, we select the most qualified and reliable writer to handle your assignment.
Unlike other writing companies, we encourage clients to draw back their money at any stage of the writing process if they experience any uncertainties with the quality of generated content. However, you will hardly have to make this decision because of our business approach that suits your needs.
We have an advanced plagiarism-detection system that flags any work that fails to meet the required academic expectations. Our company thrives in honesty, and as such, you will be guaranteed to achieve a paper that meets your expectations.
At homeworkpaper.org we have online agents that you can chat with to have your assignment taken care of with the little remaining time. Also, we have professional academic writers who will work on your assignment providing you with a high-quality paper at the same time. We can take care of your urgent assignments in less than 5 hours.
We uphold confidentiality and privacy through our interactions with clients, an aspect that has enhanced our relationship with prospective customers seeking for assignment help. We do not disclose your information with third-parties; neither do we share your work with any other person apart from you.
We do not resell previously-done tasks delivered to other clients. When we deliver orders to our clients, we safeguard their privacy and confidentiality by ensuring the third party does not access the work. By writing the papers from scratch, we have managed to maintain a certain level of originality, which defines our business model. Our qualified editors proofread all submitted work to eliminate mistakes that can interfere with the credibility of the assignment.
