ZuoTi.Pro
Question

I need help making an UML Diagram for the follwoing: 1.         Department – Name, Number, Locations,...

I need help making an UML Diagram for the follwoing:

1.         Department – Name, Number, Locations, Manager, and Manager Start Date.

2.         Project – Name, Number, Location and Controlling Department.

3.         Employee – Name, ID Number, Sex, Address, Salary, Birth Date, Department. Both Name and Address can be a composite property, be that as it may it was not determined in the prerequisites.

4.         Dependent – Employee, Dependent Name, Sex, Birth Date, Relationship

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1


0 0
Add a comment
Know the answer?
Add Answer to:
I need help making an UML Diagram for the follwoing: 1.         Department – Name, Number, Locations,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Consider the relational database schema for a company below. EMPLOYEE/NAME, SSN, BDATE, ADDRESS, SEX, SALARY, SUPERSSN,...

    Consider the relational database schema for a company below. EMPLOYEE/NAME, SSN, BDATE, ADDRESS, SEX, SALARY, SUPERSSN, DNA) TA DEPARTMENT(DNAME, DNUMBER. MESSINS, MGRSTARTDATE) DEPT_LOCATIONS(DNUMBER. DLOCATION PROJECT(PNAME, PNUMBER. PLOCATION, DNLIM) WORKS_ONCESSN.PNG, HOURS) DEPENDENTESSN, DEPENDENT-NAME, SEX, BDATE, RELATIONSHIP) Write SQL statements for the following queries: a) List the names of those employees who work in the "Production" department (6 marks). b) Find the maximum salary, minimum salary, and the average salary among employees who work for the "Production department (6 marks). Count the...

  • Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project...

    Database Analysis and Design (ER diagram) After the requirement collection and analysis phase the software project of a database application about a company is described as follows: 1. The company is organized into departments. Each department has a name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have several locations. 2. A dept controls several projects, each of which has...

  • (help)Use this business description to make an ERD. A grocery store wants to keep track of...

    (help)Use this business description to make an ERD. A grocery store wants to keep track of its departments and employees.  For each department, the store wants to record a department ID, a name, and a location.  For each employee, the store wants to record an ID, a first name, a last name, a start date, and a phone number.  A department can have many employees. The store wants to be able to assign employees in more than one department. Part time employees can...

  • paython code :- UML A hospital is a very busy place with a lot of patients...

    paython code :- UML A hospital is a very busy place with a lot of patients and also a lot of employees to keep the system running perfectly. All people in the hospital have basic information like title, name, gender, address, and phone number. Employees of the hospital have extra information like employee-id and salary. For every 25 employees, there is a manager who is also an employee, but gets an allowance of 7% more than the salary. There are...

  • 1. {90 points} Your task is to design a 'Company database capable of storing information about...

    1. {90 points} Your task is to design a 'Company database capable of storing information about EM- PLOYEE(S), DEPARTMENT(s), and PROJECT(s). Knowing that: We store each employee's name composite attribute - {10 points}), social security number, address, salary, and telephone number. An employee is assigned to one department, but may work on several projects which are not necessarily controlled by the same department. We keep track of the number of hours that an employee works on each project - {10...

  • Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee...

    Please refer to the following business scenarios: (i) Using SELECT statements of SQL, find the employee id, first name, last name, job title and email of all employees working in Asia (i.e. all countries coming from the region     ‘Asia’). This query must be implemented as a nested query! (ii) Using SELECT statements of SQL, find the employee id, first name, last name, job title and supervisor id of employees who had worked for more than 3 years and completed...

  • 1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create...

    1) Create Conceptual Schema Diagram 2) Create a fully attributed Loagical Data Model Diagram 3) Create the SQL script that will generate the data model Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their...

  • You have been approached by a University for the design and implementation of a relational databa...

    You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database design process provided the following data requirements for the University Database system. Using the following requirements answer this...

  • Project Database Description After the requirement collection and analysis phase the software project of a database...

    Project Database Description After the requirement collection and analysis phase the software project of a database application about a company is described as follows: The company is organized into departments. Each department has an unique name, an unique number, and a particular employee who manages the department. We keep track of the start date when the employee began managing the dept. A dept may have multiple locations(cities). A dept controls a number of projects, each of which has a unique...

  • ERD Diagram Based solely on the description of library operations below (without making up any additional...

    ERD Diagram Based solely on the description of library operations below (without making up any additional facts/requirements) design a data model that avoids update anomalies. You can use text to describe your model if you want. If so be clear as to what columns have primary and foreign keys, as well as what table a FK refers to. You can sketch it out on paper and scan it. You can use Visio. You can use some other tool if you...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT