Access Millions of academic & study documents

Consider the relational schema Product p(name), price, manufacturer

Content type
User Generated
Showing Page:
1/3
Consider the relational schema: Product p(name), price,
manufacturer) Person (ssn, name, age) Company
(ename, stock price, president) Write the functional
dependencies found in the above relational schema.
Assume that the above 3 relations are merited in 1 relation
PPC(pname, price, manufacturer, ssn, name, age, ename,
stock price, president) Select a key and write the
functional dependencies found in the above relation.
Solution
an FD is a relationship between an attribute \"Y\" and a
determinant (1 or more other attributes) \"X\" such that for
a given value of a determinant the value of the attribute is
uniquely defined.
considering the first set of schema:
Let R be
Product(pname, price, manufacturer)
FD\'s in R include:
{pname}->{price}
{pname}->{manufacturer}
{pname)->{price,manufacturer}
{manufacturer}->{price}
{manufacturer}->{pname}
Let R be

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3
Person(ssn, name,age)
FD\'s in R include:
{ssn}->{name}
{ssn}->{age}
{ssn}->{name,age}
{name}->{ssn}
Let R be
Company(cname,stock price, president)
FD\'s in R include:
{cname}->{stock price}
{cname}->{president}
{cname}->{stock price, president}
{president}->{cname}
Let R be
PPC(pname, price, manufacturer, ssn,
name,age,cname,stock price,president)
Considering ssn as the primary key:
FD\'s in R include:
{ssn}->{cname,pname,name,age}
{pname}->{cname,stock price, president, pname, price
manufacturer}
{cname}->{stock price, president}
{pname}->{price, manufacturer}

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
Consider the relational schema: Product p(name), price, manufacturer) Person (ssn, name, age) Company (ename, stock price, president) Write the functional dependencies found in the above relational schema. Assume that the above 3 relations are merite d in 1 relation PPC(pname, price, manufacturer, ssn, name, age, ename, stock price, president) Select a key and write the functional dependencies found in the above relation. Solution an FD is a relationship between an attribute \"Y\" and a determinant (1 or more other attributes) \"X\" such that for a given value of a determinant the value of the attribute is uniquely defined. considering the first set of schema: Let R be Product(pname, price, manufacturer) FD\'s in R include: {pname}->{price} {pname}->{manufacturer} {pname)->{price,manufacturer} {manufacturer}->{price} {manufacturer}->{pname} Let R be Person(ssn, name,age) FD\'s in R i ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4