Computer Science Homework Help

Requirements: See PDF for detailed descriptions (Please Ensure you can complete the assignment by the giving time before bidding. Otherwise please dont bid).

Building upon your project 1 and project 2, the park will be a Star Wars themed park. You must design additional parts of the database and create the following SQL Script.

Step 1: Create table audits via triggers

The system must log any insertion, deletion, or updates to the following tables:

Employee table (project 1)

Job table (project 1)

ProjectMain table (Project 2)

ActivityMain table (Project 2)

For each one of the table above, you will write the SQL Script to create their respective AUDIT table which is a table that contains the same columns as the original table, plus the additional columns Operation and DateTimeStamp.

For example, for the EMPLOYEE table with the given columns, you will create EMPLOYEEAUDIT:

Employee -> EmployeeAudit

empNumber (char(8)), – empNumber (char(8)),

firstName (varchar(25)), – firstName (varchar(25)),

lastName varchar(25)), – lastName varchar(25)),

ssn (char(9)), – ssn (char(9)),

address (varchar(50)), – address (varchar(50)),

state (char(2)), – state (char(2)),

zip (char(5)), – zip (char(5)),

jobCode (char(4)) , – jobCode (char(4)) ,

dateOfBirth (date), – dateOfBirth (date),

certification(bit), – certification(bit),

salary(money) ) – salary(money) )

– Operation (varchar(50))

– DateTimeStamp (datetime)

Therefore, your assignment script will create the following 4 Audit tables:

– EmployeeAudit

– JobAudit

– ProjectMainAudit

– ActivityMainAudit

NOTE: You MUST use the above names for the audit tables