Pearson eText for Modern Database Management -- Instant Access (Pearson+)
13th Edition
ISBN: 9780137305940
Author: Jeffrey Hoffer, Ramesh Venkataraman
Publisher: PEARSON+
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 2, Problem 2.38PAE
Review Figure 2-8LQ and Figure 2-22.
- Identify any attributes in Figure 2-22 that might be composite attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.
- Identify any attributes in Figure 2-22 that might be multivalued attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.
- Is it possible for the same attribute to be both composite and multivalued? If no, justify your answer; if yes, give an example. (Hint: Consider the CUSTOMER attributes in Figure 2-22.)
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Using the ERD diagram above, identify an attribute that might represent a Derived Attribute. Once you identify, explain why this is so. Is this the only attribute? Are there others?
Illustrate an Entity-Relationship Diagram (ERD) model using Crow’s Foot notation
Here we can have the following entities
1.patients:this entity will store the details of the patients and the attributes for this entity is
id(which is unique for each patient and can be used as a primary key)
name(this attribute will store the name of the patient and it is a composite attribute)
address(this attribute will store the address of the patient and it is multi valued attribute. )
contact_num(this is also a multi valued attribute which will store the contact details of the patient).
age(which is a derived attribute)
2.room:this entity will store the information about the details of the rooms. The attributes are.
id(this is unique for each room and can be used as a primary key)
room number(this will store the room number)
Total_bed(this will store the total number of beds present in that room)
3. Bed:this entity will store the information regarding to each bed present in an room, and the…
Create a logical data model documented with an ERD using the crow’s foot format. Be sure that each entity has the entity name at the top of the box, the primary key attribute or attributes in the middle of the box, and the non-key attributes in the bottom of the box. Lines should separate each part of the entity box. Follow these instructions about each ERD: ● The ERD must not have any many-to-many (m:n) relationships.
● All attributes must be placed within an entity.
● Each entity must have a primary key defined. A primary key can consist of one or more attributes.
● Each relationship must have a foreign key. Denote the foreign key(s) with the notation (FK) on the ERD. Remember that in a one-to-many relationship, the foreign key is placed in the entity that is on the many side of the relationship.
● Each relationship must include both a maximum and minimum cardinality for both sides of the relationship.
● Each relationship should have a verb or verb phrase to describe it.
Question:…
Chapter 2 Solutions
Pearson eText for Modern Database Management -- Instant Access (Pearson+)
Ch. 2 - Define each of the following terms: entity type...Ch. 2 - Match the following terms and definitions....Ch. 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 - Give an example, Other than those described in...Ch. 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 - Prob. 2.24PAECh. 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 - Prob. 2.29PAECh. 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 - Figure 2-27 represents a situation of students who...Ch. 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.46PAECh. 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
- Draw this ER Diagram, but note that: Ths diagram should adhere to compressed Chen notation : The ER diagram consists of four entities: Pet, Challenge, User, and Vote. The Pet entity has attributes such as id (primary key), name, species, age, and description to store information about each pet profile. The Challenge entity has attributes such as id (primary key), pet1_id and pet2_id (foreign keys referencing the Pet entity), start_date, end_date, and likes to store information about each challenge between two pets. The User entity has attributes such as id (primary key), name, and email to store information about users who participate in voting and challenge creation. The Vote entity has attributes such as id (primary key), challenge_id (foreign key referencing the Challenge entity), user_id (foreign key referencing the User entity), and vote to store information about user's vote for a particular challenge.arrow_forwardPlease, can you DRAW the NEW ER diagram to comply with the new requirements requested, and also indicate what type of cardinality each of the relationships between the entities has.arrow_forwardDraw and ERD digrame for my home work . Below are the standers that should be meet 1) Correct identification of all the entities. Entity names should follow the standard conventions, i.e., they should be singular nouns and written in CAPITAL letters, or at least the first letter is CAPITAL. 2) Correct identification of all the attributes for each of the entities .Correct identification of all the relationships with appropriate connectivity and participation. If the connectivity and/or participation are not clear from the assignment specification, the assumptions made should be clearly stated.3) Introduction of composite/bridging entity to represent many-to-many relationships. 4) Correct representation of strong and weak relationships (solid and dashed line) 5) Correct identification of all the primary keys and foreign keys. The primary keys should be underlined, and foreign keys should be italic.arrow_forward
- Q2 Review the data model provided in the case study. (1) List all entities and its type and (2) identify the type of participation constraint for each existing relationship and why the type you chose is correct.arrow_forwardCreate a “level of attributes” diagram for a car rental. Include its core benefit, expected attributes, and add-on attributes. Have any of these attributes changed over the past 10 years? Please explain your answer.arrow_forwardUse the ER Diagram shown on Figure 2 to anewer questions 6 and 7: 6. According to the ER diagram on Figure 2, which of the following is true? A) YearEnrolled is a derived attribute. B) STUDENT entity has multiple unique attributes. C) StudEmail is an optional attribute. D) None of the above. Answer: 7. According to the ER diagram on Figure 2, which of the following is true? A) A student must attend a college but can only attend a single college. B) Each college must have multiple students attending it. C) NumOfStudents is a composite attribute. D) None of the above. Answer: StudiD CollD StudName STUDENT Allends COLLEGE ColName StudEmail *** YearEnrolled (0) NumOIStudentsarrow_forward
- Draw ER Diagram considering the various entity sets and relationship sets that are related to Student Hostel System. User- Name, Password, Email, phone, place of live Staff- Name, Password, Phone, Email **Notes those are the advisors who can see the feedback and the complain of the students regarding to the hostels Reservation- bill, Email, location, date Hostel- name, location Notes: Dear team you can add attribute according to your experience in each entity and you can remove. Also I want report entity that contain Feedback and complain from students regarding to the hostel.arrow_forwardFind out five characteristics about each entity, and remember to take note of the primary key attribute, any composite or simple attributes, any multivalued attributes, and any derived attributes. To the extent possible, check the relevant boxes next to each quality.arrow_forwardProvide an example of what a Key Attribute is.arrow_forward
- Identify 5 entities making sure that these entities are related in some way (they have relationship). Also form the 5 entities make sure to identify at least 1 weak entity. Identify 5 attributes per entity making sure that you identify the primary key attribute, composite attribute, simple attribute, multivalued attribute and derived attributes. Label attributes accordingly. Create specific tables for the entities and attributes identified in # 1 and 2. Supply 10 tuples (row of values) for each table. Create the ERD for the entities mentioned above include relationship, connectivity and cardinality. For relationship make sure to indicate weak and strong relationship. Use Chen Model for the ERD.arrow_forward1. List down the types of attributes in the Entity-Relationship (ER) model.arrow_forwardCustomer, Sales Rep, Equipment, Manufacture, Warehouse, and Orders entities. It is essential for us to know the data structures so we can diagram the overall model. This can be difficult to explain in meetings, so diagrams will help tell the story as you review the logic. How would you link these tables? Do we need a main transactional table? What relationships exist among these entities? What are some of the business rules for these relationships? How would you state the cardinalities?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 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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY