SQL Assignment Now that you have a fully developed proposal for the business database solution you chose, you will create a Requirements Document that contains the following information. You can continue to modify requirements and update your proposal as you work through this assignment. For this assignment, using the Course Project proposal you have written from Module 01 as a basis, think through and create an analysis phase Requirements document that contains the following sections:
1. A synopsis of the scenario you are creating a database for as laid out in your proposal.
2. A Needs Assessment section.
3. A Feasibility Assessment section.
4. An Alternatives Assessment section.
5. A Recommendations section (You are to use MySQL as the DBMS).
Consider the following sources of information that may help you with this part of the course project:
Your Requirements document should be 3-4 pages at a minimum.
In conclusion, the company can greatly profit from implementing a database management system in terms of improved inventory management, customer service, and decision-making. The database will be useful, secure, and accessible to the authorized members of the retail store thanks to the suggested data maintenance requirements, data grouping, and access controls. Lastly, the hypothetical trucking company business case shows the value of setting up a database management system to keep track of inventory such as trucks and trailers, loads routs, clients, and loads data. The plan emphasizes the advantages of keeping this information and how it can be divided into various categories. The plan also specifies who will have access to the data and how they will do so, as well as more details on security precautions, backup techniques, and audits. Overall, this plan offers a thorough analysis of how a database management system can help a retail company and keep critical data in a safe and accessible location. Module 01 Course Project - Propose a Business Situation The type of business I'm introducing is a trucking business and the company name is CEVA Logistics. The trucking company needs to maintain its data to keep track of their inventory, which is the trucks and trailers and customers, and also to provide better customer service. The information can be used for reporting and analytics, which can assist the company in making wise decisions. For the database access, the sales staff, the inventory management team, and the company manager will all have access to the database as authorized employees of the trucking establishment. Fleet managers will have access to the loads history and truckers' routes and may examine and make changes to them. The team in charge of loads, which are called dispatchers, will have the power to modify loads information, add or remove loads from trucks, and keep track of trucks, trailers and loads/load board. The data will be completely accessible to the shop manager for monitoring and decision-making needs. The company's data must be organized because the inventory, clients, and sales-specific groups will be created from the data. The object information, such as name, price, and quantity, will be included in the inventory data. The customer's name, contact information, transaction history, and personal preferences are all part of the customer data. The date, time, goods sold, and price paid are all part of the sales information. The additional information, the MySQL DBMS will be used to build the database on a standalone computer. Password protection and access controls will be used to safeguard the database. To guarantee that the data is secure in the event of a system breakdown or emergency, the database will undergo routine backups. Additionally, a routine audit of the database will look for any instances of data modification or unauthorized entry
