Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Draw the class diagram for these scenarios for entities it should have primary key.
Scenario 1
A hotel caters mainly to company retreat groups, and wants to model this information to use in a management system. A retreat group consists of a number of that company’s employees as hotel guests. The system needs to track which room each guest stayed in, as well as which group the guest is part of.
Scenario 2
A library wants to model information about its inventory, and which patrons have which books checked out. The library can have multiple copies of a single title, and the model needs to indicate which copy of the title is checked out by a particular patron.
Scenario 3
A doctor's office providing health services needs to track all of its patient visits. The date of the visit, along with any diagnoses needs to be stored. Keep in mind that a patient can have more than one diagnosis per visit, and that any particular diagnosis can be made to multiple patients.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 3 images
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 this unit, we explore the structured approach to modeling business processes. In this practical assignment, using the business process of a fictional package delivery service (a courier company) called On the Spot Courier Services, you will create data flow diagrams that demonstrate the business processes that would need to be supported by a new system. Scenario: When Bill got an order, at first, only on his phone, he recorded when he received the call and when the shipment would be ready for pickup. Sometimes, customers wanted immediate pickup; sometimes, they were calling to schedule a later time in the day for pickup. Once he arrived at the pickup location, Bill collected the packages. It was not uncommon for the customer to have several packages for delivery. In addition to the name and address of the delivery location, he also recorded the time of pickup. He noted the desired delivery time, the location of the delivery, and the weight of the package to determine the courier…arrow_forwardBackground: The question revolves around class diagrams, specifically the differences between class diagrams in analysis and those in design. The Question: I am wanting to know what two separate class diagrams that depict a banking system would look like (One diagram for the analysis phase, another depicting the design phase). I am not looking for anything complex, just two simple class diagrams that involve only four classes with in them: Bank, Account, Customer, & Transaction; that will highlight the differences between the analysis phase and the design phase for a banking system. Please and thank youarrow_forwardDraw a diagram for use case for vending machine. 1. Actors: • User: Interacts with the vending machine to make a purchase. • Maintenance Personnel: Responsible for restocking the vending machine and performing maintenance tasks. 2. Use Cases: • Select Product: The user selects a product they want to purchase. • Insert Payment: The user inserts the required payment (e.g., coins, bills, or cards). • Validate Payment: The vending machine verifies the payment provided by the user. • Dispense Product: If the payment is validated, the vending machine dispenses the selected product. • Provide Change: If the user's payment exceeds the product's price, the vending machine provides change. • Refill Stock: Maintenance personnel refills the vending machine with products when they run out. • Perform Maintenance: Maintenance personnel performs routine maintenance tasks on the vending machine. 3. Relationships: • User interacts with the vending machine to perform use cases such as selecting a…arrow_forward
- Draw a Use Case Diagram for Patient management system Vic’s hospital has a patient management system. A patient must register with the hospital before start of the treatment. Once registered, a doctor is assigned to the patient. The patient must be provided with an appointment date based on the urgency. A doctor meets the patient and request tests to be performed by labs. When the lab results are ready, a new appointment is set with doctor. Doctor meets the patient again and prescribe medicines and treatments/rehabilitation.arrow_forwardQuestion#3: Draw an activity diagram for the following scenario: In an online purchasing system, the buyer requests to buy an item. In parallel, the system looks up whether the item exists in the store and verifies if the buyer has an account with the system. If the buyer does not have an account, the system will ask for registration info from the buyer to open an account. If the buyer does not provide registration info, the system exits. If the item does not exist in the store, the system exits. If the item exists, the system will check if the item price is less than or equal to buyer’s account balance. If the buyer has enough money in the account to purchase the item, the system completes the purchase order successfully. If the buyer does not have enough money, the system exits.arrow_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_forward
- On class diagrams Examine these two diagrams; true or false? a) The right diagram has more information b) The left diagram has more information c) They are equivalent, but the right one is simpler d) They are equivalent, but the left one is simpler Availability Resources -available() schedule) +available) schedule() Vehicle Person Resources diwr0 Glbaded() slocation truckAssignment(). -current Task() Truck Employee Tools name employeeld phone skilset joblite tuckAsignmento currentlasko department VIN truck Truck Employee capacity weight department VIN rame enplopeid phone het drver sbaded() bcationt ToolKit ToolKit calegory tackarrow_forwardmade a case diagramarrow_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
- This is a continuation to the question above. The directions continue as follows: Also, create a Use Case diagram. Make sure to identify the entities as actors and show the interaction between each of the actors. Be sure to identify at least two processes and show all the actions between them. Don't forget to include a system boundary so we can determine which actions occur within the system and which are external to SIM. With the creation of the use case diagram, you should be able to create a model (or table) showing each object. For each object, be sure to outline associated attributes and methods. Hopefully, the use case diagram and the DFD will make this process fairly straightforward. The developers need 3 instance examples for each of the entities. I suggest that you use the data library and previously developed organizational chart to find examples.arrow_forwardDraw an ER Diagram for the following Business Situation: A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal database. Once the client has been searched in the database, representative will go forth and verify the client via personal information displayed through the database. Personal Information would include, full name, address, last 4 of social security, and account number. The project will assume that the business is domestic, and all clients are in the United States. Once the client is verified, representative can discuss business related queries, including transactional questions…arrow_forwardDraw an activity diagram for ticket vending process. A vending machine is used to dispense ticket. System will request for trip info and commuter will provide the info such as the destination. System then will process the trip info and request for payment. Commuter then provides payment. System then will analyze whether payment is being made by cash or card. If card been used, it will request for authorize from bank before it dispense the ticket. While if cash been used, it will direct dispense the ticket to commuter. If there is available balance, system will dispense the change to commuter. System then shows the "thank you" message before it ends the session.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