Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer these True/False questions based on ProductSpec table 1. Price functionally depends on Size because Size determines Price. 2. it is true thatPrice can determine

image text in transcribed

Answer these True/False questions based on ProductSpec table

1. Price functionally depends on Size because Size determines Price.

2. it is true thatPrice can determine Size.

3. Color --> Size.

4. Size does not determine Color.

5. Size depends on (Color, Price).

6. neither Color nor Price could be a determinant but Size could.

7. If Size is the primary key, the ProductSpec table is nota 3NF.

8. If (Color, Price) is the primary key of the ProductSpec table is 2NF

9. if size L is changed to size M, i.e., both last two rows have same size M, then Size and Price depend on each other.

10. if size L is changed to size M, i.e., both last two rows have same size M, then the primary key must be a compound key

11. if size L is changed to size M, i.e., both last two rows have same size M, then (Size, Price) can be the primary key

ProductSpec Size Color Price S black 55.9 M red 70 L black 70

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Relational Database Design For Business With Microsoft Access

Authors: Jonathan Eckstein, Bonnie R. Schultz

1st Edition

1119329418, 978-1119329411

More Books

Students also viewed these Databases questions

Question

Explain the forces that influence how people handle conflict

Answered: 1 week ago