Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 9, Problem 9.38PAE
Program Plan Intro
To create a star schema for the given case and explain how to handle time dimension.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
I understand the intentions of a database, being to streamline the data record-keeping of any organizations. And I understand the hardware needed to do such. The area I find myself the most lost in is the idea of programming the rules and structure of a database. In my head a database is a chart (or multiple charts) with fields that is used to store records. And then those records stored in one chart intertwine with other charts of course so we need to have relationships between the charts. Where I get lost is in the thought of programming a structure for the data to fit in. Are we making metaphysical locations to store data or are we just writing relationshipds between data that is stored on a plethora of different options?
I understand the purpose of a database, which is to make data record-keeping easier for any company. And I'm aware of the hardware requirements. The concept of programming the rules and structure of a database is the area in which I am most confused. A database, in my mind, is a chart (or many charts) containing fields that are used to hold records. Then, of course, those records in one chart interweave with those in other charts, necessitating the creation of chart linkages. The concept of developing a framework for the data to fit into is where I get stuck. Are we creating metaphysical venues to store data, or are we just recording relationships between data saved on a variety of platforms?
Suppose your task as a software engineer at Big-University is to design a data mining system to
examine their university course database, which contains the following information: the name,
address. And status (e.g.. undergraduate or graduate) of each student, the courses taken, and their
cumulative grade point average (GPA).
Describe the architecture you would choose. What is the purpose of each component of this
architecture.
Chapter 9 Solutions
Modern Database Management (12th Edition)
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 - 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.17RQCh. 9 - What is the purpose of conformed dimensions for...Ch. 9 - Prob. 9.19RQCh. 9 - Prob. 9.20RQCh. 9 - Prob. 9.21RQCh. 9 - Prob. 9.22RQCh. 9 - Prob. 9.23RQCh. 9 - Prob. 9.24RQCh. 9 - Describe the current key trends in data...Ch. 9 - Prob. 9.26PAECh. 9 - Prob. 9.27PAECh. 9 - Prob. 9.28PAECh. 9 - Prob. 9.29PAECh. 9 - You are to construct a star schema for Simplified...Ch. 9 - Simplified Automobile Insurance Company would like...Ch. 9 - Prob. 9.32PAECh. 9 - Prob. 9.33PAECh. 9 - Prob. 9.34PAECh. 9 - Prob. 9.35PAECh. 9 - Prob. 9.37PAECh. 9 - Prob. 9.38PAECh. 9 - Prob. 9.39PAECh. 9 - Prob. 9.40PAECh. 9 - Prob. 9.41PAE
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 ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Complete the table to define all of the entities and relationships. First one is done for you. Consider one of the relations as a composite relationship. ENTITY INSTRUCTOR RELATIONSHIP Teaches CONNECTIVITY 1:M ENTITY CLASSarrow_forwardThe Database Technique is the preferred approach in the business sector nowadays when it comes to database construction. Take into account the following three justifications for why this approach is better than the File Approach:arrow_forwardThe ABC Engineering (ABCE) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The ABCE administrator gives you the description of the training group's operating environment. ABCE has 12 instructors and can handle up to 30 trainees per class ● ● It offers five Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes Each class is taught by one instructor Each instructor may teach up to two classes or may be assigned to do research only Each trainee may take up to two classes per year Create an ERD to show the relationship between the entities listed in Part (a). If there are any M:N relations, create a composite entity to serve as a bridge.arrow_forward
- The term "database as a service," or DaaS for short, refers to this model. What is it actually, and how does it carry out its duties? What are some of the benefits and drawbacks of using a technique that is based on DevOps, and how can it be implemented?arrow_forwardProblem: Your team of Data Analysts have been asked to create a database design for the Boeing X Aircraft Company (BAC), which has two HUD (heads-up display) products: TRX-5A and TRX-5B. The database must enable managers of BAC to track blueprints, parts, and software for each HUD, using the following business rules: For simplicity’s sake, you may assume that the TRX-5A unit is based on two engineering blueprints and that the TRX-5B unit is based on three engineering blueprints. You are free to make up your own blueprint names. All parts used in the TRX-5A and TRX-5B are classified as hardware. For simplicity’s sake, you may assume that the TRX-5A unit uses three parts and that the TRX-5B unit uses four parts. You are free to make up your own part names. BAC wants to keep track of all part price changes and the dates of those changes. BAC wants to keep track of all TRX-5A and TRX-5B software. For simplicity’s sake, you may assume that the TRX-5A unit uses two named software components…arrow_forwardB.The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company's training program. The HEG administrator gives you the following description of the training group's operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year. Given that information, do the following: Define all of the entities and relationships. (Use Table 4.4 as your guide.) Describe…arrow_forward
- The database stores an employee table consisting of 500,000 records each of which is 400 bytes long. A SSD has storage capacity of 1 TB, read bandwidth of 1 GB/sec., and a block size of 4096 bytes. The database designer wants to add a large description field of 1,000 bytes to each employee record. However, this field will only have data in it 20% of the time and is only accessed in 25% of the queries. 1)Calculate: The average time (in seconds) to read the whole table when using spanned, fixed records and no splitting. 2)Calculate: The average time (in seconds) to read the whole table when using spanned, variable records. Assume a variable length record requires 20 bytes of overhead to store record information. 3)Calculate: The average time (in seconds) to read the whole table when using spanned records and splitting. Assume using splitting requires 20 bytes of overhead. The large 1000 byte field is only access 25% of the time.arrow_forwardFor the aviation industry, "snapshot isolation" serves as an example of a database design. In the case that airlines improve their overall performance, is it appropriate to choose a strategy that does not lend itself to serialization?arrow_forwardHow do serialization frameworks deal with data versioning?arrow_forward
- Tropic Vibe Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer. • Each musician that records at Tropic Vibe has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone. • Each instrument used in songs recorded at Tropic Vibe has a unique identification number, a name (e.g., guitar, synthesizer, flute) and a musical key (e.g., C, Bflat, E-flat). • Each album recorded on the Tropic Vibe label has a unique identification number, a title, a copyright date, a format (e.g., CD or MC), and an album identifier. • Each song recorded at Tropic Vibe has a title and an author. • Each musician may play several instruments, and a given instrument may be played by several musicians. • Each album has a number of songs on it, but no song may appear on more…arrow_forwardA small Hotel owner wish to computerized the management of hotel operations. You are asked to assist in the development of a database for the hotel. The database keeps data about ROOM, EMPLOYEE and FACILITY. From the discussion session with the hotel manager, you have identified the following information: • Three types of ROOMS offered by the hotel are single, double and deluxe room. Each room is identified by its unique number. • In general, there are two main types of the hotel jobs, GUEST SERVICES and ADMINISTRATIVE & SUPPORT. • HOTEL MANAGER, EVENT PLANNER and ACCOUNTANT are the administrative and support job positions in the hotel. • Types of employee falls under the guest services are RECEPTIONIST, HOUSEKEEPER, or KITCHEN STAFF. • Each RECEPTIONIST is identified with her/his name, employee number and years of experience. • The receptionists need to assign a HOUSEKEEPER to each room every morning or whenever it required before the room can be assigned to a guest to ensure…arrow_forwardDraw er diagramarrow_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