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.37PAE
Program Plan Intro
(a)
To design:
A star schema for the given information.
Program Plan Intro
(b)
To estimate:
The number of rows in the fact table.
Program Plan Intro
(c)
To estimate:
The total size of the fact table assuming average 15 bytes for each field.
Program Plan Intro
(d)
To find:
Another way to change the design of this data mart.
Program Plan Intro
(e)
To propose:
A design for star schema to allow the slow changes in the entities over the time.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Considering the un-normalized relational table PROJECT below:
PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork,
ManagerPhone)
The attributes of PROJECT table satisfy the following properties:
Each project has many employees,
Each employee may involve in one or more projects,
Projects are managed by managers; there are many managers in the
company, hence a project may be assigned to any one of the managers, but
each manager manages only one project.
Each project is located in a specific location,
The number of hours an employee works at each project is determined by a
project title and the name of an employee.
Each manager has a telephone number.
Normalize the relational table PROJECT into a minimal number of relational tables
in BCNF. Use the functional dependencies to prove that each one of the relational
tables obtained from the decomposition of the original table is in BCNF.
A college course may have one or more scheduled sections or may not have a scheduled section. Attributes of COURSE include Course ID, Course Name, and Units. Attributes of SECTION include Section Number and Semester ID. Semester ID is composed of two parts: Semester and Year. Section Number is an integer (such as 1 or 2) that distinguishes one section from another for the same course but does not uniquely identify a section. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?
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
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
- Regional Labs is a company that conducts research and development work on a contract basis for other companies and organizations. Figure 2-31 shows data that Regional Labs collects about projects and the employees assigned to them. This data is stored in a relation (table) named PROJECT: PROJECT (ProjectID, EmployeeName, EmployeeSalary)arrow_forwardCreate 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:…arrow_forwardConsider the following Staff relational schema: STAFF (STAFFNO, NAME, DOB, GENDER, DOJ, DESIGNATION, BASIC_PAY, DEPTNO)arrow_forward
- 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.arrow_forwardExplain why an index is only helpful if an attribute's values are sufficiently diverse.arrow_forwardRefer to the dimension tables and EmployeeFact table below. Job Date Location EmployeeFact •JobID •DatelD •LocationID • ( OEmployeelD Title FullDate StreetAddress oJobID JobCode DayNumber City PostalCode OLocationID LevelCode MonthNumber oHireDatelD OBirthDatelD ) SalaryAmount BonusAmount MonthName State Year CountryCode EducationYears PerformanceRating The following query reports the employee with the highest salary amount per postal code for employees with level code 8. Complete the missing values. SELECT CountryCode, EmployeeID, MAX(_ _(A)_ FROM (B). Location, Job WHERE EmployeeFact.LocationID = Location.LocationID AND EmployeeFact.JobID = (C). AND = 8 GROUP (A) Ex: Identifier (B) (C)arrow_forward
- QUESTION 6 The attributes made up of more than one single attributes are called Single Value Composite Multi-value Derivedarrow_forwardto de Category 15 PK to do id PK category id name description create date 18 deadine FK categoryid FK user id create date user PK user id first name last name email create_date The above ER Diagram shows a simple TODO tasks management database. The create table script for Category table is given to you below. Complete the script by providing the correct definitions of the other two tables. Choose the data types of each attribute and assume all primary keys to be auto incrementing integers. Create Table Category ( user_id int primary Key identity(1,1), name varchar(255),arrow_forwardThe value range of an attribute must be large enough for the index to be relevant. Except for this one use case, an index is never helpful.arrow_forward
- Assume the following relational model representing the design for BurgerBay database and use it to answer questions 1. Using BurgerBay relational model, write the SQL statements to create the tables Supply, Schedule and Employees.Use the following information to define your attributes. SupplierID : integer ; Each supplier must provide supplies RestaurantLicense : integer ; Each restaurant must have supplies ; Each restaurant must have an employee schedule ScheduleID: integer EmployeeID: integer Day: date format ; required value StartTime: integer; required value EndTime: integer; required value EmployeeName: 50 characters maximum; required value NbrYearEmployed: integer; optional value Employee_Type: 1 character; required value; only allowed values are ‘C’ (for Cook) and ‘M’ (for Manager) 2. Using BurgerBay relational model, write the SQL statements answering the following queries : a. Display the name and city of all suppliers. SELECT SupplyName, City FROM…arrow_forwardWhen an attribute is part of a composite primary key, it is also considered a candidate key for the table.arrow_forwardExplain why an index is only helpful if the values of an attribute have a suitable range of values.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