Modern Database Management
Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
bartleby

Concept explainers

Question
Book Icon
Chapter 4, Problem 4.33PAE
Program Plan Intro

(a)

Conversion of the given EER diagram into relational schemas

Program Plan Intro

(b)

Conversion of the EER diagram in relational schemas with functional dependencies

Program Plan Intro

(c)

Development of a set of 3NF for the given situation using enterprise key.

Blurred answer
Students have asked these similar questions
Instructions: The figure below shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys of merchant and credit card. • Develop a relational schema. • Show the functional dependencies. • Develop a set of 3NF relations using an enterprise key. CUSTOMER Customer ID Cust Name Cust Address Holds CARD ACCOUNT MERCHANT Account ID Exp Date Card Type Merch ID Merch Addr Card Type = "D DEBIT CARD Bank No CHARGES Charge Date Charge Time Amount CREDIT CARD Cur Bal
San Diego Hospital Example ERD Problem Entity Relationship Diagramming is a "top down" user process.  Take the following user provided information and draw the appropriate ERD.  Follow the Simple Procedure for ERD diagramming to design an ERD using the following user provided information.    Remember the ERD will eventually turn into the design for a database from a top down view.   Make sure you resolve any many to many conflicts.   Label an identifier or primary key and all pertinent attributes given.    If an attribute is not readily apparent from the user information, then make one up that makes sense for the particular entity.   Therefore, all entities should end up with at least an identifier and another attribute that makes sense. Please use a drawing tool of some type to show the ERD diagram (Word, PowerPoint, and Visio all work well).   I want you to get in the habit of drawing these with a computer instead of by hand, as this will be important as we get to more difficult…
Draw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships. 1. all entities should have surrogate primary keys. 2.A customer can place many orders over and over time and each order is placed by exactly one customer. 3.The name and surname of a customer must be stored in the database 4.The date and status of an order must be stored in the database 5.Each order cab obtain many items and each item can be part of many different orders 6.The name description and unit price of every item must be stored in the database 7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored 8.Each item in the database belongs to a catagory and a catagory has many items that belong to it 9.The name of each of the categories must be stored in the database

Chapter 4 Solutions

Modern Database Management

Ch. 4 - Prob. 4.11RQCh. 4 - Describe how the following components of an E-R...Ch. 4 - Prob. 4.13RQCh. 4 - Prob. 4.14RQCh. 4 - Briefly describe four typical problems that often...Ch. 4 - Prob. 4.16RQCh. 4 - Explain how each of the following types of...Ch. 4 - Prob. 4.18RQCh. 4 - Prob. 4.19RQCh. 4 - Prob. 4.20RQCh. 4 - Prob. 4.21RQCh. 4 - What is the relationship between the primary key...Ch. 4 - Prob. 4.23RQCh. 4 - Explain what can be done with primary keys to...Ch. 4 - Prob. 4.25RQCh. 4 - Explain three conditions that suggest a surrogate...Ch. 4 - Prob. 4.27RQCh. 4 - For each of the following E-R diagrams from...Ch. 4 - Prob. 4.29PAECh. 4 - Prob. 4.30PAECh. 4 - For your answers to the following Problems and...Ch. 4 - Figure 4-3212 shows a class list for Millennium...Ch. 4 - Prob. 4.33PAECh. 4 - Prob. 4.34PAECh. 4 - Prob. 4.35PAECh. 4 - Prob. 4.36PAECh. 4 - Prob. 4.37PAECh. 4 - Prob. 4.38PAECh. 4 - Prob. 4.39PAECh. 4 - Transform Figure 2-15a, attribute version, to 3NF...Ch. 4 - The Public Safety office at Millennium College...Ch. 4 - Prob. 4.42PAECh. 4 - Prob. 4.43PAECh. 4 - Prob. 4.44PAECh. 4 - For your answers to Problem and Exercise 3-33 from...Ch. 4 - Prob. 4.46PAECh. 4 - Prob. 4.47PAECh. 4 - Figure 4-38 includes an EER diagram for a...Ch. 4 - Prob. 4.49PAECh. 4 - Prob. 4.50PAECh. 4 - Prob. 4.51PAECh. 4 - Prob. 4.52PAECh. 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.55PAECh. 4 - Prob. 4.56PAECh. 4 - Prob. 4.57PAECh. 4 - Prob. 4.58PAE
Knowledge Booster
Background pattern image
Computer Science
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr