Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.64PAE
(a)
Program Plan Intro
Usage map of the EER diagram based on the given assumptions.
(b)
Program Plan Intro
Based on the EER diagram, create a set of normalized relation.
(c)
Program Plan Intro
Opportunities for denormalization in given scenario.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Given the following case you are to answer the two questions on the following pages.
Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to have assigned an identifying number.
1. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attrIbutes take on.
2. Create the database design for this case below using an Entity-Relationship Diagram.
How can I Draw An ERD to show the relationships among EMPLOYEE, STORE, REGION, and SUPPLIER.
A REGION can contain many stores. A STORE is located in only one REGION. The relationship between STORE and REGION is M:1. (It is, of course, equally true that the relationship between REGION and STORE is 1:M.) . In summary, each store is located in a single region, but that each region can have many stores located in it. You will have to keep track of attributes Region name, states included in the region, and the regional director's information.
A STORE employs EMPLOYEE, This is a 1:M relationship because one store can employ many employees and each employee is employed by one store. You will need to track, store address, store phone number, store manager, store number
There is still another relationship, the additional relationship, expressed by EMPLOYEE manages STORE, is a 1:1 relationship, because each store is managed by one employee and an employee manages only one store.' You will…
You have been retained by “Expressive Espresso” to help them decide where to build their next Expressive Espresso coffee house. You are therefore interested in what affects the total number of sales per day. You thus lookat fifty of the existing Expressive Espresso shops and gather information on each of them. You think average daily sales (in dollars) could be affected by location, so you decide to gather information on the zip code for each Expressive Espresso shop, but you also think that the number of cars that drive past each day along with the modal education (highest degree earned) of the people in the area are also important. You collect all the data and do your experiment.
a. What is the sample in the above experiment? How does it differ from the population?
Chapter 8 Solutions
Modern Database Management
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
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
- Bob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to be assigned a unique identifying number. Identify the tables needed to design the database and the fields [attributes] needed for each table and the role or function that some attributes take on.arrow_forwardYou are interested in looking at how competition affects gas prices, where you think that if a gas station has more competitors nearby, it will tend to have lower prices. To test this, you decide to use a natural experiment in which a chain of gas stations ("Thrifty") suddenly closed. This closure occurred between June and October of 2012, and meant that gas stations that were previous close to a Thrifty station experienced less competition than before. On the other hand, those stations that were not close to a Thrifty station did not experience any change in competition. You decide to use a differences in differences design, in which gas stations located near a Thrifty station at the start of 2012 are the treatment group and those that were not located near a Thrifty at the start of 2012 are the control group. You look at how prices change before and after the exit of Thrifty. This is plotted in the below graph, where the solid line represents the average price of stations that were…arrow_forwardBob’s Supply (BS) needs to keep track of the parts they have in their inventory. He wants to know the description of each part, the color of each part, how many of each item is in stock [QOH], and how much each part costs him. BS also needs to keep track of who supplies each part, the supplier’s name, contact person, and telephone number. We know that each part in inventory has only one supplier, but some suppliers supply multiple parts to BS. Bob wants each part and each supplier to be assigned a unique identifying number. Create the database design for this case below using an Entity-Relationship Diagram.arrow_forward
- Damon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?arrow_forwardYou have been retained by “Expressive Espresso” to help them decide where to buildtheir next Expressive Espresso coffee house. You are therefore interested in what affects the total number of sales per day. You thus look at fifty of the existing Expressive Espresso shops and gather information on each of them. You think average daily sales (in dollars) could be affected by location, so you decide to gather information on the zip code for each Expressive Espresso shop, but you also think that the number of cars that drive past each day along with the modal education (highest degree earned) of the people in the area are also important. You collect all the data and do your experiment. a. List all of the variables in the above experiment. Also list two potential categories for each variable. b. Now list the scales of measurement for the variables listed above. Write the name of the variable and thenstate its scale of measuremenarrow_forwardAssume now that there are 12 people initially on the yacht with 6 women and 6 men, and that exploration teams consist of six people. How many exploration teams have more women than men?arrow_forward
- A transport company needs to model their activities. There are two types of employees in the company: drivers and operators. For drivers it is interesting to know the date of issue and type of the driving license, and the date of issue of the taxi driver’s certificate. For all employees it is interesting to know their personal number, address and the available phone numbers. The company owns a number of transport. For each transport, there is a need to know its type, year of manufacturing, and date of the last service. There are two types of transport commonly booked by the customers that are MPV and Saloon. There are also other types of transports that the company provides to the customers. The company wants to have a record of car trips. A transport may be picked on a street or ordered through an operator who assigns the order to a certain driver and a car. Departure and destination addresses together with times should also be recorded. Draw an enhanced entity relationship diagram in…arrow_forward3. If the collision happens again that k =1 (Note: Consider the value of k = when the collision happened, use the formula for k = k+1, in this case k =1+1 =2), What is the probability of collision? Show all your detail calculation in a table format.arrow_forwardRead carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching merchandise from the store.At the…arrow_forward
- Imagine you are a logistics manager for a major shipping company responsible for optimizing the delivery process. Your company operates in two different regions, each with its fleet of delivery trucks. The number of packages in each region can vary significantly, represented by two sorted lists: one for each region (nums1 and nums2). Your goal is to calculate the median delivery time it takes for packages to reach their destinations, considering both regions. This median time is crucial to ensure timely deliveries and customer satisfaction. The overall run time complexity should be O(log(m+n)), as you need an efficient method to calculate this median for effective logistics planning. In this logistics scenario, nums1 and nums2 represent the sorted lists of delivery times for each region. Just like in the original problem, you are tasked with finding the median efficiently, which is analogous to determining the median delivery time. Achieving this with O(log(m+n)) time complexity is…arrow_forwardCan We use ARDL model for the following information? If not, what isyour suggestion for the model? If yes, why?Table 1. Unit Root TestVariable Level First Difference Second DifferenceUN 0.0000*GR 0.0022INF 0.3720 0.0000INT 0.2682 0.0059WAGE 0.0226TAXIN 0.8565 0.0016EDU 0.1404 0.2333 0.0000FEMALE 0.0435URBAN 0.3330 0.3471 0.0188 *These numbers show the P-Value. Table2. Cointegration TestHypothesized Trace 0.05No. of CE(s) Eigenvalue Statistic Critical Value Prob.**None * 0.998292 580.3047 159.5297 0.0000At most 1 * 0.991600 408.2568 125.6154 0.0000At most 2 * 0.977966 279.2106 95.75366 0.0000At most 3 * 0.960113 176.2016 69.81889 0.0000At most 4 * 0.748764 89.21584 47.85613 0.0000At most 5 * 0.624056 51.91909 29.79707 0.0000At most 6 * 0.528664 25.50456 15.49471 0.0011At most 7 * 0.175048 5.195616 3.841466 0.0226arrow_forwardDollar General Corporation operates deep-discount stores offering housewares, cleaning supplies, clothing, health and beauty aids, and packaged food, with most items selling for $1. Its business model calls for keeping costs as low as possible. The company has no automated method for keeping track of inventory at each store. Managers know approximately how many cases of a particular product the store is supposed to receive when a delivery truck arrives, but the stores lack technology for scanning the cases or verifying the item count inside the cases. Merchandise losses from theft or other mishaps have been rising and now represent over 3 percent of total sales. What decisions must be made before investing in an information system solution?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage