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
Videos
Textbook Question
Chapter 2, Problem 2.52PAE
Review your answer to Problem and Exercise 2-49 if necessary, Change the names of the entities, attributes, and relationships to conform to the naming guidelines presented in this chapter. Then, using the definition guidelines, write a definition for each entity, attribute, and relationship. If necessary, state assumptions so that each definition is as complete as possible
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Draw an Entity Relationship Diagram (ERD) based on the flat files that have been supplied. Your ERD must incorporate all the entities and attributes supplied, as well as establishing the relationships between the entities
The entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?
Explain entity sets.
Chapter 2 Solutions
Modern Database Management (12th Edition)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Prob. 2.2RQCh. 2 - Contrast the following terms: stored attribute;...Ch. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - State six general guidelines for naming data...Ch. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - State three conditions that suggest the designer...
Ch. 2 - List the four types of cardinality constraints,...Ch. 2 - Prob. 2.12RQCh. 2 - What is the degree of a relationship? List the...Ch. 2 - Give an example (Other than those described in...Ch. 2 - Give an example of each of the following, other...Ch. 2 - Give an example of the use of effective (or...Ch. 2 - State a rule that says when to extract an...Ch. 2 - Prob. 2.18RQCh. 2 - In addition to explaining what action is being...Ch. 2 - For the Manages relationship in Figure 2-12a,...Ch. 2 - Explain the distinction between entity type and...Ch. 2 - Why is it recommended that every ternary...Ch. 2 - A cellular operator needs a database to keep track...Ch. 2 - For each of the descriptions below, perform the...Ch. 2 - Answer the following questions concerning Figure...Ch. 2 - Prob. 2.26PAECh. 2 - You may have been assigned a CASE or a drawing...Ch. 2 - Consider the two E-R diagrams in Figure 2-25 Q,...Ch. 2 - The entity type STUDENT has the following...Ch. 2 - Are associative entities also weak entities? Why...Ch. 2 - Because Visio does not explicitly show associative...Ch. 2 - Figure 2-26 shows a grade report that is mailed to...Ch. 2 - Prob. 2.33PAECh. 2 - The Is Married To relationship in Figure 2-12a...Ch. 2 - Prob. 2.35PAECh. 2 - Figure 2-28 shows two diagrams (A and B), both of...Ch. 2 - Prob. 2.37PAECh. 2 - Review Figure 2-8LQ and Figure 2-22. Identify any...Ch. 2 - Prob. 2.39PAECh. 2 - Prob. 2.40PAECh. 2 - Prob. 2.41PAECh. 2 - Prob. 2.42PAECh. 2 - Prob. 2.43PAECh. 2 - Prob. 2.44PAECh. 2 - Prob. 2.45PAECh. 2 - Prob. 2.47PAECh. 2 - Prob. 2.48PAECh. 2 - Draw an ERD for the following situation. (State...Ch. 2 - Prob. 2.50PAECh. 2 - Prob. 2.51PAECh. 2 - Review your answer to Problem and Exercise 2-49 if...
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
- All entity names, relationship names, and attribute definitions must be correct.arrow_forwardAnswer these questions please. 1-Draw the Relational Schema for the relationship(s) between STORE and REGION. 2-Draw the Relational Schema for the relationship(s) between EMPLOYEE and STORE 3-Draw the Full Entity Relationship diagram showing the relationships among EMPLOYEE, STORE, and REGIONarrow_forwardFor each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-tomany or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.a. STUDENT and COURSE (students register for courses)b. BOOK and BOOK COPY (books have copies)c. COURSE and SECTION (courses have sections)d. SECTION and ROOM (sections are scheduled in rooms)e. INSTRUCTOR and COURSEarrow_forward
- Using the relations ATTACHED, normalize your relations into first, second, and third normal forms. First, KINDLY describe the changes required to your relations to meet the standard of the first 1NF and then 2NF and lastly 3NF. Then, you should provide an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labelled. Hint: Remember that in the hospital software system, the “Patient” relation includes the “medicines” attribute and the “Appointment” relation includes the “allergies” attribute. Allergies describe a list of any known allergies and medicines describe a list of medicines prescribed for a patient. Please add: Define or describe the changes required to get the relations into the 1st normal form. Define or describe the changes required to get the relations into the 2nd normal form. Include an Entity Relationship diagram in the 3rd normal form. The primary and foreign keys, at a minimum, are defined for each…arrow_forwardPlease help with the following: What concept is defined by the following definition? ”A set of entities of the same type that share the same properties and attributes.” Select one: a. All of the above b. Relation c. Entity set d. Relationship setarrow_forwardNeed help with creating logical diagram for this below table. need to use crow's foot notation. Identify Entities, Attributes, relationship between entities and cardinality identified between entities.arrow_forward
- Explain the rules and style guidelines for creating entity relationship diagramarrow_forwardDraw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…arrow_forwardBased on Entity Relationship Diagram (ERD) below; a) Write the correct business rules for all entities. b) Write the suitable relationship name for (a) and (b). RESERVATION GUEST ROOM PK RSV_ID PK GUEST_ID RSV_DATE PK ROOM_ID GUEST_NAME ARRIVAL_DATE (b) ROOM_TYPE GUEST_PHONENO (a) DEPART_DATE ROOM_RATE GUEST_ADDRESS NO_OF_GUESTS FK1 RSV_ID NO_OF_ROOMS FK1 GUEST_IDarrow_forward
- ERD Diagram LucidChart Please be sure to accurately draw each entity, connecting lines, cardinality, actions (relationships), and attributes. Please be sure to properly label – if appropriate – your attributes. Please be sure to designate a primary key and foreign key(s) for each attribute. Please sure to properly label your associative entity – if appropriate. Please be sure to add to your diagram entities “user defined” primary key fields and appropriate foreign key fields Red Light Minor Emergency Clinic located in Wichita Falls, Texas is a 24-hour clinic that provides patients with minor emergency medical care. The clinic would like you to draw and ERD diagram that depicts their customer care process. The nurses working at the clinic can provide care to many patients, and the patient can be seen by many nurses. The clinic would only like to track the nurse’s name (first name and last name). The clinic would like to keep track of the following patient information to include…arrow_forwardWhen using subtype associations, talk about the database table choices that are accessible.Decide the design you want to employ and talk about the relevant issues.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 Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY