Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 2, Problem 2.39PAE
(a)
Program Plan Intro
Drawing an ERD for the given situations and answering the given questions:
Check that the attribute name follows the naming convention or not? check if there is any associative entity in the given ERD and write it if it is present in the ERD? Check is the given ERD allow the project to be created before it is assigned to any employee? How can we change the ERD if the billing rate changes in the middles of the project?
(b)
Program Plan Intro
Draw an ERD for the data and provide definitions of all the relationship in the solution.
(c)
Program Plan Intro
Draw an ERD for the data and model the section with another methods.
(d)
Program Plan Intro
Draw an ERD for the given situation. Answer whether you draw more than one relationship between physician and patient. Provide reason for same. Mention whether you include hospital as an entity type or not and if your ERD allow for the same patient to be admitted by different physicians over time. Ways in which you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted.
(e)
Program Plan Intro
Draw an ERD for the given situation. Assume that credit result is not reused for multiple credit requests. Redraw the ERD for this new situation using two entity types, and then redraw it again by using one entity type. Which of these two versions do you prefer, and why?
(f)
Program Plan Intro
Draw an ERD for this situation. After that consider a new attribute, Hourly Rate, which is the rate a consultant charges a company for each hour of his or her services. Redraw the ERD to include this new attribute. Now, consider that each time a consultant works for a company, a contract is written describing the terms for this consulting engagement. Contract has attributes such as Company ID, Consultant ID, and Contract Date. Assume that a consultant can still work foronly one company at a time, redraw the ERD for this new situation. Can we move any attributes to different entity types in this latest situation? As a final situation, now consider that although a consultant can work for only one company at a time, we now need to keep the complete history of all consulting engagements for each consultant and company. Draw an ERD for this final situation. Explain why these different changes to the situation led to different data models, if they did.
(g)
Program Plan Intro
Draw an ERD for the given situation:
(h)
Program Plan Intro
Draw an ERD for the given situation:
(i)
Program Plan Intro
Draw an ERD for the given situation:
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Create a USE CASE diagram with the following image. In the diagram illustrate all the use cases that can be performed by the Student
Question 3
Draw a detailed activity Diagram in draw.io and screenshot it for me. ( **Please take note is a detailed activity diagram)
Scenario
The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when…
2- Draw a use case diagram a person. A person can get married, get divorced, die or have children.
Create at least meaningful one and at least one meaningful relationship. You can
define extra tasks (use case) only if necessary.
Chapter 2 Solutions
Modern Database Management
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
- In detail please help with the following: Using a simple drawing, describe use case or system diagrams and their purpose. The drawing supplements the text, and the text explains the drawing.arrow_forwardCase 1: Create a use case diagram based for the system that follows. Consider the following Pet Groomers Appointment system: When making a booking, pet owners need to fill a booking form that states their name, address, phone number, and the pets' details such as pet name, breed and age. Owners will also enter their preferred date of appointment such as day and time. The admin receives the booking form and checks the groomer's schedule to see whether the time slot is booked. If the slot is free, the booking is scheduled and confirmation will be given. However, if the slot is booked, the admin will suggest the next available slot based on the day and time entered. If the pet owner agrees, they will confirm the booking and it will be scheduled. An assigned groomer will receive the booking under their schedule. The system will send a reminder to the owner 3 days before their appointment.arrow_forwardDraw ER diagram for the following upload the diagram ?? A laboratory has several chemists who work on one or more projects. Chemists also may use certain kinds of equip- ment on each project. Attributes of CHEMIST include Em- ployee_ID (identifier), Name, and Phone_No. Attributes of PROJECT include Project ID (identifier) and Start_Date. Attributes of EQUIPMENT include Serial_No and Cost. The organization wishes to record Assign_Date-that is, the date when a given equipment item was assigned to a particular chemist working on a specified project. A. chemist must be assigned to at least one project and one equipment item. A given equipment item need not be as- signed, and a given project need not be assigned either a chemist or an equipment item. Provide good definitions for all of the relationships in this situation.arrow_forward
- Create an Activity Diagram for the “Order Item(s)” or “Purchase Item(s)” use case (or chain of use cases). The name that you have given this Use Case or group of Use Cases may differ, but it should be quite a comprehensive Use Case(s) that should encapsulate the following: Customers buying non-prescription items. Customers buying prescription items. Customers buying any number of items at once (i.e. 1 or more). Order fulfillment by warehouse staff. Order fulfillment by pharmacists. This Use Case does NOT need to encapsulate: Customers browsing or searching for items. Customers logging into or creating accounts. Customer payment.Attached will be more information on the Pharm@Home Systemarrow_forwardReview the UML diagram provided for a game software application. A text version is available: Text Version for UML diagram Word Document. You may notice that it is incomplete - it is missing attributes and methods, and only includes a small portion of a complete game application. This is quite common! As a software developer, typically you will be given pieces of the puzzle or tasks to complete as part of a larger project and as a member of a larger team. It takes practice to focus on the information you are given to determine what you have and what steps you need to take to complete the task. Specifically, the game application requires that only one instance of the game be able to exist in memory at any given time. This can be accomplished by creating unique identifiers for each instance of the game. Complete the UML diagram to accurately represent a singleton pattern for the Game Service class. You should replace the question marks in the UML diagram with appropriate static and…arrow_forwardEntity-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_forward
- Design 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 a use case diagram using the below informationarrow_forwardIn this use case diagram, the operations done before boarding the plane are explained. Draw a use case diagram in accordance with the given ones.arrow_forward
- WEEK 1 ASSIGNMENT#2 Describe at least 5 objectives of testing, and provide an example of each.arrow_forwardRead the following description and select the most appropriate class diagram: A company realizes projects; each project is executed by a team of employees. For the sake of simplicity, multiplicities and attributes are not indicated.arrow_forwardQuestion 3 Draw an activity Diagram in draw.io and screenshot it for me. Scenario The exam unit uses the system after the subject registration period has closed. The system will display a list of subjects that have registered students. Using this list, the exam unit will plan out examination week. Examination week lasts 6 days, from Monday to Saturday. For each day, the exam unit will assign a subject to that day. Each day can have a total of 6 examination hours with subjects having 2- hour or 3-hour examinations. For example, if the subjects are 2-hour examinations, then 3 of them can be scheduled for the day and if the subjects are 3-hour examinations, then only 2 of them can be scheduled for the day. There can also be a mixture of 2-hour and 3-hour examinations. If the exam unit schedules too many examination hours for that day then the day resets and the exam unit needs to reschedule again. This process stops when all subjects have been scheduled.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning