1. To perform physical database design 2. To develop queries

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.

Don't use plagiarized sources. Get Your Custom Essay on
1. To perform physical database design 2. To develop queries
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT!
Order Essay
Homework Market
Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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.

Zero-plagiarism guarantee

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.

Timely delivery of urgent papers

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.

Privacy policy

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 offer pre-written essays

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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency