Part 1. For each of the following, state whether the relation is unnormalized, in 1NF, 2NF or 3NF. If it is not in 3NF, convert it to a set of relations in 3NF.

1. TimeSheet (Date, Employee#, HoursWorked, EmpName)

2. City-Rainfall (Month, Day, Year, Amount)

3. BankAccount (Account#, OwnerSSN, OwnerName, Balance)

4. School (ClassCode, ClassName, Credits, (StudentID, Grade, StudentName,

MajorCode, MajorName))

5. HeadCoach (University, Sport, SchoolNickname, HeadCoachName)

for example: (Mississippi, Football, Rebels, Luke)

6. Job-History (Emp#, StartDate, DeptCode, DeptName, JobTitle, Salary)

assume that an employee can be promoted (new StartDate) and a new entry

is added with new title, salary, etc.

7. BaseBall (City, League, Nickname, (Year, Wins, Losses))

City and League are required as key (ex. Chicago has Cubs in National league

and White Sox in American league.

Part 2. Design a set of normalized relations for the sample project (Benefits System) that we have been using. using the following information. State any assumptions you make. Use the format of tables shown in Part 1 to describe your collection of tables.

We need a table of employees that store their employee number, name, address, phone numbers and email address. We also need a table of benefits for each employee. Each employee is allowed to have benefits for health insurance, life insurance, and 401K. Additionally, each employee will have leaved that that can take. There must be other tables created also to allow the following actions. We need to keep track of all the leave the employee has taken and all the leave that they have requested and also if it has been approved or not. We can assume that there is one level of approval by their immediate supervisor. Supervisors should be able to see all leave requests for their approval.