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
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Surname1
Name:
Professor:
Course:
Date:
Training and Management of Database
Background
Employee training is an important aspect for any organization that chooses to hire new
employees. New employees should feel a sense of belonging to the company or business and
they should know their way around the company. In a correctional facility training set up, there
exists a database management system where information about tracked cadet names, address,
contact information and instructors is stored. New officers therefore need to be equipped with
sufficient information to handle the technical issues surrounding this system.
Purpose
The purpose of database training is to equip new officers with sufficient knowledge that will aid
them in navigation around database systems in Delaware Department of Correction. They need
to be able to perform data entry for example enter name of cadets in the system, map each cadet
to instructors plus be able to interpret data modeling diagrams such as Entity Relationship
diagrams, Use case diagrams and their Logical and Physical interpretations.
Business Goals and Rules
Surname2
While automating data entry and storage in every business setting, all aspects need to be
considered during the process. The rules are: specification business rules, recognition rules, and
management and implementation rules.
Therefore there is need for scrutiny, detection, categorization, modeling, and certification of...