ALAMEDA Final Project

Table of Contents

Tab	Description	Page
	FINAL PROJECT FOLDER OUTLINE
	Title/Cover Page
	Table of Contents
I.	Executive Summary and Overview Section	I.
A.	Executive Summary
B.	Overview Section
1	Overview
2	System Design: Hardware & Software Required
3	Operational Functionality
4	Operational Procedures, including Hierarchy Menu
5	Description of Database Design, including SOM or ERD
6	Assumptions Made and System Limitations
7	Recommended Future Enhancements
8	End of Period Closeout Procedures
9	Test Procedures Followed
10	Anomaly Prevention and Data Integrity Controls
11	System Security and Control Features
C.	Conclusions and Recommendations
II.	Appendices Section	II.
	Appendix Table of Contents [Note: If you use different organization, you will need to include table of content subsections in each subsection]
A.	Diagrams
1	Semantic Object Diagrams [TableDesigner]
2	E/R Diagrams [Access or equivalent]
3	List of Relations [Word document or equivalent]
4	TableDesigner SQLGen.txt File
5	Menu Hierarchy Chart [Visio, Word, PowerPoint, or equivalent]
B.	Reports from TableDesigner & ACCESS
1	Object Summary Report [TableDesigner]
2	Relationships Report [Access Document Analyzer]
C.1.	Tables: TableViews, SELECTs, CREATEs & Load SQL Statements
1	Employee Create, Load, and Table View, SQL View
2	Skill_Info Create, Load, and Table View, SQL View
3	Next-of-Kin Create, Load, and Table View, SQL View
4	Project Create, Load, Table View, SQL View
5	Salary Create, Load, and Table View, SQL View
6	Training (if separate) Load, and Table View, SQL View
7	Code Tables:
8	Create, Load, and Table View, SQL View Following possible:
9	Skill_Code, Race_Code, Education_Code, Primary_Seconday_Code Add Sections as needed for you Project…
10	Job_Titles_Code, Citizenship_Code, Training_Code Add Sections as needed for your Project
11	Intersection Table Create, Load, and Table View, SQL View

Tab	Description		Page
	Appendices Cont.
C.2.	Views: TableViews, SELECTs, and Create SQL Statements
1	View1: List any views you used in the project here, not included in D. below
2	View2: List any views you used in the project here, not included in D. below
D.1.	Programs (SQL) & CREATE VIEWs Used in Database
1	1) EMPLOYEE VIEW: CREATE VIEW, SQL View & TableView
	Combines Employee + All related Code Tables, except SKILL & PROJECT
2	2) SKILL VIEW: CREATE VIEW, SQL View & TableView
	Combines Employee + Skill + Skill_Codes (if used)
3	3) PROJECT VIEW: CREATE VIEW, SQL View & TableView
	Combines Project + Employee
4	4) NEXT-OF-KIN VIEW: CREATE VIEW, SQL View & TableView
	Combines Employee + Next_of_Kin
5	5) INTERSECTION VIEW: CREATE VIEW, SQL View & TableView
	Combines Intersection Table with its related Tables
6	6) SALARY VIEW: CREATE VIEW, SQL View & TableView
Combines Purchase Order + Inventory Item + Vendor + InvItem/Vendor Intersection
7		7) MISCELLANEOUS VIEW: CREATE VIEW, SQL View & TableView
		Others you may need to build
8		Any other Simple Object VIEWs (Hwk7 or 8):PO, SALE INVOICE, COMMISSION, INVENTORY Add Sections as needed by your Project…
9		Total, Subtotal CREATE VIEWs
10		Range Tables; Age Report Views
11
D.2.		Menu System (Bonus)
		Top Level Program
		Level-2 Programs: CRUD [Create, Report, Update, Delete]
E.		Executed Report Programs & Procedures [SELECT stmts; Print out]
1		Employee Listing Report; with Skills
		Sorted by Employee last name, then first name
2		EMPLOYEES & PROJECTS: Sort by project name & start date
3		Insurance Company reports with required Next-of-kin data.
		Sort by Employee name
4		Federal Government Report(s) with COUNTs and Percentages by:
		a. minority worker category;
		b. gender
		c. age; and
		d. citizenship status.
5		State Government Report by Education Level of Worker
		Sort by education level & name
6		EMP. SKILL/TRAINING STATUS RPT: includes skills/training (both codes and description)
7		Employee Salary/History Report--Must include at their current title and salary at least.
8		Employee Roster with key data for each employee (name, address, phone, SSN, etc.). Indicate type of sorting in REPORT HEADING area.
9		Employee Project Report (sort by Project, Start Date, and Name, show skills)
10		Others as needed…
BON		Affirmitive Action Report SQL (BONUS)
		COBOL, JAVA, etc.
F.		Proof of Operation: Before/IUD/After; with SQL statements
1		EMPLOYEE
2		SKILL_INFO
3		NEXT_OF_KIN
4		PROJECT
5		SALARY
6		TRAINING (if separate)
7		INTERSECTION_X Table
8		RACE_CODES [Additional CODE tables as Required]]
9		CITIZENSHIP_CODES
10		EDUCATION_CODES
11		SKILL_CODES
12		JOB_CODES
G.		Bonus Points (OPTIONAL). Add more detail to your table of contents as required by requirements
1		Word Document Explaining Importing/Exporting.
		Listings of .EXP & .IMP files
		See Disk Under Final, Export and Imports Folder
2		Menu System (Working program). ID & Password functionality
3		COBOL Employee Commission Report
4		COBOL Inventory Summary Report
5		COBOL Update Program
6		Interactive Update Program