Modern Database Management
13th Edition
ISBN: 9780134792293
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.26PAE
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:
CHECKING: Acct No, Date Opened, Balance, Service Charge
SAVINGS: Acct No, Date Opened, Balance, Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment
Assume that each bank account must be a member of exactly one of these subtypes. using generalization, develop an EER model segment to represent this situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. Remember to include a subtype discriminator.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A bank has three types of accounts: checking,
savings, and loan. Following are the attributes
for each type of account: CHECKING: Acct No,
Date Opened, Balance, Service Charge
SAVINGS: Acct No, Date Opened, Balance,
Interest Rate
LOAN: Acct No, Date Opened, Balance, Interest
Rate,
Payment
Assume that each bank account must be a
member of
exactly one of these subtypes. Using
generalization,
develop an EER model segment to represent
this situation
using the traditional EER notation, the Visio
notation, or the
subtypes inside supertypes notation, as
specified by your
instructor. Remember to include a subtype
discriminator
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?
Draw an ER diagram with the following data:
Entities: Student, Exam, Course
⚫ Relationships:
• Student takes at least one exam
o An exam is given to at least one student.
。 An exam concerns only one course
o A course has a least one exam
■ Attributes: Stud_Roll No, Stud Name, Stud Age, Course_No, Course_Name,
Course Hours, Exam_No, Exam date, Exam Duration, Exam_Mark.
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Leap Year Detector Design a program that asks the user to enter a year, and then displays a message indicating ...
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
Porter’s competitive forces model: The model is used to provide a general view about the firms, the competitors...
Management Information Systems: Managing the Digital Firm (15th Edition)
(Display three messages) Write a program that displays Welcome to Java, Welcome to Computer Science, and Progra...
Introduction to Java Programming and Data Structures, Comprehensive Version (11th Edition)
Why might doctors and nutritionists be interested in a device like DietSensor?
Using MIS (10th Edition)
Apply the normalization process to the Veterinary Office ListVersion One relation shown in Figure 1-34 (see pag...
Database Concepts (8th Edition)
How does a computers main memory differ from its auxiliary memory?
Java: An Introduction to Problem Solving and Programming (7th Edition)
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
- ER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.arrow_forwardDraw an ER diagram and then map it into a relational schema(database) for the following scenario.• For each MEMBER we keep track of the unique MemdID, a well as Name, Zip, and the Datethe membership was paid.• For each MEMBERSHIP type we keep track of the unique Mid, as well as MName and Price• For each PASS CATEGORY we keep track of the unique PassCatID, as well as PCName andPrice• For each ONE DAY PASS we keep track of the unique PassID and Date• For each MERCHANDISE item we keep track of the unique MrchID, as well as Name andPrice• For each sale TRANSACTION we keep track of the unique Tid and Date• Each member pays for exactly one membership type; each membership type has at leastone member but can have many members.• Each member can buy many day passes but does not have to buy any, each day pass wasbought by exactly one member• Each day pass belongs to exactly one pass category; a pass category can have manyindividual day passes issued for it but does not have to have any. • Each…arrow_forwardCreate an ER model to represent the data used by the library.The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.arrow_forward
- Create an ER Model for the following requirements: A car has a make, model and year. A registration has a county and date. A person has an address and an age. A car may be owned by a person. A car may be registered to an owner. Explain your reasoning behind 1 choice you made between in the ER diagram in question 1. For example, why choose entity vs relationship, or weak entity vs ternary relationship, or use/disuse of an aggregation, or similar choices.arrow_forwardProblem 5: Draw an entity-relationship diagram for the following situation: Many students play many different sports. One person, called the head coach, assumes the role of coaching all these sports. Each of the entities has a number and a name. (Make any assumptions necessary to complete a reasonable diagram. List your assumptions.) The entity-relationship diagram you drew in Problem 5 represents the data entities that are needed to implement a system for tracking students and the sports that they play. List the tables that are needed to implement the system, along with primary, secondary, and foreign keys that are required to link the tables.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
- Entity-Relationship Diagram (ERD) is one of the data modeling tools that provides a software engineer with the ability to represent data objects, their characteristics, and their relationships. Use an ERD to describe the following scenario. A teacher is identified by an ID number (TID), last name (LName), and first name (FName). A project is identified by a project ID (PID) and title (T). A student is identified by an ID number (SID), last name (LName), and first name (FName). A teacher can supervise zero, one, or many students and a student is supervised by one teacher. A teacher must propose one or many projects and every project is proposed by one teacher. A student must work on one project and every project is worked by only one student.arrow_forwardneed diagram Design an ER schema for prescription monitoring based on the given data: Patients are defined by an identity number, a first name and a last name, and by a birth-date. Doctors are defined as well by an identity number, a first name, a last name, and a birth-date, while additionally they will be characterized by a work start date and a specialty. Pharmaceutical companies will be defined by a name, and a telephone number. Medicines will be defined by a commercial name, their manufacturer, and their active ingredient. Pharmacies will be defined by a name, an address and a telephone number. Each patient has one doctor and each doctor has at least one patient. A doctor can prescribe certain medicines to his patients. Each pharmacy sells several medicines, each at a specific price. Each medicine can be sold by several pharmacies possibly at a different price. Pharmaceutical companies have contracts with pharmacies. Each pharmaceutical company may have contracts with several…arrow_forwardEER Design Exercise A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account: CHECKING: Acct. No, Date Opened, Balance, Service Charge SAVINGS: Acct. No, Date Opened, Balance, Interest rate LOAN: Acct. No, Date Opened, Balance, Interest rate, Payment Develop an EER model to represent this situation. Your model should be designed using Microsoft softwarearrow_forward
- Prepare an E-R diagram for a Aqarat (real estate) Company that lists property for sale. The following describes this organization: The company has a several number of offices. Attributes of office include Office_Number (identifier) and Location. Each office is assigned one or more employees. Attributes of employee include Employee_ID (identifier) and Employee_Name. An employee must be assigned to only one sales office. For each office, there is always one employee assigned to manage that office. An employee may manage only the office to which she is assigned. The company lists property for sale. Attributes of property include Property_ID (identifier) and Location. Components of Location include Address, City, State, and Zip_Code. Each unit of property must be listed with one (and only one) of the offices. A office may have any number of properties listed, or may have no properties listed. Each unit of property has one or more owners. Attributes of owners are Owner ID (identifier) and…arrow_forwardDraw an EER diagram for the following problem using this text's EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor. A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City /State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Iten1 entity type. A donor must have donated one or more items, and an item may have no donors or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more…arrow_forwardA 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_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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY