Class Project: Database management systems are key element of information technology systems that are used on a day-to-day basis by many organizations. The keys to using a database management system are to collect the necessary requirements for the database, translate these requirements into a database design, create the database from the design, load data into the database, and finally to perform manipulations of the database. The purpose of this final assignment is to ensure that you understand and can carry out the necessary tasks in order to manage a sample database.
From a high-level standpoint, this final project consists of the following steps:
1. Selection of a database.
2. Identifying the requirements for the database based on the purpose for the database and the data to fill the database.
3. Create a database design based on the requirements for the database, create the physical database, and load data into the database.
4. After loading the database, carry out sample queries that would be performed on the actual database. Show the results of the sample queries.
This project will consist of a series of steps defined in the prompts of the assignment. Some of the prompts are necessary to properly prepare for the manipulation of the database whereas others will be necessary for you to complete to demonstrate your competence with the concepts of this topic. The answers to these prompts will be examined against the actual expected answers to the prompt. All prompts that will be assessed against a answer key, meaning that you will get either full, partial, or no points per prompt.