Modern Database Management
13th Edition
ISBN: 9780134792293
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
Suppose you are asked to design a club database system based on the following information. Each student has a unique student id, a name, and an email; each club has a unique club id, a name, a contact telephone number, and has exactly one student as its president. Each student can serve as a president in at most one of the clubs, although he/she can be the members of several clubs. Clubs organize activities and students can participate in any of them. Each activity is described by a unique activity id, a place, a date, a time and those clubs that organize it. If an activity is organized by more than one club, different clubs might contribute different activity fees.QuestionDraw an E-R diagram for the system according to the above description.
A company sells toys by mail order. The company already has a product database, with a simple web interface, so that customers can get information about toys and prices. Currently, customers place orders by mail or by telephone.
The company decides to create a system for selling toys online. The system will have three components: a product database, a customer database, and an ordering system.
The plan is to develop the system in two phases:
Phase 1
The product database will remain unchanged but the web interface will be replaced by the ordering system.
A fully featured version of the ordering system will be developed. Every effort will be made to create an ordering system that will need little or no modifications in Phase 2.
A simple version of the customer database will be developed.
Page 3 of 4
Phase 2
A new product database will be created.
Major enhancements will be made to the customer database.
Minor changes may be made to the ordering…
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
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
- Why is it sometimes better for a data model to exclude a certain data item from its representation?arrow_forwardDesign 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_forwardThe 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_forward
- As 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_forwardA university wants to set up a database to record details about its staff, the departments they belong to and the training they attended. The purpose of developing the database is keep the staff information such as staff identity number, staff name, staff address, staff telephone number, staff job title and staff salary. As for the staff telephone number, the database allows keeping more than one of the staff telephone numbers. For the department information, the database keeps the name of the department and its location. It is required that every staff belongs to at least one department. Also, it is required that each department has exactly one staff to lead the department. To improve staff self-development, the university encourages every staff to attend courses. Hence, the database keeps the course information such as the course name, course duration, and course cost. Each staff is required to attend at least one course. For one course, the university can approve a number of staff…arrow_forwardAn E-learning website needs your help to design its database. They need to store information about teachers and online tutorials. Each teacher has a unique ID, name, and at least one field of specialty. Teachers form groups to prepare online tutorials. Each group has unique name and at least one teacher as a member. Each online tutorial has a title, date and organized by exactly one group. The title of the tutorial is unique for the group. Each tutorial consists of several sessions, described by their titles and durations. Naturally, each session is presented by one teacher and belongs to exactly one tutorial. In addition, sessions on the same tutorial have different titles. Design an ERD for this application. Note any unspecified requirements, and make appropriate assumptions to make the specification complete.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_forwardA university wants to develop a database system to manage student enrollment and course registration. They need an ERD to represent the key entities and their relationships. Entities: Student: Each student has a unique student ID, a name, a date of birth, and an email address. Course: Each course has a unique course code, a title, a description, and the number of credits. Enrollment: Each enrollment represents a student's registration in a specific course for a particular semester. It includes information about the grade received for that course. Professor: Each professor has a unique professor ID, a name, and an email address. Professors teach one or more courses. Create an ERD that represents the relationships between these entities. Include Entity name, attributes, identify Primary and Foreign key and crow foot relationships.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 Learning
Principles 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