Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Simple SQL question about tables.?

(I'm doing an online course and don't have an instructor present) My textbook asks me to determine functional dependencies and convert into 3NF. However, I don't recognize what I'm looking at. Is this a table view? Is it a statement that supposedly creates a table? I don't understand the second set of quotes.

Part (PartNum, Description, OnHand, Class, Warehouse, Price, (OrderNum, OrderDate, CustomerNum, CustomerName, RepNum, LastName, FirstName, NumOrdered, QuotedPrice) )

I appreciate your help!

Jay

2 Answers

Relevance
  • 9 years ago
    Favorite Answer

    I believe Part is a table, the first set of attributes in parentheses are attributes of Part. The second set is an unnamed foreign key to another set of values in another unnamed table.

  • 6 years ago

    challenging matter. research onto bing and yahoo. this can assist!

Still have questions? Get your answers by asking now.