Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 14 You are hired as a consultant to work on a new social networking website, and you find that the database will be constructed
QUESTION 14 You are hired as a consultant to work on a new social networking website, and you find that the database will be constructed according to the following ERD: Invites Inviter 0.* Person personId {PK} firstName lastName 0. * Invitee O a. Inviter(personld, firstName, lastName) Invitee(personld, firstName, lastName) b. Person(personld, firstName, lastName, inviter) Person(personld, firstName, lastName, invitee) d. Person personld, firstName, lastName) Invites(inviter, invitee) QUESTION 15 Assume that the following portion of a generic ERD is given, with Relationship connecting Some Entity and AnotherEntity. Attributes are intentionally hidden for this question: SomeEntity Relationship AnotherEntity Which of the following must be true in a completed version of this diagram? a. SomeEntity doesn't have to participate in this relationship. AnotherEntity doesn't have to participate in the relationship but has a cardinality of many SomeEntity has to participate in this relationship and has a cardinality of one O d. AnotherEntity has to participate in this relationship. QUESTION 16 Given the following ERD, identify the correct translation: Slayer Vampire Kills 0..1 slayerid {PK} name gender vampId {PK} iscount isSparkly killDate a. Who CouldKill Him(OMG, hesSoSparkly, squeal) b Slayer(slayerld, name, gender) Vampire(vampld, isCount, isSparkly, killDate, slayerld) Slayer(slayerld, name, gender) KillskillDate Vampire(vampld, isCount, is Sparkly, slayerld) d. Slayer(slayerld, name, gender) Killsvampld, killDate, slayerld) Vampire(vampld, isCount, isSparkly)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started