1 2 2 What exactly is a subtype discriminator What does it tell you about a

1 2 2 what exactly is a subtype discriminator what

This preview shows page 2 - 6 out of 6 pages.

1)2)2
Background image
What exactly isa subtype discriminator? What does it tell you about a particular supertype instance?Why was the concept of entity “clusters” created? What value do they have in database design?Use onlythe EER diagram on page 6 of the exam to answer any of the next 2 questions.Why(not how) was the NURSE supertype broken down into subtypes? Be complete and precise.1) Can there be a Person who belongs to no subtype? 2) Can there be a Person who belongs to many subtypes? For each answer, draw the EER diagram element that supports it.1)2)3
Background image
Give one specificexample of how referential integrity could constrain the data entered by database users.What is similar about relations and tables? What is different between them?Use only the ER and EER diagrams on pages 5 and 6to answer any of the next 2 questions.Draw the logical schema of relations from the part of the ER diagram on page 5 that is fully inside the solid rectangle. Enforce 1NF. Assume that vendors are organizations.How many relations would be in the logical schema created from the part of the EER diagram completely inside the dashed rectangleon page 6? What would you name each of those relations?4
Background image
ER Diagram: Page 55
Background image
EER Diagram: Page 66
Background image

You've reached the end of your free preview.

Want to read all 6 pages?

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes