Answered step by step
Verified Expert Solution
Question
1 Approved Answer
distributed database design (fragmentation) A multinational engineering company has decided to distribute its project management information at the regional level in Oman. The current centralized
distributed database design (fragmentation)
A multinational engineering company has decided to distribute its project management information at the regional level in Oman. The current centralized relational schema is as follows: Employee (NIN, FName, IName, address, DOB, gender, salary, taxCode, deptNo) Department (deptNo, deptName, managerNIN, businessAreaNo, regionNo) Project (projNo, projName, contractPrice, project ManagerNIN, deptNo) WorksOn (NIN, projNo, hoursWorked) Business (businessAreaNo, businessAreaName) Region (region No, regionName) Where Employee contains employee details, and the national insurance number NIN is the key. Department contains department details and deptNo is the key managerNIN identifies 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. Workson contains 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started