Used Car Showroom Database ImplementationBusiness Use Case:A used car showroom wants to develop a database system to manage its operations. The system should keep track of cars, customers, sales, employees, and maintenance records. The database will be used to store and retrieve information efficiently and ensure data integrity.Tasks:$1.$ Identify Tables and Attributes:a$.$ Based on the use case, identify at least five tables required for the usedcar showroom database$\mathrm{.}2.$ Define appropriate attributes for each table.a$.$ Identify candidate keys and primary keys for each table. $3.$ Create Tables:a$.$ Write SQL scripts to create the identified tables with the defined attributes, including constraints for candidate keys, primary keys, and foreign keys$\mathrm{.}4.$ Insert Data:a$.$ Insert sample data into each table to represent realistic showroomscenarios$\mathrm{.}5.$ Create Database Diagram:a$.$ Generate a database diagram that includes all the tables and their relationships$\mathrm{.}6.$ Run SELECT Queries:a$.$ Execute SELECT queries to retrieve and display the data from each table$\mathrm{.}7.$ Documentation:a$.$ Include screenshots of the database diagram and the results of your Rubric:SELECT queries in your submission. Task Points Identify tables and attributes $10$ Define candidate keys and primary keys $10$ Create tables as per the identified schema $20$ Assignment Lab $01|7\mathrm{.}5\%$ of the final Grade Individual Assignment $|$ Due May $29$ Task Points Insert sample data correctly $20$ Generate database diagram $20$ Run and document SELECT queries $10$ Include screenshots of diagram and queries