Q1. ER Model . Create an ER Model for the following: A customer (eg. Tom) may (or may not) give references to many other customers (e.g., Mary and Jim). At the same time, the customer (e.g., Mary) who receives a reference may (or may not) give references to many other customers (eg. Lee and Susan). The attributes of the CUSTOMER entity are CustomerID, FirstName, LastName and PhoneNo.

Q1. ER Model . Create an ER Model for the following: A customer (eg. Tom) may (or may not) give references to many other customers (e.g., Mary and Jim). At the same time, the customer (e.g., Mary) who receives a reference may (or may not) give references to many other customers (eg. Lee and Susan). The attributes of the CUSTOMER entity are CustomerID, FirstName, LastName and PhoneNo.

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

Similar questions

For each of the following collection of entities, give the assumptions concerning the relationship between entities and attributes. EMPLOYEE(EMP_NUM, EMP_LNAME, EMP_INITIAL, EMP-DOB) DEPENDENT(EMP_NUM, DEP_NUM, DEP_FNAME, DEP_DOB)
Strongen a weak entity set by adding primary key attributes. Please explain our choice's overlap.
According to the university database that we explain in the class, explain how functional dependencies can be used to indicate the following: • A one-to-one relationship set exists between entity sets student and instructor. A Many-to-one relationship set exists between entity sets student and instructor
Just what does "weak entity type" mean? Is there a secret to it? Can you explain the meaning of "attribute"?How does sia look like on an ER chart? Please illustrate with a diagram.
Is there a need for creating an associative entity? If so, draw one, if not, then suggest why?
In an entity-relationship model, which of the following is a kind of attribute that should have some value, thus cannot be left empty? Choose an answer A Multivalued attribute B Required attribute C Simple attribute D Optional attribute
Use ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.
What's the difference between weak and strong entity sets?
Describe how functional dependencies may be used to denote the following:• The entity sets student and teacher have a one-to-one relationship set.• There is a many-to-one connection set between the entity sets student and teacher.
Every weak entity set can be converted to a strong entity set by simply adding theappropriate attributes. Why, then, do we have weak entity sets?
Any weak entity set can be turned into a strong entity set by just adding the right properties. So, why are our entity sets so bad?
We can convert any weak entity set to a strong entity set by simply adding appropriate attributes. Why, then,do we have weak entity sets? (a) We want to avoid the data duplication and consequent possible inconsis- tencies caused by duplicating the keyof the strong entity set.(b) Weak entities reflect the logical structure of an entity being dependent on another entity.(c) Weak entities can be deleted automatically when their strong entity is deleted.(d) All of the above.