Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can I have a step by step and detailed explanation on solving the following question and drawing the class diagram? You are asked to design

Can I have a step by step and detailed explanation on solving the following question and drawing the class diagram?

image text in transcribed

You are asked to design an information system to handle data of a company, Following requirements have been found during requirement analysis process. a) The employees should be identified based on their employee numbers. For each employee, it should be possible to record his/her age, basic salary and amount of overtime hours. Further the system should calculate the salary of each employee. b) The company consists of several departments and each department has a name and a unique identification number. The profit of each department should be calculated based on its earnings and expenses given as external inputs. c) A department is responsible for handling projects. Each project is given a unique identification number. The budget of a project is computed based on number of parameters of same type. d) A department may or may not have employees attached to it. Further an employee is attached exactly to one department. e) Each project is handled only by one department and a department may handle any number of projects. Also, there are departments that do not handle any projects. 1) An employee can work in multiple projects. There are projects without any employees. There may be many employees working for a given project. Further there are employees who do not work on any project Draw the corresponding class diagram for the above scenario using Microsoft Word

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Semantics In Databases Second International Workshop Dagstuhl Castle Germany January 2001 Revised Papers Lncs 2582

Authors: Leopoldo Bertossi ,Gyula O.H. Katona ,Klaus-Dieter Schewe ,Bernhard Thalheim

2003rd Edition

3540009574, 978-3540009573

More Books

Students also viewed these Databases questions