Consider the following relation R, where {A, B} is its PK. Assume that R is in...
Consider the following relation R, where {A, B} is its PK. Assume that R is in the first normal form (INF).
R (A, B, C, D, E, F)
Functional dependencies:
FD1: BàC
FD2: AàDE
FD3: ABàF
Why is this table not in 2NF? Specify which FDs make R violate 2NF.
Normalize the data shown in this table to second normal form (2NF). Specify the primary and foreign key (if any) in each table of your 3NF relations.
Normalize the data shown in this table to third normal form (3NF). Specify the primary and foreign key (if any) in each table of your 3NF relations.
Homework Answers
Add Answer to:
Consider the following relation R, where {A, B} is its PK.
Assume that R is in...
7. A relation schema is given as SalesRecord(sID, sName, cID, CID, PNo, pName, quantity). The functional...
7. A relation schema is given as SalesRecord(sID, sName, cID, CID, PNo, pName, quantity). The functional dependencies are fd1. SID, CID - pNo, pName, quantity fd2. SID - SName fd3. CID cName fd4. pName Normalize this to 3NF. Answers should be text-form schema. pNo
Consider relation R = (A,B,C,D,E) for the following: 2. Is R in 2NF with the following...
Consider relation R = (A,B,C,D,E) for the following:
2. Is R in 2NF with the following functional dependencies? If not, normalize it. [5 points] A→BC -AD → E в с 3. Are the relations from the answer of question 2 in 3NF? If not normalize it. 5 points]
Normalize EVERY relation to 3NF step by step Q1: Given the following table, identify the functional...
Normalize EVERY relation to 3NF step by step Q1: Given the following table, identify the functional dependencies VisitID InvoiceDate Invoice Amt Invoiceltem 1002 11/09/2016 $65.00 Updated shots 1002 11/09/2016 $45.00 Flea & tick medications 1006 11/14/2016 $35.00 Heartworm medication 1006 11/14/2016 $65.00 Updated shots 1006 11/14/2016 $75.00 Lab work 1009 11/16/2016 $50.00 Grooming 1009 11/16/2016 $15.00 Nail trim 1012 11/21/2016 $65.00 Updated shots 1012 11/21/2016 $75.00 Lab work 1013 11/21/2016 $65.00 Updated shots 1013 11/21/2016 $75.00 Lab work 1014 11/21/2016...
Language: SQL - Normalization and Functional Dependencies Part 4 Normalization and Functional Dependencies Consider the following relation R(A, B, C, D)and functional dependencies F that hold o...
Language: SQL - Normalization and Functional
Dependencies
Part 4 Normalization and Functional Dependencies Consider the following relation R(A, B, C, D)and functional dependencies F that hold over this relation. F=D → C, A B,A-C Question 4.1 (3 Points) Determine all candidate keys of R Question 4.2 (4 Points) Compute the attribute cover of X-(C, B) according to F Question 43 (5 Points) Compute the canonical cover of F.Show each step of the generation according to the algorithm shown in class....
a: Give an example of a deletion anomaly and one example for the insertion anomaly ..... b: Give the all partial depe...
a: Give an example of a deletion anomaly and one example
for the insertion anomaly
.....
b: Give the all partial dependencies and transitive
dependencies
>>>
c: Normalize this relation into 2NF. Please draw the
table(s) with data, and use underline to indicate the primary key
and squiggly line to indicate foreign keys if a table has for each
table
<<<<<
d: Normalize the 2NF into 3NF. Please draw the table(s)
with data, and use underline to indicate the primary...
Suppose we have the following relation (R) that keeps track of car sales: R(car date_sold, salesperson#,...
Suppose we have the following relation (R) that keeps track of car sales: R(car date_sold, salesperson#, comission_rate, discount) In addition to the functional dependency implied by the primary key (car#), assume the following functional dependencies: date_sold discount salesperson commission_rate Explain why this relation is not in Boyce-Codd Normal Form (BCNF). a. b. Show how you would normalize this relation to achieve Boyce-Codd Normal Form by drawing a new relational schema. Highlight all primary keys by underlining them and use arrows...
Consider the following schema and functional dependencies: SHIPPING (ShipName, ShipType, VoyageID, Cargo, Port, ArrivalDate) Key: ShipName,...
Consider the following schema and functional dependencies: SHIPPING (ShipName, ShipType, VoyageID, Cargo, Port, ArrivalDate) Key: ShipName, ArrivalDate FD1: ShipName > ShipType FD2: VoyageID > ShipName, Cargo FD3: ShipName, ArrivalDate > VoyageId, Port 1.Please list the final set of 3NF schema including all its keys. 2.Do any of the finalized 3NF schema have determinates that are not candidate keys? If yes, explain - which schema(s)? Why?
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies i...
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies in a table are '"very good", the table is in BCNF X is a candidate key Good Good dependency: X-> A where If all dependencies in a table are "very good" or "good", the table is in 3NF X is not a candidate key X is a part of a candidate key A is prime attribute Bad Bad dependency (Transitive Dependency): X A where If...
1. Consider a Relation that holds attributes of courses and sections at a university: R =...
1. Consider a Relation that holds attributes of courses and sections at a university: R = CourseNo, SecNo, OfferingDept, CreditHours, CourseLevel, InstructorSSN, Semester, Year, Days Hours, RoomNo, NoOfStudents Assume that the following functional dependencies hold: • CourseNo → Offering Dept, CreditHours, CourseLevel • CourseNo, SecNo, Semester, Year → Days Hours, RoomNo, NoOfStudents, InstructorSSN • RoomNo, Days Hours, Semester, Year → InstructorSSN, CourseNo, SecNo Normalize Relation R upto 3NF. 2. Consider the relation for published books: Book = Book title, AuthorName,...
Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date,...
Normalisation Consider the following relation schema about project meetings: PMG(projID, title, type, manager, jobID, start-date, end-date, contractor, contractNo) Some notes on the semantics of attributes are as follows: • Each project has a unique project ID (projID) and also has a title, type and manager. Each manager has a specialty project type. • A project often contracts jobs to contractors with start-date and end-date. Contracts are identified by contract numbers (contractNo), but contract details are out of the scope of...
7. A relation schema is given as SalesRecord(sID, sName, cID, CID, PNo, pName, quantity). The functional dependencies are fd1. SID, CID - pNo, pName, quantity fd2. SID - SName fd3. CID cName fd4. pName Normalize this to 3NF. Answers should be text-form schema. pNo
Consider relation R = (A,B,C,D,E) for the following:
2. Is R in 2NF with the following functional dependencies? If not, normalize it. [5 points] A→BC -AD → E в с 3. Are the relations from the answer of question 2 in 3NF? If not normalize it. 5 points]
Normalize EVERY relation to 3NF step by step Q1: Given the following table, identify the functional dependencies VisitID InvoiceDate Invoice Amt Invoiceltem 1002 11/09/2016 $65.00 Updated shots 1002 11/09/2016 $45.00 Flea & tick medications 1006 11/14/2016 $35.00 Heartworm medication 1006 11/14/2016 $65.00 Updated shots 1006 11/14/2016 $75.00 Lab work 1009 11/16/2016 $50.00 Grooming 1009 11/16/2016 $15.00 Nail trim 1012 11/21/2016 $65.00 Updated shots 1012 11/21/2016 $75.00 Lab work 1013 11/21/2016 $65.00 Updated shots 1013 11/21/2016 $75.00 Lab work 1014 11/21/2016...
Language: SQL - Normalization and Functional
Dependencies
Part 4 Normalization and Functional Dependencies Consider the following relation R(A, B, C, D)and functional dependencies F that hold over this relation. F=D → C, A B,A-C Question 4.1 (3 Points) Determine all candidate keys of R Question 4.2 (4 Points) Compute the attribute cover of X-(C, B) according to F Question 43 (5 Points) Compute the canonical cover of F.Show each step of the generation according to the algorithm shown in class....
a: Give an example of a deletion anomaly and one example
for the insertion anomaly
.....
b: Give the all partial dependencies and transitive
dependencies
>>>
c: Normalize this relation into 2NF. Please draw the
table(s) with data, and use underline to indicate the primary key
and squiggly line to indicate foreign keys if a table has for each
table
<<<<<
d: Normalize the 2NF into 3NF. Please draw the table(s)
with data, and use underline to indicate the primary...
Suppose we have the following relation (R) that keeps track of car sales: R(car date_sold, salesperson#, comission_rate, discount) In addition to the functional dependency implied by the primary key (car#), assume the following functional dependencies: date_sold discount salesperson commission_rate Explain why this relation is not in Boyce-Codd Normal Form (BCNF). a. b. Show how you would normalize this relation to achieve Boyce-Codd Normal Form by drawing a new relational schema. Highlight all primary keys by underlining them and use arrows...
Dependency Very Good dependency (key dependency) : XA where Table Very good If all dependencies in a table are '"very good", the table is in BCNF X is a candidate key Good Good dependency: X-> A where If all dependencies in a table are "very good" or "good", the table is in 3NF X is not a candidate key X is a part of a candidate key A is prime attribute Bad Bad dependency (Transitive Dependency): X A where If...
Most questions answered within 3 hours.
-
MATLAB HW 11 problem using Switch Case and Input commands
Write a script file that calculates...
asked 1 minute ago -
A college student is employed as a door-to-door newspaper
salesman. Historical data suggests that the student...
asked 16 minutes ago -
Considering gravitational time dilation, calculate the time that
passes in Earth’s surface while 1 hour passes...
asked 40 minutes ago -
Minitab Problem: Take the Lake Hume June rainfall data and find
use the processes outlined in...
asked 1 hour ago -
X Company is trying to decide whether to continue using old
equipment to make Product A...
asked 1 hour ago -
IN PYTHON ONLY !! Program 2: Re-work
program #5 (WeeklyHours) from the previous assignment such that...
asked 2 hours ago -
The average length of time between arrivals at a turnpike
toll-booth is 26 seconds. What is...
asked 3 hours ago -
(a) A piston at 6.1 atm contains a gas that occupies a volume of
3.5 L....
asked 5 hours ago -
Please answer true or false. Words
cannot be changed or added in to make it true...
asked 5 hours ago -
An empty test tube weighs 15.923 grams. Then,
MgCl2•6H2O is added into the test tube. After...
asked 5 hours ago -
Assume memory access is 10 units of time and disk access is
10000 units of time....
asked 5 hours ago -
1. Are all good samples random?
2. Magazines often report surveys giving statistics such as “63%...
asked 5 hours ago