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

Q7: An ERD about a company has been mapped to the following Relations. Please choose the correct statement that describes the company Employee(ID,E.Name, Salary) Project(Name, Location, ID) Project Location(Name, Location) a. A company has several projects and employees. An employee can work on one or more projects. A project can be located at several locations b. A company has several projects and employees. An employee can work on a single project only and each project has several employees. A project can be located at several locations c. A company has several projects and employees. An employee can work on one or more projects. A project is located at a single location d. A company has several projects and employees. An employee can work on one project only. A project can be located at several locations Employee EID 001 002 003 004 005 006 Name Ahmad Ali Sameh Salem Huda Ali Department group by Name order by EID; a. TWO columns and FOUR records b. TWO columns and ONE record c. TWO…
Convert the following table to third normal form (3NF). In this table, StudentNum determines StudentName, NumCredits, AdvisorNum, and AdvisorName. Advisor Num determines AdvisorName. CourseNum determines Description. The combination of StudentNum and CourseNum determines Grade. STUDENT (StudentNum, StudentName, NumCredits, AdvisorNum, AdvisorName, CourseNum, Description, Grade). Identify the primary key for the original table and the primary keys for the resulting tables. Indicate the foreign keys with italic font. Give meaning names to the resulting tables.
StayWell also rents out properties on a weekly basis to students attending summer school in the Seattle area. Design a database to meet the following requirements, using the shorthand representation and a diagram of your choice. For each student renter, list his or her number, first name, middle initial, last name, address, city, state, postal code, telephone number, and e-mail address. For each property, list the office number, property address, city, state, postal code, square footage, number of bedrooms, number of floors, maximum number of persons that can sleep in the unit, and the base weekly rate. For each rental agreement, list the renter number, first name, middle initial, last name, address, city, state, postal code, telephone number, start date of the rental, end date of the rental, and the weekly rental amount. The rental period is one or more weeks.
Using the invoice table stucture do the following:a.Write the relational schema ,draw its dependency diagram,and identy all dependencies,including all partial and transitive dependencies.You can assume that the table does not contain repeating groups and that an invoice number references more than one product.b.Remove all partial dependencies,write the relational schema,and draw the new dependency diagrams.Identify the normal forms for each table structure you created.c.Remove all transitive dependencies,write the relational schema,and draw the new dependency diagrams.Also identify the normal forms for each table structure you created.d.Draw the Crow's Foot ERD.
Review the SaleItem relation below where ItemNumber plus OrderNumber is the primary key. What type of primary key does this relation have? SALEITEM (ItemNumber, OrderNumber, Quantity, Price) Group of answer choices Composite primary key Surrogate primary key Transitive primary key Alternate primary key
PLz help with the following: Translate your ER diagram into a relational schema in the form of SQL DDLs. Choose appropriate data types for each attribute and include primary key and foreign key constraints, Check and Not Null constraints.
Assume that you are hired to design a relational database to "manage" the thesis and the projects done in an academic department. Write a maximum 5 pages executive summary which will serve as the requirements analyses document. Your exec summary should provide the following information. No SQL implementation is required at this stage. Stake holders (not just the bare end users) End users Expected functionalities (i.e., sample queries in English, not in SQL) Relation/Tables with the attributes Primary key(s) for each table.
Give table WORKS_ON (ESSN, PROJECT_NO, HOURS ), Query: SELECT DISTINCT ESSN FROM WORKS_ON WHERE PROJECT_NO IN (1, 2, 3) will: a. Retrieve the SSN of employees who work in project 1, 2, 3 b. Retrieve the SSN of employees having works_on attribute = 1, 2, 3 c. Retrieve the SSN of employees having SSN attribute = 1, 2, 3 d. None of the options
ERD for Sales Order Step 1. Draw an ER diagram for the story below. Use the ERD tool only. Draw Relations in Oracle notation. Please read the story carefully. Use the mentioned Entities ONLY. The company sells various Products to Customers. The Sales Agent books an Order. A new order is created for each Product. While booking an Order, Agent records Order Date, Product, Customer, Product Quantity, and Sales Agent. Product has Description and UnitPrice. Each Agent reports to a Manager. A Manger has a Nameand Commission Percent. NOTE: Total Amount is a calculation, doesn't belong to Order Step 2. Add Attributes to Sales Order ERD based on Rules of Normalization.