COP 4703 Group Project Overall 125 Points Your group is a consulting firm in the bidding process for a Database Implementation project. Your client, Disney, is creating a new park called StarWars Galaxy and would like to track schedules and budgeting for the construction of all the projects (facilities, rides, restaurants, etc.). and employees. The CIO would be evaluating your bid and has put out the following requirements for the system: Phase 1: 60 points (Due Mid-semester): Step 1: Create the tables An employee for Disney will have Employee Number, First Name, Last Name, SSN, Address, State, Zip, date of birth, certification, jobCode and salary. The available jobs are “Cast Member, Engineer, Inspector, and Project Manager” and an Employee can only have one job. When an employee gets paid, an entry will be made to a paycheck table, which will have a payId, Employee Number, periodBegin, periodEnd, payDate, GrossPay , Net Pay and containsBonus. You will create tables to hold employee data and job data: Table # 1 Name: Employee Columns and Data Types: empNumber (char(8)), firstName (varchar(25)), lastName varchar(25)), ssn (char(9)), address (varchar(50)), state (char(2)), zip (char(5)), jobCode (char(4)) , dateOfBirth (date), certification(bit), salary(money) ) Table # 2 Name: Job Columns and Data Types: jobCode (char(4), jobdesc(varchar(50)) Table #3 Name: Paycheck Columns and Data Types: payID (char(8)), empNumber(char(8)), periodBegin (date), periodEnd (date), payDate (date), GrossPay (money), NetPay (money), containsBonus(bit) Step 2: Constraints Next You will write the script to create constraints on these two tables. The following constraints must be created:
COP 4703 Group Project Overall 125 Points Your group is a consulting firm in the bidding process for a Database Implementation project. Your client, Disney, is creating a new park called StarWars Galaxy and would like to track schedules and budgeting for the construction of all the projects (facilities, rides, restaurants, etc.). and employees. The CIO would be evaluating your bid and has put out the following requirements for the system: Phase 1: 60 points (Due Mid-semester): Step 1: Create the tables An employee for Disney will have Employee Number, First Name, Last Name, SSN, Address, State, Zip, date of birth, certification, jobCode and salary. The available jobs are “Cast Member, Engineer, Inspector, and Project Manager” and an Employee can only have one job. When an employee gets paid, an entry will be made to a paycheck table, which will have a payId, Employee Number, periodBegin, periodEnd, payDate, GrossPay , Net Pay and containsBonus. You will create tables to hold employee data and job data: Table # 1 Name: Employee Columns and Data Types: empNumber (char(8)), firstName (varchar(25)), lastName varchar(25)), ssn (char(9)), address (varchar(50)), state (char(2)), zip (char(5)), jobCode (char(4)) , dateOfBirth (date), certification(bit), salary(money) ) Table # 2 Name: Job Columns and Data Types: jobCode (char(4), jobdesc(varchar(50)) Table #3 Name: Paycheck Columns and Data Types: payID (char(8)), empNumber(char(8)), periodBegin (date), periodEnd (date), payDate (date), GrossPay (money), NetPay (money), containsBonus(bit) Step 2: Constraints Next You will write the script to create constraints on these two tables. The following constraints must be created:
GroupProjectPhase1.docx