(TCO 3) All of the following apply to the relationships image found below EXCEPT
ID: 2524459 • Letter: #
Question
(TCO 3) All of the following apply to the relationships image found below EXCEPT a Relationships Suppliers SupplietD Products CompanyName ContactName Contadtitie Address City Region PostalCode Country Phone Fax HomePage ProductD ProductName SupplieriD CategoryD QuantityPerUnit UnitPrice UnitsinStock UnitsOnOrder Recrdertevel Discontinued Categories Categoryo CategoryName Description Picture Image Description: Three Tables are pcitured: Table 1: Suppliers with a primary key of SupplierlD and fields: CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, and HomePage. Table 2: Products with a primary key of ProductiD and fields: ProductName, SupplierlD, CategorylD, QuantityPerUnit, UnitPrice, UnitsinStock, UnitsOnOrder, ReorderLevel, and Discontinued. Table 3: Categories had a Primary key of CategoryID and fields: Categoryname, Description and Picture. There is a relationship labeled 1 attached to Table 1 or Suppliers and an infinity symbol attached to Table 2 or Products. O a one-to-many relationship is found between the Suppliers table and the Products table. O a direct relationship exists between the primary keys of the Suppliers table and the primary key of the Products table. O one table is not joined to the two other tables. O the primary key for the Categories table is CategorylD.Explanation / Answer
The answer is (b)
Because there is no direct relationship between the primary key of the Suppliers table and the primary key of the Products table as they both are totally different. If there would have been a direct relationship then both the primary keys would be exact same.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.