Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Power Of Numbers In Health Care A Students Journey In Data Analysis

Authors: Kaiden

1st Edition

8119747887, 978-8119747887

More Books

Students also viewed these Databases questions

Question

Examine various ways to think about the future.

Answered: 1 week ago