"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 System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

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.

Similar questions