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
Textbook Question
Chapter 2, Problem 2.19RQ
In addition to explaining what action is being taken, what else should a relationship definition explain?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Draw an entity-relationship diagram, including minimum and maximum cardinality, for the
following: The system stores information about two things: cars and owners. A car has attributes
for make, model, and year. The owner has attributes for name and address. Assume that a car
must be owned by one owner and an owner can own many cars, but an owner might not own
any cars (perhaps she just sold them all, but you still want a record of her in the system).
ENHANCE ENTITY RELATIOSHIP DIAGRAM
The entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations:
1. At a given time, a person must be exactly one of three subtypes.
2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.
3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time.
4. At a given time, a person must be at least one of these subtypes.
Design an Entity-Relationship (E-R) diagram for a university management system. The
system should capture information about the following:
. Students, with the following attributes: student ID, name, date of birth, and email address.
• Courses, with the following attributes: course ID, course name, and credit hours.
• Professors, with the following attributes: professor ID, name, and email address.
Additionally, consider the following relationships:
• A student can enroll in multiple courses, and a course can have multiple students enrolled.
• A course is taught by a single professor, and a professor can teach multiple courses.
Show all entities, attributes, and relationships in your E-R. diagram, including the cardinality of cach
relationship.
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
- Give a simple example of an E-R diagram for each concept and then write the business rules for each example. associative entity weak entity unary relationshiparrow_forwardQ1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.arrow_forwardCreate an Interaction Model Use Case Model 1. Create use case summaries for a Employee Payroll System, Some suggested names are: Enter employee information, Print employee pay Snub, Perform maintenance, Perform backup, View employee records, etc. 2. Create a use case description for “Print Employee Pay Snub"...You should have several use case descriptions but only list one for this assignment. 3. Create a Use Case diagram for an Employee Payroll System, Include at least 3 actors. Sequence Model 1. Create a Scenario for a sequence of events that occur during one particular execution the system This should be listed as one of the actors (or whatever you chose to name them) in the use case diagram. 2. Create a Sequence Diagram Note: there should be a Sequence diagram for each Use Case listed in your use case summary, (if there are 4 Use Cases there should be 4 Sequence Diagrams).arrow_forward
- Draw a simple class diagram that shows the following business rules. Include the multiplicities for each relationship. An employee has one office number, and a unique office number is assigned to an employee. A student club should at least have one student, and a student can join many other clubs in the university. A bank branch can have zero or more customers and each customer is on one and only one branch.arrow_forwardDraw an entity relationship (ER) diagram of subject enrollment through LMS.arrow_forwardDraw the UML use case diagrams for the following case studies. Write all the scenarios (steps) of actors that will be used in your use case diagrams and relationships between the actors. Also explain why those actors and relationships are necessary in your use case diagram.( Draw a use case diagram for the case study – Online shopping )arrow_forward
- draw the er diagram and labelarrow_forwardDesign the Entity Relationship Diagram (ERD) showing entities, attributes, primary key and relationship cardinality for the following scenario. Any employee works for only a department and under supervision of a manager (where manager is also an employee). Employee's address, city code & city name also has been recorded. Every employee may work for multiple project, but an employee may be on vacation and not assigned to any projects. Working hour may be different for an employee for different projects. Projects are broken into tasks; A task is created for one project and assigned to one department. Requisitions are made for projects; Each requisition could ask for any number of items; Items could be: equipment item or materials item and are coded in a similar way; Each requisition is for one project and is made to one supplier. The important data fields are employee_id, employee_name ,employee_address, employee_email, department_id, department_name, location, city_code, city_name,…arrow_forwardDraw an Entity Relationship Diagram for the following scenario A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be storedarrow_forward
- For a business of your choice, use a graphics program to develop a data-flow diagram of one of its main processes and an entity-relationship diagram showing the data within the scope of the system.arrow_forwardSuppose you are working within the framework of the conceptual model in Figure Q4.5. FIGURE Q4.5 THE CONCEPTUAL MODEL FOR QUESTION 5arrow_forwardData modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagramarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- 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
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher: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
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY