Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 9.43PAE
Program Plan Intro
To construct:
A star type schema for the food manufacturing company.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
b) Model the following use case using a sequence diagram:
M1: The customer provided an order request to Customer Interaction.
M2: Customer Interaction sends the order request to the Customer Coordinator.
M3, M4: Customer Coordinator sends an account request to Customer Account Service and
receives the account information, including customer's credit card details.
M5: Customer Coordinator sends the customer's credit card information to Credit Card
Service.
M6: Credit Card Service sends credit card approval to the Customer Coordinator.
M7, M8: Customer Coordinator sends order request to Delivery Order Service.
M9, M9a: Customer Coordinator sends the order confirmation to Customer Interaction and
sends an email of the order confirmation to the customer via Email Service.
M10: Customer Interaction outputs the order confirmation to the customer
Predictive modeling:
Task: Ambulance Demand
Data Generating Process: Using the service data: The data is collected by the " NYC Traffic data” to answer the questions:
Frequency of data collection {how often is the data collected? After every incident? Daily? Yearly?}
Agency / Organization collecting the data {who specifically is collecting the data? Please avoid using general references like “government” or “police}
Original Unit of Analysis {What is the original unit of analysis for the data as provided? Calls for service? Census tracts? Cities?}
Transformed Unit of Analysis{i.e. are you modifying the call data to support your model? Hint: if you are doing “demand” model you will be aggregating the data.}
Data Generation Description{here, I want you in your own words to describe how you think the data was generated. Think 2-3 sentences.}
Data Collector{Who collects the data? A dispatcher? A Census taker?}
Triggering Process{What triggers the data to be collected?…
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…
Chapter 9 Solutions
Modern Database Management
Ch. 9 - Prob. 9.1RQCh. 9 - Prob. 9.2RQCh. 9 - Prob. 9.3RQCh. 9 - List the five major trends that necessitate data...Ch. 9 - Prob. 9.5RQCh. 9 - Prob. 9.6RQCh. 9 - Prob. 9.7RQCh. 9 - Prob. 9.8RQCh. 9 - Prob. 9.9RQCh. 9 - Prob. 9.10RQ
Ch. 9 - List four objectives of derived data.Ch. 9 - Prob. 9.12RQCh. 9 - Prob. 9.13RQCh. 9 - Explain the pros and cons of logical data marts.Ch. 9 - Prob. 9.15RQCh. 9 - What is a helper table, and why is it often used...Ch. 9 - Describe the characteristics of a surrogate key as...Ch. 9 - Prob. 9.18RQCh. 9 - What is the purpose of conformed dimensions for...Ch. 9 - Prob. 9.20RQCh. 9 - Prob. 9.21RQCh. 9 - Prob. 9.22RQCh. 9 - Prob. 9.23RQCh. 9 - Prob. 9.24RQCh. 9 - Prob. 9.25RQCh. 9 - Describe the current key trends in data...Ch. 9 - Discuss the benefits of offering data warehousing...Ch. 9 - Prob. 9.28RQCh. 9 - List six typical characteristics of reconciled...Ch. 9 - Prob. 9.30RQCh. 9 - Prob. 9.31RQCh. 9 - Prob. 9.32RQCh. 9 - Prob. 9.33RQCh. 9 - Describe some field-level and record-level data...Ch. 9 - Prob. 9.35PAECh. 9 - Prob. 9.36PAECh. 9 - Prob. 9.37PAECh. 9 - Prob. 9.38PAECh. 9 - You are to construct a star schema for Simplified...Ch. 9 - Simplified Automobile Insurance Company would like...Ch. 9 - Prob. 9.41PAECh. 9 - Prob. 9.42PAECh. 9 - Prob. 9.43PAECh. 9 - Prob. 9.45PAECh. 9 - Prob. 9.46PAECh. 9 - Prob. 9.47PAECh. 9 - Prob. 9.48PAECh. 9 - Prob. 9.49PAECh. 9 - Prob. 9.50PAECh. 9 - Prob. 9.51PAECh. 9 - Prob. 9.52PAECh. 9 - Prob. 9.53PAECh. 9 - Prob. 9.54PAE
Knowledge Booster
Similar questions
- The Database Library System is intended to Automate the library activities such as creating a new borrower, giving books to the borrowers, and maintaining the details of all the items available in the books. This also helps the librarians by providing information such as the total copies available for each book, and a list of books that belong to a particular category (Short, Long Loan, Reference items, etc.). In general terms, discuss how a data model could be used to design a database for a small library’s Database system.arrow_forwardAs a large service organization, King Abdullh University Hospital depends on a large number of persons for its continued success. There are four groups of persons on whom the hospital is most dependent: employees, physicians, patients, and volunteers. Of course some common attributes are shared by all of these persons: Person_ID (identifier), Name, Address, Ciy/State/Zip, Birth_Date, and Phone. Each of the four groups of persons has at least one unique attribute of its own. Employees have a Date_Hired, Volunteers have a Skill, Physicians have a Specialty and a Pager# (pager number), and Patients have a Contact_Date (date of first contact with the hospital). Some other persons in the hospital community do not belong to one of these four groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at a given time (for example, Patient and Volunteer). Each patient has one (and one only) physician responsible for that patient. A…arrow_forwardER modeling is one approach in creating a data model. There are several approaches in creating a data model (bottom up, top down, inside out, and mix). 1. explain each of these approaches!2. Then explain when we use top down, bottom up, inside out and mix? what is the function of each of the approaches?arrow_forward
- Using a graphics program, develop an entity-relationship diagram for a database application for an Internet bookstore where students buy textbooks from a salesperson and receive invoices for their purchases. Use Figure 5.5 as a guide.arrow_forwardA new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.arrow_forwardData modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forward
- Draw an E-R Diagram for: -Customers pay with credit cards. -Customers have: id, name, address, phone -Credit cards have: type, number, exp_date, ccv_number, zip_code -Each customer can pay with several credit cards -Each credit card belongs to only one customerarrow_forwardData for an information technology conference needs to be collected. The conference has a variety of sessions scheduled over a two-day period. All attendees must register for the sessions they plan to attend. Some speakers are presenting only one session, whereas others are handling multiple sessions. Each session has only one speaker.arrow_forwardIt is possible to categorize as a specific sort of data model the kind of data model that organizes the concepts in the same way as the data is stored in the computer system. This kind of data model may be found in certain computer systems.arrow_forward
- It is possible to identify as a specific kind of data model a data model that organizes concepts similarly to how data is stored in the computer system.arrow_forwardThe Vegan Garden is a little restaurant that may be found in the tranquil village of Dawnsville. It has been five years since the eatery first opened its doors. At the moment, sales are recorded manually via the use of cash registers, and monthly sales reports and other corporate paperwork, such as information on employees and suppliers, are kept in dated filing cabinets. The owner of Vegan Garden has made the decision to develop an information system. He then went and sought the aid of a company that specializes in information technology in order to design an information system that would be suitable for the current commercial operations of the Vegan Garden.You have been given the responsibility of serving as the project manager for the creation of the Vegan Garden information system.As the project manager of the development project, it is your responsibility to advise the owner of Vegan Garden about the information system security issues that exist. Provide an explanation for ANY…arrow_forwardOne subset of data models is one in which concepts are structured in the same way as data is stored digitally.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning