MODERN DATABASE MGMT.(PEARSON CHANNEL)
13th Edition
ISBN: 9780136709299
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
draw the er diagram and label
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.
Case 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.
Chapter 2 Solutions
MODERN DATABASE MGMT.(PEARSON CHANNEL)
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
- Create an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, anending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S.or Ph.D.). Each project is managed by one professor (known as the project’s principalinvestigator). Each project is worked on by one or more professors (known as the project’s co-investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project’sresearch assistants). When graduate students work on a project, a professor must supervise their work on the project. Graduate students can work on multiple projects, in which case they will have a (potentially different) supervisor for each one. Departments have a department number, a department name, and a main office. Departments have a professor (known…arrow_forwardCreate an ER/EER diagram for the following 1. Professors have an SSN, a name, an age, a rank, and a research specialty. Projects have a project number, a sponsor name (e.g., NSF), a starting date, an ending date, and a budget. Graduate students have an SSN, a name, an age, and a degree program (e.g., M.S. or Ph.D.). Each project is managed by one professor (known as the project's principal investigator). Each project is worked on by one or more professors (known as the project's co- investigators). Professors can manage and/or work on multiple projects. Each project is worked on by one or more graduate students (known as the project's research assistants). When graduate students work on a project, a professor must supervise their work on the project.arrow_forwardCreate an analysis connecting one or more points in this article to at least two of the CSE activities you completed earlier this semester. “Connecting” can take a wide variety of forms. For example, you might compare the ideas in this article with the ideas in one of the earlier CSE articles we worked with. You might take a theoretical framework and/or practical case we worked with earlier and apply ideas in this article to the theory, the practice, or both. (Please type answer no write by hand)arrow_forward
- Draw 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_forwardwhat is the correct answearrow_forwardCreate 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_forward
- Draw an Enhance ER diagram for the given situation. (20 points) A non-profit 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, date of birth and telephone number. The organization also needs to know the age of the person in any given time. Three types of persons of greatest interest to the organization are employees, volunteers and donors. For each employee, date of hiring is needed while for the volunteers, their skill is also gathered. Donors only have a relationship (named Donates) with an item entity type whose attributes include item_no and description. The date of donation of the item is also recorded. A donor must have donated one or more items, but an item may have one or more donors or no donor at all. There are persons other than employees, volunteers or donors who are of interest of the organization, so that the…arrow_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_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_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_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_forwardDraw an activity diagram, which takes the parameters of month/year and returns the number of days in the month of the year. In each leap year, the month of February has 29 days instead of 28. Note that the following three criteria are taken into account to identify leap years: • The year is divisible by 4; • If the year can be divided by 100, it is NOT a leap year, unless; • The year is also divisible by 400, then it is a leap year.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