Question description
I would like help putting together my final project. I am attaching everything that has been done on this project thus far. Please see below description:
This final course project is to develop an individual project plan that focuses on the database aspects of the project development lifecycle. All design, research, and work by each student will be original work in the design and creation of a new database. Students will become familiar with data management, database modeling and design, and skills to develop a final project plan. These requirements include the following:
Requirements Analysis –
- Background
- Purpose
- Business goals and rules
- User requirements
- Data requirements
- Reporting requirements
- Project schedule and project costs
- Data model – In physical design format original student design
- Data dictionary for all tables in data model
- SQL statements:
- CREATE TABLE statements (for entities (tables defined in model)
- Minimum of two SELECT statements
- At least one insert, update, or delete statement.
- Identify the database management system (DBMS) that will be used for the database design
- Create a basic database back-up and recovery plan
