Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm just starting my ER Diagram in MySQL, I need help assigning the right names and types to the table. Some guidance please! I have

I'm just starting my ER Diagram in MySQL, I need help assigning the right names and types to the table. Some guidance please!

I have a mock business named Detail My Ride, a mobile car detailing business. I will attach the full requirements document and a screenshot of my start. Am I even doing this right? Would the first table I create customer? If so, then what types do I check or uncheck? Then after name do I add a new table for their address and credit card information or does it go under the customer table? Help please!

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.

image text in transcribed

Templates timestamps create_time, update_time user username, email, password, cr... category category_id, name

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Image Databases Towards Advanced Image Retrieval

Authors: Yihong Gong

1st Edition

1461375037, 978-1461375036

More Books

Students also viewed these Databases questions

Question

state what is meant by the term performance management

Answered: 1 week ago