Modern Database Management
13th Edition
ISBN: 9780134773650
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 solutionStudents have asked these 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. sci
Want in detail
Instructions: 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.
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 model above needs some improvement. Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.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_forwardWhen using subtype associations, talk about the database table choices that are accessible.Decide the design you want to employ and talk about the relevant issues.arrow_forward
- Q2. 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_forwardPlease follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.arrow_forwardWhat is the difference between an attribute with numerous values and a recurring group?arrow_forward
- When using subtype associations, talk about the database table choices that are accessible.arrow_forwardExplain why an index is only helpful if an attribute's values are sufficiently diverse.arrow_forwardSQL DDL corresponding to this schema (i.e. the CREATE TABLE statements Database Schema:branch ( branch_name, branch_city, assets )customer ( ID, customer_name, customer_street, customer_city )loan ( loan_number, branch_name, amount )borrower ( ID, loan_number )account ( account_number, branch_name, balance )depositor ( ID, account_number )arrow_forward
- Discuss your database table possibilities for creating subtype relationships. Talk about what you would look for in a design and how it might affect your final selection.arrow_forwardDatabase Foundations: Design a database to produce the following reports. Do not use any surrogate keys in your design. For each guide, list the guide number, guide last name, guide first name, address, city, state, postal code, telephone number, and date hired. For each trip, list the trip ID number, the trip name, the location from which the trip starts, the state in which the trip originates, the trip distance, the maximum group size, the type of trip (hiking, biking, or paddling), the season in which the trip occurs, and the guide number, first name, and last name of each guide. A guide may lead many trips and a trip may be led by many different guides. For each client, list the client number, client last name, client first name, address, city, state, postal code, and telephone numberarrow_forwardStudy the scenario and complete the question(s) that follow: A vet clinic "XYZ Vets" has a website with registration and login pages for its clients. The registration form contains standard registration details such as client name and surname, phone number, email address and password. You have been asked to create the relevant SQL table. The data collected should be stored and validated such that only properly authenticated clients would be granted access to the vet appointment booking page. You are not required to create the vet appointment booking page. However, you are required to verify successful authentication. With the use of MYSQL: 4.1 Create a relevant SQL table for storing the data. 4.2 Store the registration details. 4.3 Authenticate clients. 4.4 Upon successful authentication of clients, display relevant client information with a personalised message.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 EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable 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