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: \table[[???,A,B,C,D,E,F,G,HYou 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
100493 Monica Geller F Long Island, NY Chef 295051 Y 2
100493 Monica Geller F Long Island, NY Chef 325302 N
103820 Ross Geller M Long Island, NY Paleontologist 187222 Y 1
103820 Ross Geller M Long Island, NY Paleontologist 170064 Y 1
103820 Ross Geller M Long Island, NY Paleontologist 336910 Y
103820 Ross Geller M Long Island, NY Paleontologist 381005 N
103820 Ross Geller M Long Island, NY Paleontologist 560325 N
170064 Rachel Greene F Long Island, NY Fashion buyer 244237 N
170064 Rachel Greene F Long Island, NY Fashion buyer 103820 Y 1
170064 Rachel Greene F Long Island, NY Fashion buyer 174544 N
170064 Rachel Greene F Long Island, NY Fashion buyer 439646 N
174544 Joey Tribbiani M Queens, NY Actor 170064 N
174544 Joey Tribbiani M Queens, NY Actor 560325 N
174544 Joey Tribbiani M Queens, NY Actor 310040 N
187222 Carol Willick F Stamford, CT Teacher 103820 Y 1
187222 Carol Willick F Stamford, CT Teacher 473008 Y
244237 Barry Farber M Long Island, NY Orthodontist 170064 N
295051 Chandler Bing M Las Vegas, NV IT 381005 N
295051 Chandler Bing M Las Vegas, NV IT 100493 Y 2
310039 Phoebe Buffay F Ithaca, NY Musician 400094 Y
310039 Phoebe Buffay F Ithaca, NY Musician 504378 Y
310039 Phoebe Buffay F Ithaca, NY Musician 362041 N
310040 Ursula Buffay F Ithaca, NY Actress 174544 N
310040 Ursula Buffay F Ithaca, NY Actress 362041 N
325302 Richard Burke M Long Island, NY Ophthalmologist 100493 N
336910 Emily Waltham F London 103820 Y
362041 Eric Penn M Los Angeles, CA Teacher 310039 N
362041 Eric Penn M Los Angeles, CA Teacher 310040 N
381005 Janice Hosenstein F Queens, NY 103820 N
381005 Janice Hosenstein F Queens, NY 295051 N
400094 Duncan Sullivan M Toronto Ice dancer 310039 Y
439646 Tag Jones M Boulder, CO Assistant 170064 N
473008 Susan Bunch F Columbus, GA Director 187222 Y
504378 Mike Hannigan M Manhattan, NY Musician 310039 Y
560325 Charlie Wheeler F San Francisco, CA Paleontologist 103820 N
560325 Charlie Wheeler F San Francisco, CA Paleontologist 174544 N
 Draw an ER diagram using the infromation below. Please draw out

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!