Question: Draw an ER diagram using the infromation below. Please draw out and show the finished drawn diagram: table [ [ ? ? ? ,
Draw an ER diagram using the infromation below. Please draw out and show the finished drawn diagram: tableABCDGHYou are building a database tracking romantic relationships in a network of friends.
Assume that all people in the data have at least one romantic relationship. Dont forget to denote entities, attributes,
and relationships including cardinality and modality PersonID PersonName Sex Hometown Occupation Partner Married Children
Monica Geller F Long Island, NY Chef Y
Monica Geller F Long Island, NY Chef N
Ross Geller M Long Island, NY Paleontologist Y
Ross Geller M Long Island, NY Paleontologist Y
Ross Geller M Long Island, NY Paleontologist Y
Ross Geller M Long Island, NY Paleontologist N
Ross Geller M Long Island, NY Paleontologist N
Rachel Greene F Long Island, NY Fashion buyer N
Rachel Greene F Long Island, NY Fashion buyer Y
Rachel Greene F Long Island, NY Fashion buyer N
Rachel Greene F Long Island, NY Fashion buyer N
Joey Tribbiani M Queens, NY Actor N
Joey Tribbiani M Queens, NY Actor N
Joey Tribbiani M Queens, NY Actor N
Carol Willick F Stamford, CT Teacher Y
Carol Willick F Stamford, CT Teacher Y
Barry Farber M Long Island, NY Orthodontist N
Chandler Bing M Las Vegas, NV IT N
Chandler Bing M Las Vegas, NV IT Y
Phoebe Buffay F Ithaca, NY Musician Y
Phoebe Buffay F Ithaca, NY Musician Y
Phoebe Buffay F Ithaca, NY Musician N
Ursula Buffay F Ithaca, NY Actress N
Ursula Buffay F Ithaca, NY Actress N
Richard Burke M Long Island, NY Ophthalmologist N
Emily Waltham F London Y
Eric Penn M Los Angeles, CA Teacher N
Eric Penn M Los Angeles, CA Teacher N
Janice Hosenstein F Queens, NY N
Janice Hosenstein F Queens, NY N
Duncan Sullivan M Toronto Ice dancer Y
Tag Jones M Boulder, CO Assistant N
Susan Bunch F Columbus, GA Director Y
Mike Hannigan M Manhattan, NY Musician Y
Charlie Wheeler F San Francisco, CA Paleontologist N
Charlie Wheeler F San Francisco, CA Paleontologist N
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
