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.
Professional homework help features
Our Experience
However the complexity of your assignment, we have the right professionals to carry out your specific task. ACME homework is a company that does homework help writing services for students who need homework help. We only hire super-skilled academic experts to write your projects. Our years of experience allows us to provide students with homework writing, editing & proofreading services.Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How our professional homework help writing services work
You first have to fill in an order form. In case you need any clarifications regarding the form, feel free to reach out for further guidance. To fill in the form, include basic informaion regarding your order that is topic, subject, number of pages required as well as any other relevant information that will be of help.
Complete the order formOnce we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignmentAs soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download