In what normal form is the LOTS relation schema in the Figure with respect to the restrictive interpretations of normal form that take only the primary key into account? Candidate Key (a) LOTS Property_id# Lot# Area Price Tax_rate A FD1 T A A FD2 FD3 FD4 2NF Both 2NF and 3NF 3NF 4NF County_name

For the table BOOKAUTHOR below you are given the following functional dependencies. BOOKAUTHOR (ISBN, BookTitle, Author_Num, LastName, Publisher, Royalty, Edition) Functional dependencies: 1. ISBN BookTitle, Publisher, Edition 2. Author Num → LastName 3. BookTitle → Publisher 4. {ISBN, Author_Num} → BookTitle, LastName, Publisher, Royalty, Edition Write the types of functional dependencies shown in (1) to (4) above. Also, decompose the table to the third normal from (3NF).

which rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal form

(Choose all of the correct superkeys.) Find all superkeys of the DEPARTMENT relation. Its primary key (PK) is underlined.                DEPARTMENT (number, dname, mgrssn, location)                PK = {dname, location} {number} {number, dname} {number, dname, mgrssn} {number, dname, mgrssn, location} {dname} {dname, mgrssn} {dname, mgrssn, location} {mgrssn} {mgrssn, location} {location} {number, dname, mgrssn} {number, dname, location} {number, mgrssn} {number, mgrssn, location} {number, location} {dname, location}

What are three cases when a surrogate key might be used in place of a relation's main key?

Here are three examples of when it makes sense to create a surrogate key in place of the primary key in a relation.

7

A relation FarmVisit is defined below with attributes in the table headings. FarmVisit visitorID visitorName date farmID farmName t1 H001 John 1 Feb 2021 A10 Green Field t2 Н005 Ashley 1 Jan 2021 A10 Green Field t3 но05 Ashley 1 Feb 2021 A10 Green Field t4 H005 Ashley 15 Apr 2021 H02 Есо t5 Но06 Ashley 15 Apr 2021 A11 Green Field a) Write down examples of tuples (i.e., tl, t2) to show neither of the following is a functional dependency: (i) visitorID -> date (ii) date -> farmID b) Write down the functional dependency (FDs) using the above data, which can represent all possible data. The FDs should be non-trivial and the determinants of the FDs should contain minimal number of attributes required. c) Using the tuples given, can (visitorID, farmID) be the primary key of FarmVisit? Explain why. d) What the highest normal form by which the FarmVisit relation can be classified? Explain why.

1)A tuple is a named column of a relation. True or alse2)Each attribute in a relation has a distinct name. T/F3)The degree of a relation is the number of attributes it contains. T/F4)A foreign key is the candidate key that is selected to identify tuples. T/F

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