"Witch.Crafts LLC" (WC) has created a database of (not yet retired) witches. After intensive research WC found out that any witch owns at least one cat. They also found that a witch takes care of and develops such a close relationship with her cat(s), that the cat(s) would ultimately decease, if its witch would die (we are pleased to note that witches live forever). Also note that the database only contains cats that are being owned by witches. Please draw two sets of ERDs: the first set represents a strong relationship between witches and cats, while the second set shows a weak relationship between the two. Remember that you need to carefully craft, and identify, the primary/foreign keys. Also pay attention to the kind of line you use for depicting the relationships. You may leave out, however, any non-key attributes.String relationship:weak relationship:

Explanation: 1) In the above diagram, Witch is a strong entity and a strong entity will have an…

Answered: Please draw two sets of ERDs: the first…

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter10: Transaction Management And Concurrency Control

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

"Witch.Crafts LLC" (WC) has created a database of (not yet retired) witches. After intensive research WC found out that any witch owns at least one cat. They also found that a witch takes care of and develops such a close relationship with her cat(s), that the cat(s) would ultimately decease, if its witch would die (we are pleased to note that witches live forever). Also note that the database only contains cats that are being owned by witches.

Please draw two sets of ERDs: the first set represents a strong relationship between witches and cats, while the second set shows a weak relationship between the two. Remember that you need to carefully craft, and identify, the primary/foreign keys. Also pay attention to the kind of line you use for depicting the relationships. You may leave out, however, any non-key attributes.

String relationship:

weak relationship:

Expert Solution

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.