For your final project, you will be required to select a business problem and develop a database that addresses the identified issue. The problem you choose must be relevant and should be related to an industry or business sector that you have an interest in.
Your database should comprise a minimum of five tables, each designed to store relevant data that is necessary to support the business operations. It is crucial to ensure that the tables are appropriately designed and normalized to prevent redundancy and ensure data integrity. To further ensure data accuracy and consistency, sample data should be included when developing the tables, and relationships between them should be created.
In addition to developing the database, you will also need to create at least ten queries that provide essential information required by the business to run effectively. The queries should be designed to retrieve data from the tables in a way that facilitates decision-making and supports the overall objectives of the business.
As you undertake the project, it is essential to keep in mind that the ultimate goal is to develop a functional database that provides insights into the business’s operations and supports decision-making. Therefore, it is essential to plan carefully and ensure that the database design, data entry, and query construction are all geared towards achieving the project’s overall objective.
Be sure to create a Lucid Chart diagram and create the appropriate SQLite files. Turn in your .db file, the .sql file and a screenshot of your Lucid Chart diagram. Please provide a PDF that demonstrates the connection between your database and the supported business. It is important to arrange the content in a way that highlights how your database is adding value to the business.