EBK MODERN DATABASE MANAGEMENT,
13th Edition
ISBN: 9780134792279
Author: TOPI
Publisher: YUZU
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 solution
Students have asked these similar questions
Use the 20 year Global Warming Potential (GWP) values in the first Table to calculate an equivalent CO2 emission rate for worldwide greenhouse gas emissions as given in the second table. Assume that total CFCs are divided equally among the three compounds listed. What is the percentage contribution of actual CO2 emissions to the total equivalent CO2? What is the next most important greenhouse gas emission based on this analysis? How do these results compare to those using the 100-year GWP.
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.
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.
Create the database design for this case below using an Entity-Relationship Diagram.
Chapter 8 Solutions
EBK 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_forwardSuppose now we are developing a bank system with the following requirements: ABC bank has multiple branches, each branch locates on a city and has its unique name. ABC needs to monitor the assets of each branch. Clients are identified by their ID numbers. Their names, phone numbers, family addresses are also stored. To guarantee the safety of each client’s accounts, ABC also requires clients to provide information of one contact, including name, phone, email, and relationship with this client. Bank staffs are also identified by their ID numbers. They can be managers or clerks. Each manager leads all clerks in the department. Each clerk can only work in one department. Every bank account has a clerk to be responsible for and a clerk can take charge of multiple accounts. Each branch stores the name, phone number, home address, department number and the beginning date of working of every staff. For each department, its number, name and ID number of the manager are also stored. Each…arrow_forwarddraw this out on a piece of paper showing the relationship please: Using MySQL Modeler, draw the ERD that represents the following scenarios. You can put thediagrams on the same page to turn in.Scenario 1:A laboratory has several chemists who may use certain pieces of equipment. Each piece ofequipment may be used by several chemists, or it may be idle, that is, not in use by anyone.Since this is a many-to-many relationship, there is an associate entity CHEMIST-EQUIP, thatconnects CHEMIST and EQUIPMENT. Attributes of chemist include chemist id (PK), name andphone number. Equipment has the attributes serial number (PK) and cost. The organizationwishes to record an Assign_Date, i.e. the particular date when a given piece of equipment wasassigned to a particular chemist. (Hint Assign_date is an attribute of the Associate EntityCHEMIST-EQUIPMENT.)Scenario 2:The entity type STUDENT represents any university student. ACTIVITY represents some campus-based activity in which the student may…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_forwardFor an order of 100 bicycles, what would be the total time in minutes (including queue time, setup, and processing time) to complete this order? Use the routing parameters from lab exercise 4, task 2( the picture). Assume wait and move times are zero but queue time is not zero. Show your work in a spreadsheet. Also assume the process for this company is job shop.arrow_forwardPlease provide the steps using Arena softwere.arrow_forward
- Dollar 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_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 more than 3 percent of total sales. What decisions have to be made before investing in an information system solution?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_forward
- the requirements for TAL Distributors have changed. A number and a name now identify each storehouse. Units of each item may be stored in multiple storehouses, and it is important to know precisely how many items are stored in each storehouse. In addition, TAL Distributors now want to manage information about the suppliers from which it purchases items. For each item, TAL Distributors needs to know the number and name of each supplier as well as the expected lead time for delivering each item. (Lead time is the amount of time a supplier is expected to take to deliver the item after TAL Distributors has ordered it.) Each item can have many suppliers, and each supplier can supply many items. Using this information, convert the following unnormalized relation to fourth normal form:arrow_forwardComplete the table above (ii) Determine the average time spent in the system for the single server illustrated by the table (iii) Find the average waiting time for the customers in the queuearrow_forwardConsider the following table Insurance No. Contract No. HRS. Employee Name Hotel No. Location 15 Osman FEE 19 Sohel 22 Farhana 15 Maliha 5001 5003 5007 5009 CO211E CO211E CO211F CO211F H01 H03 H03 H01 Dhaka Rajshahi Chittagong Cox's Bazar Describe, and illustrate the process of normalization up to 3NF. State and make assumptions, if any.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Operations Research : Applications and AlgorithmsComputer ScienceISBN:9780534380588Author:Wayne L. WinstonPublisher:Brooks Cole
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Operations Research : Applications and Algorithms
Computer Science
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Brooks Cole
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage