Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 9, Problem 9.45PAE
Program Plan Intro
(a)
To design a multidimensional schema to represent data mart.
Program Plan Intro
(b)
To redesign answer in order to accommodate the history of changes so that it can be matched with precise customer characteristics.
Program Plan Intro
(c)
To redesign the data mart to accommodate product hierarchies.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Create an Entity-Relationship Model for the
Queen Anne Curiosity Shop
The first assignment for the class project is to create an entity-relationship model of the Queen Anne
Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of
chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database
modeling tool.
The Queen Anne Curiosity Shop database contains the following tables:
CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone,
EmailAddress)
EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress)
VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City,
State, ZIP, Phone, Fax, EmailAddress)
ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID)
SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total)
SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice)
Note that the above table descriptions follow the textbook convention:…
An 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.
P2
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
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
- The set of 7 attributes is { desc, drought, price, sci, size, store, zones } The attributes are for plants for sale at different stores The dependencies are: {sci, store, size} -> {price} {sci} -> {desc, drought, zones} "desc" is the description of the plant "drought" is whether the plant can survive with less water "price" is the price of the plant "sci" is the scientific name of the plant "store" is the name of a store that sells the plant "zones" indicates which climate zones the plant will grow in What is the key for the complete set of attributes? a. price O b. sci, store and size c. desc, drought and zones d. sciarrow_forwardWant in detailarrow_forwardInstructions: Create a dimensional model for a particular business process involving gym membership. A customer can sign up for a membership of say one, three, six or twelve months. I want to make it easy to query to identify current members, members who expired in the last month, members who renewed in the last month, those who are pending expiry etc. If I have a basic model with a fact table representing a gym membership say start_date_key end_date_key membership_attribute_key customer_atrribute_key fee with associated dimension table for date, membership attributes such as length, customer attributes and so forth. On a particular day, the active members are those with a start date before the day and an end date after that day. Those who will expire next month are those where the end date is in a particular date range.arrow_forward
- Alert dont submit AI generated answer.arrow_forwardIf you sell a house more than once, it is treated as different "property" for each sale. Draw an entity-relationship diagram and write a database design outline. Q2. Law Office: You are trying to automate the records for your uncle's law firm. Multiple attorneys work for the firm, and for each of them you want to store their first name, last name, date hired, hourly billing rate, and date promoted to partner (blank if the attorney is not a partner). Each attorney has multiple cases, which is identified by a unique "docket number". Each case has a name and description, is worked on by only one attorney, and involves a single client. For each client, you want to store a first name, last name, middle name, phone number, address, city, state, and zip code (assume you do not have a zip-code table). Finally, you want to keep track of the billable hours spent on each case. For a single case, this comprises information that looks like Hours Billed Date 2/24/2005 Description Prepare brief…arrow_forwardAssignment Brief: Some of the most difficult decisions that you face as a database developer are what tables to create and what columns to place in each table, as well as how to relate the tables that you create. Normalization is the process of applying a series of rules to ensure that your database achieves optimal structure. Normal forms are a progression of these rules. Each successive normal form achieves a better database design than the previous form did. Based on your understanding for the various normal form respond to the following problems and provide the optimal answer/solution. Problem#1: 1st Normal Form (1NF) Consider the Students table, with the primary key underlined, and the following data: Students: Alpha 100111 Email doe@usna.edu Name Courses GradePoints NN204, SI204, IT221 SM223, EE301 SI204 John Doe 2,3,3 Matt Smith 092244 113221 smith@usna.edu black@usna.edu 4,4 Melinda 3 Black NN204, SI204, IT221 090112 Tom Johnson Johnson@usna.ed 4,2,3 u a) Is the Students table…arrow_forward
- The Driver Relationship considered that working on both DRIVERS and ACTIVE_DRIVERS tables is difficult and too much work. Therefore, the team wants you to remove the table for the active drivers. Task Remove the ACTIVE_DRIVERS table.arrow_forwardNormalizationarrow_forwardQ2. ER Model Develop an ERD for the following case: A school of technology has hired you to create a database to assist in scheduling classes. After several interviews with the users, you have come up with the following data requirements and business rules. Based on them, create an ER Model for the school's database. BUILDING has many rooms. Each room is located in a building. The attributes for BUILDING are BuildingNo. BuildingName and Location. ROOM is always identified in association with BUILDING (BuildingNo). The attributes for ROOM include RoomNo and Capacity. There are two types of room. A room can be either LAB or CLASSROOM. If it is a lab, it has an additional attribute called LabHours. If it is a classroom, it has an additional attribute called ZoomEnabled?. COURSE has identifier CourselD and has attributes CourseDescriptions and Credits. A course may (or may not) have more than one section. Each section is always identified in association with COURSE (CourseID). SECTION has…arrow_forward
- Hot Spot Question: Explore the ERD and corresponding code to identify the error. Figure: Entity Relationship Diagram (ERD). Employee Employee number Department First name Last name Job title Dept number works Dept name in Dept location Dept number Instructions: Click on the keyword, entity (table) or attribute (column) name in the code below where there is a mistake: CREATE TABLE Department( DeptNumber INT NOT NULL AUTO_INCREMENT, DeptName VARCHAR(60), DeptLocation VARCHAR(5), FOREIGN KEY (DeptNumber) );arrow_forwardDraw an ER Diagram for the schema shownarrow_forwardPlease clear and correct answer.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education