Database Design(Normal Forms) (original) (raw)

Which of the following is TRUE?

• Every relation in 3NF is also in BCNF
• A relation R is in 3NF if every non-prime attribute of R is fully functionally dependent on every key of R
• Every relation in BCNF is also in 3NF
• No relation can be in both BCNF and 3NF

For the relation R(ABCDEFGH) with FD's= {CH->G, A->BC, B->CHF, E->A, F->EG such that F+ is exactly the set of FDs that hold for R.} Consider the FDs given in above question. The relation R is

Consider a relational table with a single record for each registered student with the following attributes.

1. _RegistrationNum: Unique registration number
   of each registered student
2. _UID: Unique identity number, unique at the
   national level for each citizen
3. _BankAccountNum: Unique account number at
   the bank. A student can have multiple accounts
   or join accounts. This attribute stores the
   primary account number.
4. _Name: Name of the student
5. _HostelRoom: Room number of the hostel

Which one of the following option is **INCORRECT?

• BankAccount_Num is candidate key
• Registration_Num can be a primary key
• UID is candidate key if all students are from the same country
• If S is a superkey such that S∩UID is NULL then S∪UID is also a superkey

Consider the following relational schema:

**Suppliers( sid:integer , sname:string, city:string, street:string)
**Parts( pid:integer , pname:string, color:string)
**Catalog( sid:integer, pid:integer , cost:real)

Assume that, in the suppliers relation above, each supplier and each street within a city has a unique name, and (sname, city) forms a candidate key. No other functional dependencies are implied other than those implied by primary and candidate keys. Which one of the following is TRUE about the above schema?

• The schema is in 3NF but not in BCNF
• The schema is in 2NF but not in 3NF

In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.

Data which improves the performance and accessibility of the database are called:

Consider the following table : Faculty (facName, dept, office, rank, dateHired)

(Assume that no faculty member within a single department has same name. Each faculty member has only one office identified in

_office

). 3NF refers to third normal form and BCNF refers to Boyee-Codd Normal Form Then Faculty is

match the following database terms to their function:

Consider a “CUSTOMERS” database table having a column “CITY” filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have “GAR” somewhere in its name, is:

• Select * from customers where city = ‘%GAR%’;
• Select * from customers where city = ‘$GAR$’;
• Select * from customers where city like ‘%GAR%’;
• Select * from customers where city as ‘%GAR’;

Consider the following dependencies and the BOOK table in a relational database design. Determine the normal form of the given relation.

ISBN → Title
ISBN → Publisher
Publisher → Address

There are 88 questions to complete.

Take a part in the ongoing discussion