Database Assignment
For the following situation you need to DEFINE (produce SOR), DESIGN (Produce ERD and LDBD (RDM)), DEVELOP (DDL statements, DML data statements, and the DML information statements), DEPLOY(execute the above statements in either MS ACCESS or SQL Server), and OPERATE (run the data the Data Base System (DBS) to create the metadata, populate the data, and produce the information required.).
The DBS should accomplish the following:
A) Scenario:
Alpha Tech is a small manufacturer of smart home devices with 10 locations across the United States. The company is organized into 5 divisions aligned by their 5 major product lines. Each division has 4 functional departments (Marketing (determining the needs), Operations (satisfying the needs), Finance (funding the operations), and Human Resources (people performing the work).
The management of the Alpha Tech has contracted with you to create a system to track the required and elective Education and Training (E&T) courses for their employees.
The corporate HR department has identified the following categories of courses to be included:
1) Safety
2) Ethics
3) Diversity
4) Leadership
5) Teamwork
6) Quality Management
7) Communications
8) Customer Relations
9) Supplier Relations
10) Management
11) Marketing
12) Technical Training in the various positions and career fields
B) System Needs
The system should be able to allow the user to:
1) Look up the current Education and Training (E&T) status for a given employee by their ID number or their name to show whether required courses are completed, scheduled, or not yet planned.
2) Look up the current Education and Training (E&T) status for a given employee by their ID number or their name to show all the courses they have completed or scheduled.
3) Produce a list of all employees who have not completed a given course by course name or course ID.
4) Produce a list of all employees who have completed a given course by course name or course ID.
C) Deliverables:
Create the following deliverables:
1. A Statement of Requirements (SOR)
2. An Entity Relationship Diagram(ERD)
3. A Logical Data Base Design (LDBD) using a Relational Data Model (RDM)
4. The SQL Data Definition Language(DDL) statements
5. The SQL Data Manipulation Language (DML) data statements,
6. The SQL Data Manipulation Language (DML) information statements
7. The Output satisfying the SOR. (NOTE: Include either the screen prints of the digital output or images of the digital output generated by running these SQL statements.)
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.