Overview: Database management plays an integral role in nearly every area of business.
Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible.
Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time.
This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data.
For your final project, you will apply the skills you learned in order to demonstrate your mastery of the key concepts necessary for effective database management. These are skills you will be able to apply to your future courses as well as your career in managing information systems.
Prompt: The third milestone assignment covers the final major concept of this course-data retrieval. In the first milestone assignment, you created a database from scratch. In the second milestone assignment, you made alterations to an existing database and manipulated the data within it.
For this assignment, you will apply what you learn about data retrieval to create some queries to extract insightful information from the database. Like in the first two assignments, you will use MySQL in the Codio learning environment. In addition to submitting the queries that you created, you will provide a written report explaining your work.
Directions: Your first two projects required you to manage databases and manipulate the data for the human resources and flight reservations systems. Fortunately, the scheduling system for SNHU Airlines is functional and does not require any modifications.
The company executives would like some reports on the employees' meetings though, so you have been asked to create some queries to extract information from the database. Refer to the Database Schema section for details on the database.