Requirements

Create a normalized ER diagram in MySQL Workbench for the database described in your Requirements Document (listed below).

Take a screen shot of the ER diagram.

Using Workbench, create a Forward Engineered SQL script from the ER diagram.

Run the Forward Engineered SQL script to implement the database in MySQL. This must include the creation of all tables and relationships given in the ER diagram.

Use MySQLs CLI to:

Output a list of the tables that exist in the database.

Output the structure of each table.

Take a screen shot of all of these outputs.

Deliverables

Copy the following items in to a Word document.

The screen shot of the completed ER diagram in Workbench.

The script that was created by Forward Engineering the ER diagram in Workbench.

The MySQLs CLI screen shot of the list of tables in the database.

The MySQLs CLI screen shots of the structures of all of the tables in the database.

**Requirements Document**

Synopsis: The Detail My Ride mobile auto detailing service is the subject of the proposed database. Currently, the company's CEO and owner, who also employs three workers, travels to customer locations to service cars using his personal vehicle. The database will be used to keep track of expenses related to using vehicles for the business, employee mileage and gas expenses, employee documentation and background checks, client information, client credit card info for any repeat customers, payroll processing, and supply orders. The database will also be used by the business owner to generate leads, collect customer and demographic information, and carry out tasks to send promotional mail and emails based on the data gathered. The database will also schedule and execute upcoming appointment emails, referral promotions for repeat customers, and any billing or past due balances that incurred amongst any customers. The entire server host (not just the MySQL server) must be completely protected from all forms of relevant threats.

Needs Assessment: To keep track of expenses and employee information, a database management system is necessary. Detail My Rise plans to rapidly expand its clientele base with more travel time and servicing more areas. MySQL can handle the capacity to manage rising data storage and processing demands. Feasibility Evaluation: Using a database management system for Detail My Ride is possible since it will enable the company owner to keep track of all records in one location, automate reminders, increase clients, and recruit more staff. The business owner also has an Amazon business account which could be integrated with the database.

Alternatives Assessment: One alternative to using a database management system would be to manually keep track of all records, expenses, and employee information. However, this would be time-consuming and less efficient. Another alternative could be using a cloud-based system like 3 Sarah Vanos Amazon Redshift. However, it is recommended to use MySQL as it is widely used, open-source and has a wide range of supported libraries and community support.

Recommendations: It is advised that MySQL be used as the database management system for Detail My Ride based on the needs and viability analysis. MySQL is a widely used, open-source system that has a wide range of supported libraries and community support. Additionally, MySQL provides strong security capabilities that help safeguard sensitive data and satisfy regulatory standards. To guarantee accurate and consistent data across all systems, MySQL may also be readily linked with other systems and applications, such as inventory management or accounting software. Also, Access Control Lists (ACLs)-based security is used by MySQL for all connections, queries, and other activities that users can attempt to carry out. Additionally, SSL-secured communications between MySQL clients and servers are supported. To enable the company owner and employees to access the database management system from any place and device, it is advised to utilize a web-based interface. It is recommended to use a web-based interface for user interface and user experience so that business owners and employees can access the database management system from any location and device. Additionally, a mobile application can be created so that employees can clock in and out and manage their schedules. The business owner can get real-time insights into the operation's success and expansion by integrating a powerful reporting and dashboard system. To guarantee that all data is safeguarded in the event of system failure or data loss, it is also advised to incorporate a system of backups and disaster recovery. To make sure the system is operating at peak efficiency and to handle any potential problems, routine maintenance and support should also be planned.