Company organized into DEPARTMENT. Each department has unique name and a particular employee who manages the...

Company organized into DEPARTMENT. Each department has unique name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations.  A department controls a number of PROJECTS. Projects have a unique name, number and a single location.  Company’s EMPLOYEE name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate supervisor for the employee.  Employee’s DEPENDENT is tracked for health insurance purposes (dependent name, birthdates, relationship to employee). Construct an ER Diagram for Company having given details. Construct appropriate tables for the above ER Diagram

Expert Solution

According to the question the entities are as follows:-

Employee
Department
Project
Dependent

The relationship among entities are as follows:-

Employee works for Department
Employee supervise other Employee
Employee manages Department
Employee works on Project
Employee depends upon Dependent
Department control Project

The ER diagram is as follows:-

The appropriate tables for the above ER diagram is as follows:-

Employee (Fname, Minit, Lname, SSN, BDate, Address, Sex, Salary, Super_SSN, Dno)
Department (Dname, Mgr_SSN, Mgr_start_date)
Dept_Locations (Dname, Dlocation)
Project (Pname, Pnumber, Plocation, Dum)
Works_on (ESSN, Pname, hours)
Dependent (ESSN, DependentName, BDate, Relationship)

In above relation schema primary keys are represented by italic and underline and foreign key by bold

venereology answered 1 year ago

List department name, employee id, and employee name for all employees in department name order. Repeat...

List department name, employee id, and employee name for all employees in department name order. Repeat for department #10 only. List the course ID, course name, section, instructor name, day, time, and room for all course sections. List the course ID, course name, section, student ID, and student name for CRN 1003. Display the list in ascending order of student last and first names. DROP TABLE registration; DROP TABLE sections; DROP TABLE courses; DROP TABLE students; DROP TABLE instructors; CREATE...

Jose Ruiz manages a car dealer’s service department. His department is organized as a cost center....

Jose Ruiz manages a car dealer’s service department. His department is organized as a cost center. Costs for a recent quarter are shown below. Cost of parts $ 22,400 Mechanics’ wages 14,300 Manager’s salary 8,000 Building depreciation (allocated) 4,500 Shop supplies 1,200 Utilities (allocated) 800 Administrative costs (allocated) 2,200 Calculate the total costs that would appear on a responsibility accounting report for the service department.

Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department...

Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr 5568 Sales 2102 6/1997 407-366-5500 0005 Robert Davis Davis Manager 713...

Develop an algorithm to implement an employee list with employee ID ,name designation and department using...

Develop an algorithm to implement an employee list with employee ID ,name designation and department using link list and perform the following operation on the list i)add employee details based on department ii)remove employee details iv)count the number of employee in each department

The centralized employee Travel Department of Ohno Company has expenses of $106,600. The department has serviced...

The centralized employee Travel Department of Ohno Company has expenses of $106,600. The department has serviced a total of 8,200 travel reservations for the period. The South Division has made 6,232 reservations during the period, and the West Division has made 1,968 reservations. How much should each division be charged for travel services? Do not round interim calculations. South Division $ West Division $

The centralized employee travel department of Croce Company has expenses of $724,000. The department has serviced...

The centralized employee travel department of Croce Company has expenses of $724,000. The department has serviced a total of 5,000 travel reservations for the period. The South Division has made 2,850 reservations during the period, and the West Division has made 2,150 reservations. South Division West Division Sales $2,600,000 $2,420,000 Cost of goods sold 1,352,000 1,379,400 Selling expenses 520,000 484,000 Use the data provided to determine the divisional income from operations for the South and West divisions: Refer to the...

Service Department Charges The centralized employee Travel Department of Duden Company has expenses of $52,800. The...

Service Department Charges The centralized employee Travel Department of Duden Company has expenses of $52,800. The department has serviced a total of 2,400 travel reservations for the period. The South Division has made 1,056 reservations during the period, and the West Division has made 1,344 reservations. How much should each division be charged for travel services? Do not round interim calculations. South Division $ West Division $

java/netbeans 1.Design an abstract class Employee that stores: employee name, unique auto-generated id, hire year. Implement...

java/netbeans 1.Design an abstract class Employee that stores: employee name, unique auto-generated id, hire year. Implement any necessary methods in addition to: a.The toString and equals methods. The equals method should NOT compare the id. b.The copy constructor (should copy the same id too) c.An abstract method float getWeeklyCheckAmount() d.Implement the appropriate interface to be able to sort employee names in alphabetical order. Subclasses should NOT be allowed to override this implementation. 2.Design an abstract class HourlyWorker that extends Employee...

You are a software development employee at a startup company. Your HR department has tasked the...

You are a software development employee at a startup company. Your HR department has tasked the IT department with developing a simple application (Windows Form Application) to load and display employee records. Your application will need to do the following: Create an Employee Class with the following properties: First Name Last Name Street Address City State Zip Create a sub class for Managers which inherits from the Employee Class. The Manager class will have the following additional properties: Cost Center...

JAVA PROGRAMING In a particular factory,a shift supervisor is a salaried employee who supervises a shift.In...

JAVA PROGRAMING In a particular factory,a shift supervisor is a salaried employee who supervises a shift.In addition to a salary,the shift supervisor earns a yearl bonus when his or her shift meets production goals.Design a ShiftSupervisor class that extends the Employee class. TheShiftSupervisor class should have a field that holds the annual salary and a field that holds the annual production bonus that a shift supervisor has earned.Write one or more constructor and the appropriate accessor and mutator methods for...

Question