Question

If a relation schema is in 3nf, it is in BCNF. True/False Foreign key values can...

If a relation schema is in 3nf, it is in BCNF.

True/False

Foreign key values can be null.

True/False

In a table there is exactly one candidate key, but there can be multiple super keys.

True/False

Any candidate key is a super key

True/False

The primary key of a relation may have more than one attribute. However, a foreign key of    a relation must have only one attribute.

True/False

Given relation R1, where R1 contains N1 tuples and a is an attribute of R1, the minimum    possible size in tuples of σa=5(R1)

True/False

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1 
If a relation schema is in 3nf, it is in BCNF.
False

Foreign key values can be null.
False

In a table there is exactly one candidate key, but there can be multiple super keys.
True

Any candidate key is a super key
True

The primary key of a relation may have more than one attribute. However, a foreign key of    a relation must have only one attribute.
False

Given relation R1, where R1 contains N1 tuples and a is an attribute of R1, the minimum    possible size in tuples of σa=5(R1)
False
0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Database 1. Let A4, A5, and A6 be attributes in a relation R. If both of...
Database 1. Let A4, A5, and A6 be attributes in a relation R. If both of these functional dependencies hold: A4 → A5 and A5 → A6, then A4 → A6holds, because of the _________ rule. 2. The fact that the value of a foreign key attribute must exist in another set of one or more key attributes in another table, is called a(n) __________. 3. Any set of attributes that allows us to identify unique rows (tuples) in a...
1. When transforming an entity to a relation, the identifier of the entity type becomes the...
1. When transforming an entity to a relation, the identifier of the entity type becomes the primary key of the corresponding relation. True or False? 2. To transform a one-to-many relationship into relations, we add the primary key attribute (or attributes) of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship. True or False?
SQL allows a foreign-key dependency to refer to the same relation, as in the following example:...
SQL allows a foreign-key dependency to refer to the same relation, as in the following example: create table manager ( employee_ID char(20), Manager_ID char(20), primary key employee_ID, foreign key (manager_ID) references manager(employee_ID) on update cascade ) Here, employee_ID is a key to the table manager, meaning that each employee has at most one manager. The foreign-key clause requires that every manager also be an employee. Explain exactly what happens when a tuple in the relation manager is updated. Specify all...
Suppose we have the following relation R with composite primary key {A,B} together with the set...
Suppose we have the following relation R with composite primary key {A,B} together with the set FD of functional dependencies: R(A,B,C,D,E,F,G). FD = { C -> G, E -> B, A -> D, AB -> C, AB -> D, AB -> E. AB -> F, AB -> G } Draw the initial dependency diagram using the above information. The relation from part a) is in first normal form. Using the techniques described in the lecture, convert it to 2NF by...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN,...
1.Consider the following (normalized) relational model (primary keys are underlined, foreign keys are in italics). EMPLOYEE(SSN, ENAME, EADDRESS, SEX, DATE_OF_BIRTH, SUPERVISOR, DNR) S U P E R V I S O R : foreign key refers to SSN in EMPLOYEE, NULL value allowed D N R : foreign key refers to DNR in DEPARTMENT, NULL value not allowed DEPARTMENT(DNR, DNAME, DLOCATION, MGNR) MGNR: foreign key refers to SSN in EMPLOYEE, NULL value not allowed PROJECT(PNR, PNAME, PDURATION, DNR) DNR: foreign...
True False Select the most correct answer. Question 1 (1 point) Most databases are just in...
True False Select the most correct answer. Question 1 (1 point) Most databases are just in 1NF. Question 1 options: True False Question 2 (1 point) A subquery is always preferred over a join. Question 2 options: True False Question 3 (1 point) A database may consist only of multiple files. Question 3 options: True False Question 4 (1 point) A database may exist without a database management system. Question 4 options: True False Question 5 (1 point) The insert...
One gene can have multiple effects on an organism. Select one: a. True b. False
One gene can have multiple effects on an organism. Select one: a. True b. False
Instructions: Step 1: Create UNF Relation from a User View. The goal here is to create...
Instructions: Step 1: Create UNF Relation from a User View. The goal here is to create a single relation for the data found in the user view. The method used is: •   Examine the user view •   Identify all attributes •   Describe the user view using DBDL Here is an example of a user view. This reports lists the customers of the Premiere Corporation. Premiere Corporation Customer List CustNo   Name   Street   City   State   ZipCode   SalesRepNo 124    Sally Adams   482...
True or False 1. A single amino acid can have multiple codons. 2.Louis Pasteur was the...
True or False 1. A single amino acid can have multiple codons. 2.Louis Pasteur was the first person to make wines and beers. 3.If you were provided a mask with a pore size of 0.2 micrometer, it provide protection from the Covid-19 virus(size= 80nm). 4.Virues lack a cell wall. 5.The start codon(AUG: methionine) of most proteins is an example of a sense codon. 6. DNA is converted to protein during translation. 7.A stain that sticks to the background of a...
This laboratory assignment involves implementing a data structure called a map. A map associates objects called...
This laboratory assignment involves implementing a data structure called a map. A map associates objects called keys with other objects called values. It is implemented as a Java class that uses arrays internally. 1. Theory. A map is a set of key-value pairs. Each key is said to be associated with its corresponding value, so there is at most one pair in the set with a given key. You can perform the following operations on maps. You can test if...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT