Assignment - consider the following relation definition and, Ask an Expert

Programming

Assignment - Consider the following relation definition and sample data (PROJECT)

ProjectID	EmployeeName	EmployeeSalary
100A	Jones	64k
100A	Smith	51k
100B	Smith	51k
200A	Jones	64k
200B	Jones	64k
200C	Parks	51k
200C	Smith	51k
200D	Parks	51k

Where ProjectID is the name of a work project; EmployeeName is the name of an employee who works on that project; EmployeeSalary is the salary of the employee whose name is EmployeeName.

Please answer:

A: ProjectID → EmployeeName. T or F

B: ProjectID → EmployeeSalary T or F

C: (ProjectID, EmployeeName) → EmployeeSalary T or F

D: EmployeeName → EmployeeSalary T or F

E: EmployeeSalary → ProjectID T or F

F: EmployeeSalary → (ProjectID, EmployeeName) T or F

G: What is the primary key of PROJECT?

H. Does this table contain partial dependency and/or transitive dependency?

I. Describe two modification anomalies from which PROJECT suffers.

J. In what normal form is PROJECT?

K: Redesign this relation to eliminate the modification anomalies. Please give the table (structures) with data.

Attachment:- Assignment File.rar

View complete question

DBMS, Programming

Category:- DBMS
Reference No.:- M92725730
Price:- $30

Guranteed 24 Hours Delivery, In Price:- $30

Have any Question?Write your Review or question?

Related Questions in DBMS

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

Question 1 unified communications system eg email

Question: 1. Unified Communications System (e.g., email, conferencing, and messaging) - The local area network is slower than needed, especially for newer, cloud-based applications. The email system needs refurbishment a ...

Question create the physical data model for the logical

Question: Create the physical data model for the logical data model that you submitted in IP3. This should include all of the data definition language SQL. Your submission should include all DDL needed to: Create the tab ...

In sql developer onlydeliverables include sql scripts and

In SQL Developer ONLY! Deliverables Include SQL scripts and screenshot of the results: D1. Create the following three user-defined roles that are shown in the table below and assign them the specified permissions for the ...

Sqlwrite a select statement that returns three columns from

SQL Write a SELECT statement that returns three columns from the Vendors table: VendorContactFName, VendorContactLName, and VendorName. Sort the result set by last name, then by first name.

A taking an unnormalised list describe how you would

(a) Taking an unnormalised list, describe how you would normalise it using the normal forms technique and show how the result of this method is used. (b) You are currently in the process of developing a RDBMS for a natio ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

Question sql injection is in the top 10 owasp and common

Question : SQL Injection is in the top 10 OWASP and Common Weakness Enumeration. Using MySQL and PHP, show your own very short and simple application that is vulnerable to this attack. Provide another version that mitiga ...

Instructionsfor decades relational databases remained

Instructions For decades, relational databases remained essentially unchanged; data was segmented into specific chunks for columns, slots, and repositories, also called structured data. However, in this Internet of Thing ...

You are in a real estate business renting apartments to

You are in a real estate business renting apartments to customers. Your job is to define an appropriate schema using SQL DDL in MySQL. The relations are Property(Id, Address, NumberOfUnits), Unit(ApartmentNumber, Propert ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask DBMS Expert