Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 8, Problem 8.66PAE
Program Plan Intro
Replacement of old information with new information and a composite usage map diagram.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Develop a simple data model for a student database that includes student data, student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete entity relationship diagram that shows how these tables are related to one another.
Develop a simple data model for a student database that includes student contact data, student demographic data, student grades data, and student financial data. Determine the data attributes that should be present in each table, and identify the primary key for each table. Develop a complete ER diagram that shows how these tables are related to on another.
Given the information package below, create the dimensional model having a star schema data design. Include the Primary keys (PK) and the Foreign Keys(FK) as needed.
Chapter 8 Solutions
Modern Database Management
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
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
- Use the database shown in Figure P3.10 to work Problems 10-16. Note that the database is composed of four tables that reflect these relationships: An EMPLOYEE has only one JOB_CODE, but a JOB_CODE can be held by many EMPLOYEES. An EMPLOYEE can participate in many PLANs, and any PLAN can be assigned to many EMPLOYEES. Note also that the M: N relationship has been broken down into two 1: M relationships for which the BENEFIT table serves as the composite or bridge entity. For each table in the database, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None. Create the ERD to show the relationship between EMPLOYEE and JOBarrow_forwardData/Database Management system . Consider the ER diagram shown below. Supply the relationship constraints using cardinality ratios and participation constraints on this diagram based on the following assumptions (you may use (min, max) notation if you prefer): An employee may work in up to two departments or may not be assigned to any department. Each department must have one and may have up to three phone numbers. Each department can have anywhere between 1 and 10 employees. Each phone is used by one, and only one, department. Each phone is assigned to at least one, and may be assigned to up to 10 employees. Each employee is assigned at least one, but no more than 6 phones.arrow_forwardMake an Entity relationship diagram and use the Erdplus and apply these requirments Using the Erdplus(use it to make this diagram, the answer should be as a Diagram) Q) Create an entity-relationship diagram (ERD) using min-max notation based on the following datarequirements of the University database:1. The university is organized into colleges, and each college has a unique number, unique name, and a particularfaculty member who is the dean of the college. Each college administers a number of academic departments.2. Each department has a unique name, a unique code number, and a particular faculty member who chairs thedepartment. We need to keep track of the start date when that faculty member began chairing the department.In addition, each department may have several faculties and must be administered by one college.3. A department offers several courses, each of which has a unique course name, a unique code number, a courselevel (Level: this can be coded as 1 for freshman level, 2…arrow_forward
- Please answer below questions based on this dimensional model and additional information provided Q1: What is the maximum possible fact data volume in terms of record/row count? Answer: Q3: The m:n ratio from attribute B3 to attribute B4 is changed from 1:3 to 1:1 due to some organizational changes. By how many times the maximum possible fact data volume (by record count) decreases? Answer: Q4: If there is an aggregate fact table at quarter dimension level with other attributes B4, C5 and A3. What is the maximum possible record count of this aggregate table as per the current state mentioned above? Answer:arrow_forwardYou must present an examination of "Population & Housing in San Diego County." The goal is to look for correlations between the shifting population and residential unit density in the county. How would you go about conducting this inquiry? Please specify which data files are needed and where they might be found (including any relevant references). Which data model will you use to conduct this investigation? (You do not need to finish the analysis but you may examine the data files on the web).arrow_forwardConstruct an E-R diagram and the relational schema for your favorite sports statistics. Define the attributes for each set by yourself. 1. You should include matches. 2. You should include players. 3. You should include teams. 4. A match has some teams playing in it. 5. One team has many players. 6. One match has many players participating in it.arrow_forward
- Consider the E-R diagram in Figure 8.9, which contains specializations, usingsubtypes and subtables. Can you create a person who is an employee and a student with the schema you created? Explain how, or explain why it is not possible.arrow_forwardYou have been asked to design part of a database for a hospital. Thehospital managers provided you with an informal description of theirdata which you can find on the next page in Figure 1.(a) Provide an Enhanced Entity-Relationship Model for the hospital’s data model (Figure 1) in form of a diagram in Chen notation. Identify special attributes (including keys) in the diagramand include participation and cardinality constraint annotationsfor your relationships.List and explain any additional assumptions you think you haveto make because the specification was unclear or incomplete.Note that there should not be many such extra assumptions.Marking CriteriaThe following criteria will be used to mark your model:• extent to which your model is correct, minimal (no featuremodelled twice), complete and expressive• correct use of Chen notation (including special attributes)• correct cardinality and participation constraints (includingnotation)• readability and presentation of your answer. You…arrow_forwardA derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made. You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design. Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed? Which attributes would you generally avoid indexing, and why?arrow_forward
- According to the data model, is it required that table every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why, or why not?arrow_forwardExplain the Entity-Relationship Diagram (ERD) and its components. How does it help in visualizing and designing data models?arrow_forwardPart 2: Relational data model. Take a subset of the ideas from the conceptual model you constructed in Part 1 and design a simple relationship model similar to the ones we discussed in Module 2, Video 4 Your model should have at least 5 tables You should include at least 20 attributes, or fields, in your model (20 total across all tables, not per table) Your model should be normalized Identify the primary key in each table, and state whether it is a natural or surrogate key For each relationship between tables, identify any foreign keys needed to define the relationship For each table, identify what type of system or systems you think the data might come from, like those we discussed in Module 1, Video 6.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning