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
Convert the Entity Relationship Diagram in to
relational database by using MS Access (Note: Students has
to create tables in the MS Access by giving appropriate
Primary key and Foreign key
relationships)
QI.
Customer
Order
OrderDetail
CustomeriD
OrderiD
OrderiD
(FK)
OrderDetaillD
Name
Mail
ZipCode
Address
Telephone
CustomeriD (FK)
OrderDate
TotalPrice
ProductiD (FK)
Amount
Price
Product
ProductiD
Name
Kind
Price
Use the ER Dlagram shown on Figure 1 to answer question 9:
9. According to the ER diagram on Figure 1, which of the following is true?
A) For each employee, we will keep track of either the employee name or the unique
employee ID.
B) For each department, we will keep track of either the unique department ID or the
department location.
C) Each employee reports to exactly one department. A department may have many
employees reporting to it, but it does not have to have any.
D) None of the above.
Answer:
EmpID
EmpName
EMPLOYEE
Reports To
Figure 1
DeptID
DEPARTMENT
DeptLocation
Create an ERD using Visio or any other tool for the following scenario.
Your ERD should show all the tables, attributes for each table and identify all primary and foreign keys.
A hair salon has many customers and many stylists - the first name, last name, and phone number need to be stored for customers and stylists.
The hair salon offers many services - hair cutting, styling, coloring, permanents, etc. Each service has a cost and the estimated time.
Customers schedule appointments with a stylist. The appointment can consist of one or more than one service - i.e. a person may want a hair cut and coloring.
Some customers purchase products at their appointments. A product has a brand, description, category and price.
Please show all work and the finished diagram. Thank you!
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
- A 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_forwardConvert the given ER diagram to Relational Data Model. Draw the complete diagram.arrow_forwardConversion of E-R diagram to relational schemaSchema is a correct translation of the E-R diagram submitted with appropriate tables, columns, primary keys, and foreign keys.arrow_forward
- Convert the given ER diagram to Relational Schema. Draw the complete diagram.arrow_forwardUse 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_forwardAssume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Abu Hurairah Club. The following are the data requirements gathered: The Abu Hurairah Club has a few animal shelters. Each shelter is identified by an identification number and has an address, a phone number, and a set of days on which it is open. A shelter is managed by one employee. An employee has an identification number, name, address, phone number, and a pay rate. A volunteer has an identification number, name, address, phone number, and a meal allowance. A person, who works at a shelter, is either an employee or a volunteer, but not both. A person may work at more than one shelter for some regular set of days each week. An animal is housed at one shelter. Each animal has an identification number that is unique to its shelter, a name, a birth date, and a species.arrow_forward
- 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?arrow_forwardDraw an ERD for the following requirements There are many air conditioners in EMU. Each air conditioner has a unique inventory number. We have to store the model and make of each air conditioner. Each air conditioner is located in a room. Each room is identified by a unique roomid. We also store the capacity and type of the room. Each air conditioner is serviced twice a year. For each service, we need to store the date of the service and the name of the person who performed the service.arrow_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
- Assume that you are a database specialist for Kulliyyah of Information and Communication Technology (KICT). You are required to create a conceptual data model for Abu Hurairah Club. The following are the data requirements gathered: The Abu Hurairah Club has a few animal shelters. Each shelter is identified by an identification number and has an address, a phone number, and a set of days on which it is open. A shelter is managed by one employee. An employee has an identification number, name, address, phone number, and a pay rate. A volunteer has an identification number, name, address, phone number, and a meal allowance. A person, who works at a shelter, is either an employee or a volunteer, but not both. A person may work at more than one shelter for some regular set of days each week. An animal is housed at one shelter. Each animal has an identification number that is unique to its shelter, a name, a birth date, and a species. Based on the requirements from a, b, c, d and e, draw…arrow_forwardNote: This question has been rejected three times now saying the question is incomplete. That's how the question is. Please do not reject it saying it is incomplete. The previous 4 questions were related. I was asked to provide question 3 but I will provide all of them. Question 1: Create the Entity Relationship (ER) Diagram for the following scenario. We want to maintain a database for a Faculty within a multi-campus regional university. The faculty has a number of schools and each school is characterized by its school-code which is unique, name and campus location. Schools employ professors who are characterized by their unique staff-id, name and the school they work for. A school offers courses that are characterized by their course-code which is unique, course name and the school. There are subjects offered within the faculty and these arecharacterized by unique subject-code, title and the school that offers them. Students enroll into courses that are characterized by student-id…arrow_forwardConsider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase 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:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher: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