Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 401 Weeks Ago, 2 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 12 Nov 2017 My Price 9.00

multinational engineering company

A multinational engineering company has decided to distribute its project management information at the regional level in mainland Britain. The current centralized relational schema is as follows:

Employee (NIN, fName, lName, address, DOB, sex, salary, taxCode, deptNo)

Department (deptNo, deptName, managerNIN, businessAreaNo, regionNo)

Project (projNo, projName, contractPrice, projectManagerNIN, deptNo)

WorksOn(NIN, projNo, hoursWorked)

Business (businessAreaNo, businessAreaName)

Region (regionNo, regionName)

whereEmployeecontains employee details and the national insurance number NIN is the key. Department contains department details and deptNois the key. managerNINidentifies the employee who is the manager of the department. There is only one manager for each department. Project contains details of the projects in the company and the key is projNo. The project manager is identified by the projectManagerNIN, and the department responsible for the project by deptNo.WorksOncontains details of the hours worked by employees on each project and (NIN, projNo) forms the key.

Business contains names of the business areas and the key is businessAreaNo. Region contains names of the regions and the key is regionNo. Departments are grouped regionally as follows: Region 1: Scotland Region 2: Wales Region 3: England Information is required by business area, which covers: Software Engineering, Mechanical Engineering, and Electrical Engineering. There is no Software Engineering in Wales and all Electrical Engineering departments are in England. Projects are staffed by local department offices. well as distributing the data regionally, there is an additional requirement to access the employee data either by personal information (by Personnel) or by work related information (by Payroll).

 

Answers

Maurice Tutor
(5)
Status NEW Posted 12 Nov 2017 06:11 PM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)