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 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, PhoneLesson LessonTitle Description, Prerequisites, StartDate, EndDate, TimePrivateLesson SpecialAccommodationsGroupLesson MaxClassSize GroupProjectRequired?, ExaminationDateInstructor LastName FirstName, SSN Phone, EmailSubjectSubjectName DescriptionBuilding BuildingName Address, City, State, ZipRoom Room# MaxCapacity, ComputersAvailable?, SpecialEquipmentIn 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: specify the table name followed by the attributes underline the attributes that represent the primary keyNote: You will need to create the primary key if it doesnt already exist asterisk the attributes that represent foreign keys single asterisk for a nonunique foreign key and double asterisk for a unique foreign key 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 DeptIDwhere the primary key of the table is underlined, a nonunique foreign key has a singleasterisk and a unique foreign key has a doubleasterisk.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
