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
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.
is this diagram correctly following these instructions?? Here's the instructions: Using MySQL Modeler, draw the ERD that represents the following scenarios. You can put the
diagrams on the same page to turn in.
Scenario 1:
A laboratory has several chemists who may use certain pieces of equipment. Each piece of
equipment 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, that
connects CHEMIST and EQUIPMENT. Attributes of chemist include chemist id (PK), name and
phone number. Equipment has the attributes serial number (PK) and cost. The organization
wishes to record an Assign_Date, i.e. the particular date when a given piece of equipment was
assigned to a particular chemist. (Hint Assign_date is an attribute of the Associate Entity
CHEMIST-EQUIPMENT.)
Scenario 2:
The entity type STUDENT represents any university student. ACTIVITY represents some campus-
based activity…
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
- 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_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_forwardPlease provide the steps using Arena softwere.arrow_forward
- TESTING YOUR UNDERSTANDING Exercise 3-1. Consider the scenario described at the beginning of this chapter: When parents call to say that children are sick, we have to let their classroom teachers know, and if it's sports day and the child is on a school team, the sports teacher might have to sort out substitutes. Then we need to count up all the days missed to put on the child's report. The Department of Education needs the totals each term, too. Run through the steps in the summary section and sketch some use cases and an initial data model. Assume that the main objectives are to record the absences for the classroom teacher, for school reports, and for statistics given to the Department of Education.arrow_forwardBuild a decision table and simplify the same. Customer can withdraw money from ATM. ATM machine pays out the amount if the customer enters correct pin and it customer has sufficient funds in their account or if the customer has the credit granted. ATM should also have enough funds to dispense the cash as per the customer request.arrow_forwardCreate a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.arrow_forward
- Draw an ER diagram using Cardinality Notation for the following description: A veterinary hospital only treats dogs and cats (use ISA). Clients have an address, phone number and client ID. Each pet has a name, a pet ID and belongs to exactly one client. Each client can have at most 5 cats and 2 dogs.arrow_forwardthe 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_forward
- Consider 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_forwardDo not use any Al to do this question. Please show the diagram at the end. Question Lekker Living is a new backpackers that recently opened close to Stellenbosch. They have a limited number of staff (including a receptionist, a cook, and a housekeeper) since they have limited rooms available. If foreign travelers are looking for a place to stay a few nights while exploring the wonderful wine farms and hiking trails in Stellenbosch, they need to check availability on the website. If there is space, they must call reception to book a room. Orice they arrive, they check in at the front desk. In the evenings, they have the option to enjoy an assortment of dishes, prepared by a cook. Guests can also request for the room to be cleaned by a housekeeper in the mornings, while they are out and about exploring. Once their stay is over, they can check out with the receptionist. If a guest can no longer make their stay, they have the option to cancel their booking 24 hours before. Draw the use…arrow_forwardFor the given business rule, is the explanation for relationship and cardinality correct between PROFESSOR and COURSE below: Business Rule: A university is divided into many schools. Each school has many departments, where each department belongs to one and only one school. Each department should have one or more professors assigned to it, where each professor cannot teach more than two courses. The university wants to record the following data for all professors: professor number and full name. All courses are classified into two categories: Fashion and Technology. Relationship: PROFESSOR “teaches” COURSE Relationship type: 1:M Explanation: Business rules state, “Each course belongs to one and only one professor. Each professor includes one or more courses”. The PROFESSOR entity is on the “one” side of the relationship and the COURSE entity is on the “one or more” side of the relationship. Relationship participation: Mandatory on the “one” side of the…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