Write a 1000 words report on database design and its implementation based on the scenario below Currently, there is no database being used for managing the information in the Car Rental Report Excel spreadsheet.

Write a 1000 words report on database design and its implementation based on the scenario below

Currently, there is no database being used for managing the information in the Car Rental Report Excel spreadsheet. The report should include the following:

• An answer to the following question, together with a justification for the decision: In its current form, it is a traditional database. Should you keep it that way?
• The detailed process of implementing the database using SQL, including the normalization of the table (should that be required), the identification of the attributes, the Entity Relationship Diagram, and the use of SQL commands in order to create and populate the tables with data.
• The SQL code for the following queries together with an explanation of the code:
  1. Find the supervisors of the branches which rented out SUVs and output the supervisor's ID and name.
  2. Find the supervisors of the branches which had bills higher than 500 and output the supervisor's ID and name.
  3. Find the supervisors of the branches which rented out cars in May 2021 and output the supervisor's ID and name.
  4. Find the supervisors of the branches which handed out penalties and output the supervisor's ID and name.
  5. Find the type of car that was rented the highest number of times output the car type and the number of times.
• A choice of 4 types of graphs suitable for analyzing the information in the database, their implementation in Python (both the code and the output graph itself should be included in the report), and an explanation of what the graphs illustrate in your own words.

This Database Systems Assignment has been solved by our Database Systems Expert at Exam Question Bank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Styles. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.