3. a) A relation that does not have a composite primary key still has partial functional dependency. A) TRUE B) FALSE If you choose “False”, please explain below why it is “False. 3. b) For a table to be in 2NF, both of the following must be true: 1) this table that must be in 1NF and 2) this table must have no partial functional dependencies. TRUE FALSE If you choose “False”, please explain below why it is “False.” 3. c) A relation that is in 1NF must be in 3NF if the primary key consists of only one attribute. TRUE FALSE If you choose “False”, please explain below why it is “False.”

3. a) A relation that does not have a composite primary key still has partial functional dependency. A) TRUE B) FALSE If you choose “False”, please explain below why it is “False. 3. b) For a table to be in 2NF, both of the following must be true: 1) this table that must be in 1NF and 2) this table must have no partial functional dependencies. TRUE FALSE If you choose “False”, please explain below why it is “False.” 3. c) A relation that is in 1NF must be in 3NF if the primary key consists of only one attribute. TRUE FALSE If you choose “False”, please explain below why it is “False.”

CMPTR

3rd Edition

ISBN:9781337681872

Author:PINARD

Publisher:PINARD

Chapter17: Creating A Database

Section: Chapter Questions

Problem 4QY

See similar textbooks

Similar questions

What three situations make it necessary to make a substitute key instead of the main key of a relation?
20. A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation. a. Referential b. Referencing c. Specific d. Primary
13. Which one of the following uniquely identifies the elements in the relation? a. Secondary Key b. Primary key c. Composite key d. Foreign key
Primary key identifies a unique tuple of a relation, true or false?
Which of the following functional dependencies are satisfied (and not satisfied) by this relation and Why? (a) A → B Why? (b) A → CD Why? (c) AB → CD Why?
1. What is a set? A relation? A function? 2. Explain the difference between a partial and a total function. 3. Explain the difference between a relation and a function.
19. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation . a. Referential relation b. Referencing relation c. Referenced relation d. Referred relation
Which of the following functional dependencies are satisfied (and not satisfied) by this relation and Why? (g) AD → BC WHY? (h) D → B WHY? (i) D → C Why? (j) C → D Why?
100. When the foreign key refers to a tuple which does not exists in subjected relation then the constraint violated is a. modify integrity b. referential integrity c. inferential integrity d. insert integrity
14. A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique. a. Rows b. Key c. Attribute d. Fields
Based on the following table a)Write a 1NF relational schema and identify the partial and transitive dependencies. b)Write the relational schema for 2NF and 3NF.
5.6 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the following diagram: The diagram uses Sakila naming conventions. Follow the Sakila conventions for your table and column names: All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Write CREATE TABLE and ALTER TABLE statements that: Implement the entity as a new phone table. Implement the has relationships as foreign keys in the Sakila customer, staff, and store tables. Remove the existing phone column from the Sakila address table. Step 2 requires adding a foreign key constraint to an existing table. Ex: ALTER TABLE customer ADD FOREIGN KEY (phone_id) REFERENCES phone(phone_id) ON DELETE SET NULL ON UPDATE CASCADE; Specify data types as follows: phone_id, phone_number, and country_code have data type INT. phone_type has date type VARCHAR(12) and…