Question: Reconsider Problem 2 ( Fillmore Tutorial Services ) from last week s assignment on ER Diagrams.Please use the ER Diagram that I handed out in

Reconsider Problem 2(Fillmore Tutorial Services) from last weeks assignment on ER Diagrams.Please use the ER Diagram that I handed out in class as the basis for your database design.Develop the database design using the correct ER Diagram. Dont forget to include the following tables with associated attributes:Customer (Last Name, First Name, DOB, Email, Phone)Lesson (LessonTitle, Description, Prerequisites, StartDate, EndDate, Time)PrivateLesson (SpecialAccommodations)GroupLesson (MaxClassSize, GroupProjectRequired?, ExaminationDate)Instructor (LastName, FirstName, SSN, Phone, Email)Subject(SubjectName, Description)Building (BuildingName, Address, City, State, Zip)Room (Room#, MaxCapacity, ComputersAvailable?, SpecialEquipment)In addition to the above attributes, please store information onDateOfEnrollment, which is the date a customer signed up for a particular lesson.In addition, please store information onYearsOfExperience, which is the number of years of experience an instructor hasteachingin a particular subject area.For each table:1) specify the table name followed by the attributes2) underline the attribute(s) that represent the primary key(Note: You will need to create the primary key if it doesnt already exist).3) asterisk the attributes that represent foreign keys (single asterisk for a non-unique foreign key and double asterisk for a unique foreign key)4) Please avoid storing attributes twice. In general, unless an attribute is a foreign key, an attribute does not need to be stored more than once.Use the following notation in specifying your tables:Employee (EmployeeNumber, FirstName, LastName, DOB, SSN, LicenseNum**, DeptID*)where the primary key of the table is underlined, a non-unique foreign key has a single-asterisk and a unique foreign key has a double-asterisk.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!