#3 Ouestion 1 The object of first normal form in the normalization process is to

Question

#3

Ouestion 1

The object of first normal form in the normalization process is to:                          

Question 2

If a table has a single column primary key and its already in first normal form, what can we say about that table?                          

Question 3

1 out of 1 points

When defining functional dependence from column A to column B, so that A ? B, this means that                                  

Question 4

For a table to be in third normal form (3NG) it must be in second normal form and _____.                                   

Question 5

When starting the information level design for a database, we must represent each ____ as a collection of tables.                         

Question 6

When working with an entity (table), we can create a(n) _____ to be that entity's primary key and also make it visible to the users so that they can identity each unique record.                             

Question 7

Which of these is NOT one of the steps when building a User View?                                 

Question 8

If col1 is the PK of Table1 and col5 is the PK of Table2, the following alternative table structures is an example of a _____ relationship.

Table1(col1, col2, col3)                                                                                            Table1(col1, col2, col3, col5)          

Table2(col5, col6, col1)                                                 OR                                      Table2(col5, col6)                              

Question 9

If a given table structure has too many null values, we can ____                             

Question 10

In the Entity Relationship Model, an entity with a minimum cardinality of zero represents a ________                            

Explanation / Answer

Question1
No two rows of data must contain repeating group of information. That is each set of column must have a unique value, such that multiple columns cannot be used to fetch the same row. Each table should be organized into rows, and each row should have a primary key that distinguishes it as unique.

Question2
Table is in second normal form (2NF).

Question3
Attribute B is functionally dependent on attribute A when each value for A in the database is associated with exactly one value of B.

Question4
All the attributes in a table are determined only by the candidate keys of that relation and not by any non-prime attributes.

Question5
User view

Question10
Optional relationship

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.