13th Edition

ISBN: 9780134773650

Author: Hoffer

Publisher: PEARSON

Concept explainers

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of …

Videos

Textbook Question

Chapter 4, Problem 4.28PAE

For each of the following E-R diagrams from Chapter 2 C:

Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).
For each relation, diagram the functional dependencies (see Figure 4-23 for an example).
If any of the relations are not in 3NF, transform them to 3NF.

Figure 2-8
Figure 2-9b
Figure 2-11a
Figure 2-11b
Figure 2-15a (relationship version)
Figure 2-15b (attribute version)
Figure 2-16b
Figure 2-1912

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Chapter 4, Problem 4.27RQ

Chapter 4, Problem 4.29PAE

Students have asked these similar questions

Draw the Dependency Diagram that is in 3NF for each relation. For each relation show the level of Normalisation achieved, and for any not in Third Normal Form, explain why. Show PK and FK for each relation. Relational data structures that translate the above ER diagram, which includes relation names, attribute names and field types primary keys identified

Map the ER diagram below to a set of relations (i.e., relational schema). Underline the primary key attributes of each relation. Indicate referential integrity constraints using arrows. An arrow from an attribute A to an attribute B represents that A references

Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS). NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION. We want to build a database for a community of paleontologists, storing information about the fossils kept in different museums. Each fossil is described by the year and place of discovery, the name of the paleontologist who discovered it, the room where it is exposed, and the presumed species. Each fossil may be assigned to different species with different degrees of probability. Museums are characterized by their rooms, their paleontologists and…

Chapter 4 Solutions

Modern Database Management

Ch. 4 - Define each of the following terms: determinant...Ch. 4 - Prob. 4.2RQ Ch. 4 - Prob. 4.3RQ Ch. 4 - Describe the primary differences between the...Ch. 4 - Summarize six important properties of relations.Ch. 4 - Describe two properties that each candidate key...Ch. 4 - Describe the three types of anomalies that can...Ch. 4 - Demonstrate each of the anomaly types with an...Ch. 4 - Fill in the blanks in each of the following...Ch. 4 - What is a well-structured relation? Why are...

Ch. 4 - Prob. 4.11RQ Ch. 4 - Describe how the following components of an E-R...Ch. 4 - Prob. 4.13RQ Ch. 4 - Prob. 4.14RQ Ch. 4 - Briefly describe four typical problems that often...Ch. 4 - Prob. 4.16RQ Ch. 4 - Explain how each of the following types of...Ch. 4 - Prob. 4.18RQ Ch. 4 - Prob. 4.19RQ Ch. 4 - Prob. 4.20RQ Ch. 4 - Prob. 4.21RQ Ch. 4 - What is the relationship between the primary key...Ch. 4 - Prob. 4.23RQ Ch. 4 - Explain what can be done with primary keys to...Ch. 4 - Prob. 4.25RQ Ch. 4 - Explain three conditions that suggest a surrogate...Ch. 4 - Prob. 4.27RQ Ch. 4 - For each of the following E-R diagrams from...Ch. 4 - Prob. 4.29PAE Ch. 4 - Prob. 4.30PAE Ch. 4 - For your answers to the following Problems and...Ch. 4 - Figure 4-3212 shows a class list for Millennium...Ch. 4 - Prob. 4.33PAE Ch. 4 - Prob. 4.34PAE Ch. 4 - Prob. 4.35PAE Ch. 4 - Prob. 4.36PAE Ch. 4 - Prob. 4.37PAE Ch. 4 - Prob. 4.38PAE Ch. 4 - Prob. 4.39PAE Ch. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - The Public Safety office at Millennium College...Ch. 4 - Prob. 4.42PAE Ch. 4 - Prob. 4.43PAE Ch. 4 - Prob. 4.44PAE Ch. 4 - For your answers to Problem and Exercise 3-33 from...Ch. 4 - Prob. 4.46PAE Ch. 4 - Prob. 4.47PAE Ch. 4 - Figure 4-38 includes an EER diagram for a...Ch. 4 - Prob. 4.49PAE Ch. 4 - Prob. 4.50PAE Ch. 4 - Prob. 4.51PAE Ch. 4 - Prob. 4.52PAE Ch. 4 - Figure 4-40 shows an EER diagram for a university...Ch. 4 - Explore the data included in Table 4-9. Assume...Ch. 4 - Prob. 4.55PAE Ch. 4 - Prob. 4.56PAE Ch. 4 - Prob. 4.57PAE Ch. 4 - Prob. 4.58PAE

Additional Engineering Textbook Solutions

Find more solutions based on key concepts

A(n) ____ method stores a value in a field or changes the value of a field in some other way. a. modifier b. co...

Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)

T F: Changing an objects Text property also changes the objects name.

Starting Out With Visual Basic (7th Edition)

The following algorithm is designed to print the beginning of what is known as the Fibonacci sequence. Identify...

Computer Science: An Overview (12th Edition)

The file seq-full.hcl contains the HCL description for SEQ, along with the declaration of a constant IIADDQ hav...

Computer Systems: A Programmer's Perspective (3rd Edition)

Coin Toss Simulator Write a class named Coin. The Coin class should have the following field: A String named si...

Starting Out with Java: From Control Structures through Objects (6th Edition)

CRC stands for a. Class, Return value, Composition b. Class, Responsibilities, Collaborations c. Class, Respons...

Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)

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.