Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 4.57PAE
Program Plan Intro
a. Functional dependency between given attributes
Program Plan Intro
b. Reason for which the given relations are not in 3NF.
Program Plan Intro
c. Convert relation into 3NF
Program Plan Intro
d. ER Diagram of normalized relations
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
1)Modeling: Make a CDM from the following scenario: *
A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region.
- The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement.
2)
In your MCD above, what are the dimension tables? *
3)In your MCD above, what are the fact tables?
In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Product
In this unit, we explore the structured approach to modeling business processes. In this practical assignment, using the business process of a fictional package delivery service (a courier company) called On the Spot Courier Services, you will create data flow diagrams that demonstrate the business processes that would need to be supported by a new system.
Scenario:
When Bill got an order, at first, only on his phone, he recorded when he received the call and when the shipment would be ready for pickup. Sometimes, customers wanted immediate pickup; sometimes, they were calling to schedule a later time in the day for pickup.
Once he arrived at the pickup location, Bill collected the packages. It was not uncommon for the customer to have several packages for delivery. In addition to the name and address of the delivery location, he also recorded the time of pickup. He noted the desired delivery time, the location of the delivery, and the weight of the package to determine the courier…
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
- Draw a data flow diagram (DFD) for the development of the admission and registration system, bearing in mind that the users of the system, the processes and the stored data are as follows: system users processes saved data students - Deletion and addition - withdrawal from the course - apology for the semester - student schedule - withdrawal requests - apology requests faculty members -recording attendance and absence - monitoring grades, - attendance and absence detection - Transcript for class department heads approving requests Deanship of Admission and Registration implementing requests Draw a data flow diagram starting from the zero level to the second level. Please add the detailed processes and data saved by levelarrow_forwardDraw an ER diagram on any application for a student information system with 4 entities:-entity class:classID,department-entity department:deptID,Dept_name-entity student:studentID,firstname,last name,gender,birthdate,address,hobby,class,mother name,father name,student code-entity parents:parentID,parent name,occupation,address,town,parent type,gender,telephone,email addressarrow_forwardDesign an aggregate class diagram for a traditional e-banking management system. The basic operations that a bank includes opening new accounts, allowing loans, ATM management system, credit and debit card management system etc. You must include dependencies, multiplicities, and analysis packages if necessary by using conventional signsarrow_forward
- Build a model that describes the monthly cost C, indollars, as a function of the number of data gigabytesused, g, assuming a single smartphone and a personalhotspot for each plan you are considering.arrow_forwardCan someone please include the use case diagram's descriptions as well? Instructions: Draw a use-case diagram and create a set of activity diagrams for the following system. A Video Store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be cataloged and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for three days at a time. Every time a customer rents a video, the system must ensure that they do not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before customer can rent more videos. Likewise, if the customer has returned overdue videos, but has not paid the overdue fee, the fee must be paid before new videos can be rented. Every morning, the store manager prints a report that lists overdue videos. If a video is two or more days overdue, the manager calls the customer to remind them to return the video. If…arrow_forwardLet’s take a look at the following context diagram of payroll system. 2. Design level-2 DFD based on following scenario. Calculate pay process is decomposed in two processes, compute net pay and prepare payroll. Compute net pay process take valid payroll data and exemption data from withholding datastore and generate Net pay and deduction which is saved to employee datastore and also sends to prepare payroll process. Finally prepare payroll process saves posting information to payroll journal datastore and send paychecks to Employees.arrow_forward
- Design an ER schema for prescription monitoring based on the given data: Patients are defined by an identity number, a first name and a last name, and by a birth-date. Doctors are defined as well by an identity number, a first name, a last name, and a birth-date, while additionally they will be characterized by a work start date and a specialty. Pharmaceutical companies will be defined by a name, and a telephone number. Medicines will be defined by a commercial name, their manufacturer, and their active ingredient. Pharmacies will be defined by a name, an address and a telephone number. Each patient has one doctor and each doctor has at least one patient. A doctor can prescribe certain medicines to his patients. Each pharmacy sells several medicines, each at a specific price. Each medicine can be sold by several pharmacies possibly at a different price. Pharmaceutical companies have contracts with pharmacies. Each pharmaceutical company may have contracts with several pharmacies. Each…arrow_forwardDraw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)arrow_forwardARENA is a multi-user, Web-based system for organizing and conducting tournaments. ARENA is game independent in the sense that organizers can adapt a new game to the ARENA game interface, upload it to the ARENA server, and immediately announce and conduct tournaments with players and spectators located anywhere on the Internet. Organizers can also define new tournament styles, describing how players are mapped to a set of matches and how to compute an overall ranking of players by adding up their victories and losses (hence, figuring out who won the tournament). To recoup their operational costs, organizers can also invite potential sponsors to display advertisement banners during games. USE-CASE DIAGRAM: A. Identify Actors and Use Cases for the Arena Game System. Draw the Use Case Diagram that details the high-level functionality of the system. Make sure to have includes and extends relationships between use cases where relevant. B. Pick any 2 use cases from your diagram and provide…arrow_forward
- Draw an ER Diagram, or EER Diagram as appropriate, for each of these scenarios. A soccer league has a set of teams, each of which has a team ID number, name, stadium name, and location (city). Each team has many players, and each player belongs to only one team. Each player has a player ID number, name, date of birth, start year, and a jersey number. Teams play matches. In each match there is a host team and a guest team. Information about a given match includes the date on which the game is played, and the score (one value for the guest team and one value for the host team). The league has referees, each of which as a referee ID number, a name, date of birth, and start year. Each match is assigned three referees, one of which is designated as the main referee (the other two are assistant referees). Note that a referee may be the main referee for some matches and an assistant referee on others. [Hint: Make Match its own entity type. Include two relationships between Team and Match,…arrow_forwardInstead of merely presenting a performance-based argument, provide reasons why deep access is superior to shallow access from the developer's perspective.arrow_forwardProcesses, data flows, and external actors will be discussed in detail. Given that this subject is related to computer programming, which you have all had experience with, we are returning to some familiar terrain! So, what exactly is a process and what exactly is an event?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 LearningInformation Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning