Name ID Number Department Job Title Basic Salary Manager ID Susan Meyers 47899 Sales Manager 37,500 Joy Rogers 81774 Sales Manager 24,000 Shyam Sundar 11234 Sales Salesperson 20,000 47899 Mariam Khalid 98394 Sales Salesperson 20,000 81774 Salma J Sam 98637 Sales Salesperson 20,000 47899

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Chapter11: Building Solutions: Database, System, And Application Development Tools
Section: Chapter Questions
Problem 23CT
icon
Related questions
Question

Scenario: 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 Sundar and Salma J Sam, and Joy Rogers manages Mariam Khalid. These are the people that bring in the business for the company. teble:Name ID Number Susan Meyers 47899 81774 Joy Rogers Shyam Sundar 11234 98394 Mariam Khalid Salma J Sam 98637 Department Sales Job Title Manager Manager Sales Sales Sales Sales Salesperson Salesperson Salesperson Basic Salary 37,500 24,000 20,000 47899 81774 20,000 20,000 Manager ID 47899 Each event has clients and guests, which the system needs to manage. The client organizes the event, and the guests attend the event. Your system will need to keep track of clients and guests. ​ The company organizes four types of events: weddings, birthdays, themed parties, and graduations. The company has realized that it makes more business sense to outsource certain functions, such as, catering, cleaning, supplying furniture and decorations. Your system will need to keep track of each supplier. ​ Some of the information needed about each event includes Event ID, Type, Theme, Date, Time, Duration, Venue address, Client ID, Guest list, Catering company, Cleaning company, Decorations company, Entertainment company, Furniture supply company and Invoice. Some of the information required for clients includes Client ID, Name, Address, Contact details, and Budget. Some of the information required for guests includes Guest ID, Name, Address, Contact details. Some of the information required for venues includes Venue ID, Name, Address, Contact, Minimum number of guests, and Maximum number of guests. Some of the information required for caterers includes Caterer ID, Name, Address, Contact details, Menu, Minimum number of guests, and Maximum number of guests. ​ Your system must be able to create and manage events, as well as the clients, guests, and supply companies involved. ​ Requirements Your project must include the following: ​ Design a UML class diagram representing the concepts and relationships in the scenario. Ensure the use of the different types of association and inheritance relationships where necessary. You may make assumptions about attributes (with proper access specified) and concepts not explicitly mentioned in the problem statement. A clear description of the relationships and assumptions must be included. ​

Name
ID Number
Department Job Title
Basic Salary
Manager ID
Susan Meyers
47899
Sales
Manager
37,500
Joy Rogers
81774
Sales
Manager
24,000
Shyam Sundar
11234
Sales
Salesperson
20,000
47899
Mariam Khalid
98394
Sales
Salesperson
20,000
81774
Salma J Sam
98637
Sales
Salesperson
20,000
47899
Transcribed Image Text:Name ID Number Department Job Title Basic Salary Manager ID Susan Meyers 47899 Sales Manager 37,500 Joy Rogers 81774 Sales Manager 24,000 Shyam Sundar 11234 Sales Salesperson 20,000 47899 Mariam Khalid 98394 Sales Salesperson 20,000 81774 Salma J Sam 98637 Sales Salesperson 20,000 47899
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning