Considering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.

Considering the un-normalized relational table PROJECT below: PROJECT (ProjectTitle, EmpeName, ManagerName, Location, HoursWork, ManagerPhone) The attributes of PROJECT table satisfy the following properties: Each project has many employees, Each employee may involve in one or more projects, Projects are managed by managers; there are many managers in the company, hence a project may be assigned to any one of the managers, but each manager manages only one project. Each project is located in a specific location, The number of hours an employee works at each project is determined by a project title and the name of an employee. Each manager has a telephone number. Normalize the relational table PROJECT into a minimal number of relational tables in BCNF. Use the functional dependencies to prove that each one of the relational tables obtained from the decomposition of the original table is in BCNF.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

ITCS 285
If an employee can work for only one department and a department can have many employees (one to many relationship). Which answer the relationship table "work" that has the best values to describe the relationship between employee and department? The employee table has two columns (eid, name) with records ('E1','A'), ('E2','B'), ('E3','C'). The department table has two columns (did, name) with records ('D1','X'), ('D2','Y'), ('D3', 'Z'). work(eid, did) with values ('E1','D1'), ('E1','D2'), ('E2,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D2'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E2,'D3'). work(eid, did) with values ('E1','D1'), ('E2','D2'), ('E3,'D3').
Looking inside a script, you see this line: if [[ 'hostname' = 'bob' ]]; What is it doing? a) Nothing. It is trying to perform an integer comparison on a string. b) Checking to see whether the hostname command was successful. c) Changing the hostname to bob and checking to see whether that was successful. d) Checking to see whether the hostname is bob.
based of the image, write a sql statement that shows the total number of patients handle by each nurse. sort the result based on the nurse's ID and display the nurse's name too
Find the location that has average salary more than 4000 dollars. Usually each location mayhave several departments.A) select loc from dept, emp where dept.deptno = emp.deptno group by loc having avg(sal) > 4000;B) select loc from emp group by loc having avg(sal) > 4000;C) select loc from dept group by loc having avg(sal) > 4000;D) select loc from dept where deptno in (select deptno from emp group by loc having avg(sal) > 4000);E) select loc from dept where deptno in (select deptno from emp group by deptno having avg(sal) > 4000);
Describe the process of digital signature generation and verification. Explain how digital signatures ensure data authenticity and non-repudiation.
Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and contains strings like 'Home', 'Mobile', and 'Other'. Apply…
Please follow this ER diagram, give a description, and make a schema diagram from it. Also, make database (constraint tables) & intent some sample data. Lastly, run some SQL functions code. Please don't copy from anywhere. I need it for my project.
The value range of an attribute must be large enough for the index to be relevant. Except for this one use case, an index is never helpful.
Find the minimum number of tables required to represent the following given ER diagram in relational model. b_city (b_name Ac_no Balance Assets Account branch Account Branch Depositor Loan branch Customer Borrower Loan c_city C_street Lno Amt C_name ID
The following relational schema forms part of an Employees database. The primary keys are underlined and foreign keys are in italics. Job (jobID, jobTitle, minSalary, maxSalary) Dependent (dependentID, firstName, lastName, relationship, employeeID) Department (departmentID, departmentName, locationID) Location (locationID, street, postcode, city, state) Employee (employeeID, firstName, lastName, phoneNumber, salary, jobID, departmentID) Employee employeeID works as jobID at a department departmentID located at locationID. The employee has dependent(s) dependentID. Question 1 Begins Here 1. List employee names, department names, and their dependent names. Also, include employees without any dependents.
specify the type of cardinality in the figure below * Fname Minit Lname Bdate Address Salary Name San Sex Locations WORKS FOR Name Number EMPLOYEE Start date Number_of employees- DEPARTMENT MANAGES CONTROLS Hours WORKS ON PROJECT Supervisor Supervisee SUPERVISION Name Location DEPENDENTS OF Number DEPENDENT Name Sex Birth date Relationship