2- Consider the following relation and given functional dependencies: STORE ITEM (SKU, PromotionID, Vendor, Style, Price) FD1: SKU, PromotionID à Vendor, Style, Price FD2: SKU à Vendor, Style (a) Identify the candidate keys and state its current normal form. (b) Normalize STORE_ITEM relation to the NEXT higher normal form. Explain clearly.

2- Consider the following relation and given functional dependencies: STORE ITEM (SKU, PromotionID, Vendor, Style, Price) FD1: SKU, PromotionID à Vendor, Style, Price FD2: SKU à Vendor, Style (a) Identify the candidate keys and state its current normal form. (b) Normalize STORE_ITEM relation to the NEXT higher normal form. Explain clearly.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What are three reasons for replacing the primary key of a relation with a surrogate key?
Consider the follow relations’ schemas to answer the following questions: Student (sid, name, level, address) Book(bid, title, author) BorrowedBook(sid, bid, date) 1) Assume that, there are 10,000 Student records stored on 1,000 pages/blocks, 50,000 Book records stored on 5,000 pages, 300,000 BorrowedBook records stored on 15,000 pages, and there are 500 different authors. Find out what is the record size for each of the previous relation?, and what is the blocking factor for each relation?
Describe three circumstances in which a substitute key for a relation's primary key should be established.
Explain three scenarios in which a surrogate key for a relation's primary key should be generated.
Consider the following relation named Trip. Trip The functional dependencies are as follows: (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type, SeasonNum, Season TripID, SeasonNum → TripID → A. SeasonNum →→ Season C. [TripName, StartLocation, State, Distance, MaxGrpSize, Type The tables that are in third normal form are: [TripName, StartLocation, State, Distance, MaxGrpSize, Type, Season Trip TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (Season Num, Season), TripSeason (TripID, SeasonNum) B. Trip (TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (SeasonNum, Season) Trip TripID, TripName, StartLocation, State, Distance, MaxGrpSize, Type) Season (TripID, SeasonNum, Season) D. None of the above
Explanation of three situations in which it is suitable to construct a substitute key for a relation's primary key
Describe three circumstances in which a substitute key for a relation's primary key should be established.
Explain the process of decomposing a relation to achieve higher normal forms and the potential trade-offs involved.
Develop a hybrid merge-join technique for scenarios when both relations are not physically sorted but have a sorted secondary index on the attributes to combine.
Informally describe the conditions to be met for a relation to be in Second Normal Form. In terms of functional dependency, describe why the following CUSTOMER_PURCHASE relation is not in second normal form. This table describes every instance of an individual Customer purchasing a Product. How would this relation suffer from Update Anomalies? CUSTOMER_PURCHASE (CUSTOMER_ID, PRODUCT_ID, PURCHASE_DATE, PURCHASE_AMT, PRODUCT_DESCRIPTION, CUSTOMER_NAME) Note the relation’s primary key is underlined
xexplanation of three situations when a surrogate key should be produced for the primary key of a relation?
Explain three situations under which a surrogate key for the main key of a relation should be established.