Britt's DB Home    Purpose of the DB    Conceptual Schema

Mapping    Database     Back to Linda's Home Page

Conceptual Schema

Original Schema

EMPLOYEE

Name(Fname, Mname, Lname), Address(Street, City, State, Zip), ID Number(employee #, SSN), Phone, Sdate, Edate

 KSC TRAINING

Employee #, Course #, Ctitle, Class #, Hours, Months, Complete date, Exp. Date

 OSHA TRAINING

Emp. #, Title, Complete date

 SGS PRP STATUS

Emp. #, Pass ID, SSN, PRP, Area Access 

EMPLOYEE HISTORY

Emp. #, Peformance(Description), Project #, Date of Incidence, Current Date, Supervisor, Submitted By

Final Conceptual Schema

The KSC Training table was split into two tables, a KSC Class table and a KSC Course table, in order to comply with 3NF.

The Employee History table was split into two tables, an Evaluation Table and an Employee Warning table.

EMPLOYEE

Name(Fname, Mname, Lname), Address(Street, City, State, Zip), ID Number(employee #, SSN), Phone, Sdate

KSC Course

Course #, Ctitle, Hours, Months

KSC Class

Class #, Course #, Complete date, Exp. Date

OSHA TRAINING

Emp. #, Title, Complete date

 SGS PRP STATUS

Emp. #, Pass ID, SSN, PRP, Area Access 

Employee Warning

SubmitDate, ViolationDate, VSSN, VTime, VPlace, VDescription, SubmittedBy, Supervisor

Evaluation

ESSN, EDate, Rep_Official, Attitude, DrivingRecord, Education, Performance, SafetyRecord, Tools, WorkRelations, SelfImprovement, Attendance, Comments

Copyright © 2001 Linda Cook
Last modified: March,  2002