Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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 - Define each of the following terms: determinant...Ch. 4 - Prob. 4.2RQCh. 4 - Prob. 4.3RQCh. 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.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
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
- Swing Jazz Club ERD Problem 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. You may use any of the approaches shown by the book, though the ER-Model and Crow’s foot are the most common. Make sure you show entities, relationships, cardinality, and optionality. Swing Jazz Club The Swing Jazz Club teaches swing and jazz dancing and offers both private and group lessons. Swing Jazz charges $60 dollars per hour for a private lesson and $10 dollars per hour for a group lesson.…arrow_forwardCourse Title: Software EngineeringFullarrow_forwardCreate the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id which is unique, name, address and phone.The following business rules apply• A course must belong to only one school, but a school may have many courses• A student must be enrolled in a course, but a course may have 0 or more students• A course must have one or more subjects, but a…arrow_forward
- Design an Entity-Relationship diagram for the below environment. determine 1-Total participation.2-Partial participation Consider a MAIL_ORDER database in which employees take orders for parts from customers. The data requirements are summarized as follows: o The mail order company has employees, each identified by a unique employee number, first and last name, and Zip Code. o Each customer of the company is identified by a unique customer num, first and last name, and Zip Code. o Each part is identified by a unique part number, a part name, price, and quantity. o Each order placed by a customer is taken by an employee and is given a unique order number. Each order contains specified quantities of one or more parts. Each order has a date of receipt as well as an expected ship date. The actual ship date is also recorded.arrow_forwardDesign a database for an airline. The database must keep track of customers and theirreservations, flights and their status, seat assignments on individual flights, and the scheduleand routing of future flights. Your design should include an E-R diagram, a set of relationalschemas, and a list of constraints, including primary-key and foreign-key constraints.arrow_forwardDraw the ER diagram to fulfill these requirements.arrow_forward
- You have been asked to design and implement a database for CTU, which includes 3 entities (tables), as follows: Students Faculty Courses Part 1 Create a Word document that includes the following: Identify at least 3 attributes for each entity, including the following: Student's entity should have an attribute for the program the student is enrolled in. Faculty should have an attribute identifying their rank. Properly identify all of the primary keys (use solid underlines). Create an entity relationship diagram (ERD) from the entities. You may use SmartDraw, Visio, Erwin, or even Word to draw the diagram. Take a screenshot (no need if you use Word), and insert it into the Word document. Part 2 Use Microsoft Access to implement the database that you designed in Part 1, and include the following: Create the Student, Faculty, and Course tables in Access. Add a few instances in each table. Create 2 queries for the following objectives: Find the student names for all students who are in the…arrow_forwardPlease read this carefully and Draw an EER diagram for a database of a hospital following these requirements: create Four to five regular strong entities. A union One 1:1, one 1:N, and one N:M relationship – of which at least one relationship should be partial and one full. One overlap relationship and one disjoint relationship. Other notes: Do not emphasize on too many attributes for the entities. Two to three attributes for each entity will be enough. Make sure to include a primary key for each entity.arrow_forwardDesign an entity–relationship diagram for this database. Identify primary keys and relationship cardinalities using(min:max)notation. If you make any assumptions, please state them clearly.arrow_forward
- Er to Relational Schema Mappingarrow_forwardPlease give a step-by-step answer. The ER Diagram must contain the ER-Diagram Symbols. Design an EER diagram for a Hospital Management System. The hospital wants to keep track of all their doctors, nurses, other staff, wards, patients and appointments. They have hired you to help them design the database for that purpose. You can design your EER as you wish, but it must satisfy the following constraints: a) there should be at least one disjoint-total specialization/generalization. b) There should be at least five regular/strong entities [excluding subclasses] c) There must be a weak entity d) There must be at least one M:N relationship. e) There must be at least one derived attribute.arrow_forwardThe figure below shows an E-R diagram for a university dining services organization that provides dining services to a major university. Transform the E-R diagram to a set of 3NF relations using graphical representation, in which you need to indicate the PK/FK and referential integrity where appropriate (but no need to show functional dependencies). The figure below shows an E-R diagram for a university dining services organization that provides dining services to a major university. Transform the E-R diagram to a set of 3NF relations using graphical representation, in which you need to indicate the PK/FK and referential integrity where appropriate (but no need to show functional dependencies).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr