Fix the following issues in the diagram. 1.Missing or extra tables including pri

Question

Fix the following issues in the diagram.
1.Missing or extra tables including primary key corrections.
2.Get rid of any Missing or incorrect fields
3. Get rid of any Missing or incorrect relationships including foreign key placement.
4. Add subtypes in the correct places in the diagram.
5. Get rid of all Many to Many relationships in the diagram.

Professional CE Provider Gende Provider Name Address Starte Date Main Phone Number submits Enrollment Application Enrollment ID ualifi Application ID Code SSN Numbe obtains Qualification License Type ID ction ID Renew License ID rm cation ID Decision Date ua ApplicationID has requires Qua Type License Section cense DocumentID Name Document ction Title CECourse ID Submission Date Section Number has requires ReviewID Term ApplicantFirst Name Room Number ApplicantLast Name Document Description License License ID Qual cationType SSN License Type ID cation eID ua Decision Date Qua cation Name Expiration Date DMQAStaff Staff D DepartmentID License ID Renew alID Hire Date Position ID LoginID cation ua cation ua License Type Degree Type Issue Date School Expiration Date Graduation Date InstructorEmployment oyment ID FEIN Employment Division has has nstructorID SSN nstructorStartDate has Lecturer nstructo struct o ProfessorType Lecturer Type enure Date CE Course CECourse ID FEIN Qual Course Number Course Name Course Hour

Explanation / Answer

Answer:

1.Missing or extra tables including primary key corrections.

primary keys are:

SSN in Professional

ApplicantId in Application

LicenceTypeId in LicenceType

LicenceId in Licence

QualifivationTypeId in degree and Licencing

Staffid in Dmaqstaff

QualifivationTypeId in Qualifivation Type

Cecourseid,coursenumber in cecourse

Documentid in DocumentId

SectionId,roomnumber inSection

QualificationId in Qualification

EnrollmentId in Enrollment

InstructorId in Instructor,professor and Lecturer

2.Get rid of any Missing or incorrect fields

Employeename inInstructorEmployment

3. Get rid of any Missing or incorrect relationships including foreign key placement.

Choose one of the relations-say S-and include a foreign key in S the primary key of T. It is better to choose an entity type with total participation in R in the role of S.

Merged relation option: An alternate mapping of a 1:1 relationship type is possible by merging the two entity types and the relationship into a single relation. This may be appropriate when both participations are total.

The M-to-M relationship is equivalent to two 1:M relationships .we can not assign primary key of 1 side as a foreign key of other for this purpose we use a middle entitiy that resolve an M:M and that entity is tipically called "association " or intersection entity.
4. Add subtypes in the correct places in the diagram.

Subtypes are in correct position
5. Get rid of all Many to Many relationships in the diagram.

a relationship between tables in a database when a parent row in one table contains several child rows in the second table, and vice versa. Many-to-many relationships are often tricky to represent.

1.Instructor to professor,lecturer

2.ApplicationId to qualification,doucmentaid,dmaqstaff

3.ceprovider of fein to instructoremployment of fein

4.Sectionid of section to sectioned of instructor and enrolment

5.cecourse id of section to cecourseid of cecourse

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.