
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
Question
Draw a class diagram showing classes, attributes, operations, and relationships. If you believe that you need to make additional assumptions, do so.
Scenario: several employees are working at a company. The attributes of the employees include the employee ID, Employee Name, address, DOB. The company is running different projects. Projects attributes include the project name, the start date and end date.
Each employee may work on one or more projects or may not be assigned to a project. However, each project must be assigned to at least one employee.
- Make sure that you identify the PK for each class
- Your diagram must include Associative class
- Implement Generalization
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 2 steps with 1 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
- Draw a class diagramarrow_forwardshow agregation and verfiy your answer pleasearrow_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
- 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_forwardBuild a Visio class diagram and ERD diagram using these user classes Trainee services Fitness trainer products Personal trainer profile nutritionist payment Administrator massages Meals sales Salesdetail mealplan Workoutplanarrow_forwardAs an independent consultant, you have a contract with a university to develop an application to support course administration. Read the detailed description of this application and then complete the tasks that follow. A course has a unique course number and title and is assigned to one or more areas of the Computer Science program. Each course has an instructor, at least one teaching or research assistant, an online discussion forum, a delivery period (start date, end date), and a capacity (maximum number of participants). A course need not be offered each term, but the challenge option is open throughout the entire year. A course may have prerequisite courses, and a student is not allowed to register for a course if they have not fulfilled the prerequisites or their equivalent. In addition, a student who would like to challenge a course should have the course prerequisites or authorization from the course instructor. An instructor has an employee number, first name, last name,…arrow_forward
- You are asked to do a detailed design of part of a system using class diagram, modeling interactions and behaviour for a part of a library system. This part can be described as a use case: checkout an library item. In this use case, a librarian use the system to check out an item for a legitimate borrower. The system need to check the borrower’s record first and then update the library data, the borrower’s record etc. Design the graphic user interface for this use-case.arrow_forwardScenario: The Best Events Company organizes events, and business is booming, so much so that they need your help to manage their service. They want you to create a software system to manage their employees, clients, suppliers, and events. A part of their software requirement is given below. You are required to do a self-study on how event-organizing companies work and create a design for managing the company's functions. In addition to the requirements below, you are encouraged to add more attributes and functionalities to the system. The company has different types of employees, such as, Sales Managers, Salespersons, Marketing Managers, Marketers, Accountants, Designers and Handymen. Some details required for employees include name, employee ID, department, job title, basic salary, age, date of birth, and passport details are also stored in the system. The table below provides a glimpse of how employees are managed. It is clear from the table that Susan Meyers manages both Shyam…arrow_forward
arrow_back_ios
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