Register

│Course Title: Database Systems

242 views
0 votes
0 votes
Consider the following set of functional dependency for the relation schema:
Company =(staffNo, branchNo, branchAddress, name, position, hoursPerWeek).
• branchNo -> branchAddress
• staffNo -> name, position
• staffNo, branchNo -> hoursPerWeek
Also {staffNo, branchNo} is the candidate of this relation Company.
i. Why this table not in 2NF?
ii. Explain and illustrate the process of normalizing the data shown in this table to
third normal form (3NF).
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
1
sahabaz1111 asked Dec 2, 2021
218 views
│Course Title: Database Systems
Consider the functional dependency of relation R (A, B, C, D, E) F = {B→CD, D→E, B→A, E→C, AD→E} i. Compute some members of F+ ii. Find B+ iii. Compute the canonical cover of
Consider the functional dependency of relation R (A, B, C, D, E)F = {B→CD, D→E, B→A, E→C, AD→E}i. Compute some members of F+ii. Find B+iii. Compute the canonica...
User Avatar
0 votes
0 votes
1 answer
2
Hardik Vagadia asked Nov 17, 2015
302 views
Find the title of all the books which is not yet issued?
Book_schema(Acc.no,yr_pub,title) B.by_schema(Acc.no,Doi,Card.no) Where, Acc.no is accession number yr_pub is the year of publication B.by_schema is the borrowed by schema and Doi is the date of issue.
Book_schema(Acc.no,yr_pub,title)B.by_schema(Acc.no,Doi,Card.no)Where, Acc.no is accession numberyr_pub is the year of publicationB.by_schema is the borrowed by schemaand ...
User Avatar
Link Copied!