Complete the following relational database design problems.

1. Consider that a student has the following associations.

Student(IDNumber, Name, Dorm, DormName, DormAddress, RoomNumber, RoomType, DormCost, Club, ClubCost, PhoneNumber1, PhoneNumber2)

These associations can be explained as follows.

A student attending a university has an assigned ID number, and a name. The student is assigned to a dormitory (residence hall) where the student is assigned to a room. The student must pay a cost associated with the room and dormitory based on the room type. The dormitory has a name and an address. Students may belong to a club, and some clubs have a cost associated with joining the club. A student may have one or more phone numbers where they can be reached.

a. Identify appropriate entities and attributes appropriate for 3NF

2. Consider that a class at a university has the following associations.

Class( IDNumber, Name, Semester, Description, CreditHours, TestNumber, TestAverage, Professor, DepartmentID, DepartmentName, NumberofStudents, RoomNumber, Period, PeriodStart, PeriodEnd)

These associations can be explained as follows.

A class has an ID number, name, description, and a specific number of credit hours. A class is taken in a specific semester and during a specific period (essentially the day of the week and the time range in which the class is given). A professor teaches the class. The professor is part of a department. The class is assigned a specific room number, and the class has a specific number of students during a given semester.

In a class, several tests may be given over the course of a semester.

a. Identify entities and appropriate attributes appropriate for 3NF