Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 7RQ
a)
Program Plan Intro
Graphical representation of ERM (Entity Relationship Model) entity component:
Crow’s Foot entity box for “Student”
b)
Program Plan Intro
Graphical representation of ERM cardinality component:
The following table illustrates the different connectivity and participation combinations which are maintained by the Crow’s Foot notation:
Crow’s Foot cardinality notation
| Notation | Cardinality | Description |
 |
(0,N) | Zero or more instances |
 |
(1,N) | One or more instances |
 |
(1,1) | One instance |
 |
(0,1) | Zero or one instance |
c)
Program Plan Intro
Graphical representation of ERM entity component:
Crow’s Foot weak relationship symbol
d)
Program Plan Intro
Graphical representation of ERM entity component:
Crow’s Foot strong relationship symbol
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
What are the differences between weak and strong entity sets?
Given the ER diagram above, answer the following questions:
a. Name an entity type that has more than 2 relationships.
b. Name one ket attribute and the entity type it belongs to.
c. Name one one-to-one relationship and the entity types it relates.
d. Name one many-to-many relationship and its entity types.
e. Name one relationship attribute.
f. What is the cardinality of relationship ‘employs’?
g. What is the cardinality of relationship ‘textUsed’?
h. Name one weak entity type
i. Does it have a partial key? If yes, name it. ii. Name its identifying entity type
iii. Name its identifying relationship
Question 2 A bank provides services to customers. The banks is identified by its code and has a name and an address. The bank has several branches. A branch is identified by its code that is unique for a given bank. The branch name and address are also stored in the database.
Customers deal with the bank through the bank branches. So, a customer belongs to a specific bank branch. Customers…
For each entity, there needs to be an indication of whether it is one-to-one, one-to-many or many-to-many relationship. Here are the answers I have but I could use more guidance with it. I struggle with this type of question.
BOOK and BOOK COPY (1:1)
COURSE and COURSE-SECTION (M:N)
COURSE-SECTION and ROOM (M:1)
INSTRUCTOR and COURSE (1:M)
ROOM and INSTRUCTOR (M:1)
Chapter 4 Solutions
Database Systems: Design, Implementation, & Management
Ch. 4 - Prob. 1RQCh. 4 - What is a strong (or identifying) relationship,...Ch. 4 - Prob. 4RQCh. 4 - Suppose you are working within the framework of...Ch. 4 - Prob. 6RQCh. 4 - Prob. 7RQCh. 4 - Discuss the difference between a composite key and...Ch. 4 - What two courses of action are available to a...Ch. 4 - Prob. 11RQCh. 4 - Discuss two ways in which the 1:M relationship...
Ch. 4 - Prob. 13RQCh. 4 - Prob. 14RQCh. 4 - Briefly, but precisely, explain the difference...Ch. 4 - What are multivalued attributes, and how can they...Ch. 4 - Prob. 17RQCh. 4 - Prob. 18RQCh. 4 - What two attributes must be contained in the...Ch. 4 - Describe precisely the composition of the...Ch. 4 - Prob. 21RQCh. 4 - Prob. 1PCh. 4 - Create a complete ERD in Crows Foot notation that...Ch. 4 - Prob. 4PCh. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7PCh. 4 - Prob. 8PCh. 4 - Prob. 9PCh. 4 - Prob. 10PCh. 4 - Prob. 11C
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
- Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forwardFor each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-tomany or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.a. STUDENT and COURSE (students register for courses)b. BOOK and BOOK COPY (books have copies)c. COURSE and SECTION (courses have sections)d. SECTION and ROOM (sections are scheduled in rooms)e. INSTRUCTOR and COURSEarrow_forwardSpecifically, on which side of a many-to-one connection does the primary key of one entity function as a foreign key? There is a huge number of relationships specified on one side of the diagram. both from the inside and the outside It is possible to define two relationships at the same time. On the one hand, one connection is defined; on the other, another relationship is defined.arrow_forward
- What does an associative entity model? a.) Associative entities model pure relationships rather than entities. b.) Associative entities model entities that are independent. c.) Associative entities model the real-world scenarios of ways to look up data. d.) Associative entities model attributes and how they are linked to entities.arrow_forwardHow do you map a "Many to Many" relationship when mapping ER Diagram to Schema Select one: O a. Take the primary key of both entities and put them as foreign keys in a separate table O b. Take the primary key of entity in the second "Many" side and put it as a foreign key in the table representing entity in the first "Many" side O c. Take the primary key of entity in the first "Many" side and put it as a foreign key in the table representing entity in the second "Many" side O d. Take the primary key of entity in the "Many" side and put it as a foreign key in the table representing entity in the "full" sidearrow_forwardWhat is the precise definition of a weak entity type? What is the undisclosed information? Could you please provide an example? What is the definition of alternative specialization?What is my representation on the Entity-Relationship (ER) diagram? Please provide more context or information about the example and diagram you are referring to. What subject or topic is this related to?arrow_forward
- The question is in the image below.arrow_forwardHow do you map a "One to Many" relationship when mapping ER Diagram to Schema Select one: O a. Take the primary key of entity in the "Many" side and put it as a foreign key in the table representing entity in the "One" side O b. Take the primary key of entities the "One" and "Many" sides and put them as foreign keys in a separate table O c. Take the primary key of entity in the "Many" side and put it as a foreign key in the table representing entity in the "full" side O d. Take the primary key of entity in the "One" side and put it as a foreign key in the table representing entity in the "Many" sidearrow_forwardb. Draw an Entity Relationship diagram from each of the following descriptions. Include the attributes, primary keys (underlines) and the relationships in the diagram (like relationship in Access). i. Each of the department has many employees assigned to it, but each employee works for only one department. if. A customer can rent many videotapes from the video store. Each of the videotapes can be rented to many customers.arrow_forward
- In your group, you will need to create an entity relation (E-R) diagram using the Crow's foot symbols that models the problem. This will include: Summarise the ERM's components, and names the entities and their relationship (As given in the Textbook, p.143, Table 4.4) all entities, relationships (including names) and attributes that are relevant, primary keys identified, and include relationship participation - participation (optional / mandatory) symbols and cardinality. The E-R diagram should be completed using the standards of this unit. Use Microsoft Visio to create the E-R diagram.arrow_forwardWhat exactly are entity-relationship diagrams, and how do they come into play? What kind of symbol is utilized to represent a relationship? What is an associative entity, and how does it work? Give an illustration of your point.arrow_forwardUsing the above table structure, create a normalized Entity-Relationship Model (ERM). Identify Primary Key(s) and Foreign Key(s) for all the entities, connectivities and/or cardinalities, and relationships between the entities. As for Chen's ERM notation and the normalization, the level should be in Third Normal Form (3NF) and above. [Note: you do notneed to show the normalization process such as the functional dependency diagram.]arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
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:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning