QUESTION 37 A data model consists of a. schema b. set of operations c. set of co

Question

QUESTION 37

A data model consists of

a.   schema

b.   set of operations

c.   set of constraints

d.   All of a., b., and c.

QUESTION 38

The reason why a database table is in the first normal form (1NF), but not in the second form (2NF) is because:

a.   There is a non-prime attribute that is partially dependent on the key of the table.

b.   There is a nested table or a complex object structure embedded in the table.

c.   There is an many-to-many relationship embedded in the table.

d.   All of a., b., and c.

QUESTION 39

If there are only two attributes in a database table, then

a.   the database table is in the first normal form,

b.   The database table is in the second normal form,

c.   the database table is in the third normal form,

d.   the database table is in the Boyce-Codd normal form,

e.   all of a., b., c. and d.

Explanation / Answer

Answer:

37)Correct Answer is Option d i.e All of a., b., and c.(schema,set of operations, and set of constraints).

Explanation :

The data model in the database generally consists of the layout of the database which consists of attributes also includes the set of functions which are performed between the tables such as joins,transactions etc. followed by the constraints in the tables so as to limit the usage of the database.

38)Correct Answer is Option a i.e There is a non-prime attribute that is partially dependent on the key of the table.

Explanation :

The reason why a database table is in the first normal form but not in the second form because the first normal form deals with the primary key of the attribute such that in a table there must be definitely a primary which must be unique to identify the table also there can exist a key which can identify the table but cannot be a primary key but as a dependable to the primary key taken for the table.

39)Correct Answer is Option d i.e The database table is in the Boyce-Codd normal form.

Explanation :

If there are only two attributes in a database table, then we can say that the datbase table is in Boyce-Codd normal form since it comes under all the normal forms which remains along with the two attributes where the table can be identified by using the functional dependencies.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

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