MACQUEEN ONLY

S.no

My answer

Right choice

Explanation

1

C

C

The ANSI-SPARC Model has 3 layers, the internal most layer contains the physical memory and store the data, the middle layers stores the information in the form of table and can only be modified by Data Administrator, the external layer is the view layer which allows user to select a part of database and view it. So the external level is the view layer.

2

E

E

Since indexes are unique to a single entry in the database table and are used for quick retrieval of row from the database, similarly primary key is unique for a row in the database. So indexes can be used as primary key constraint for the database.

3

B

B

Circle stands for zero and crow’s foot stands for many. One lies between zero and many so the cardinality zero, one or many can be described by the circle near the end of the line followed by a crow’s foot.

4

A,B,E

A,B,E

None to many is not valid since the relation exists between actual entities which cannot be none, one to many to one is not a valid entity since there cannot be an intermediate entity while describing the relationships between 2 entities

5

A,B,C,E

A,B,C

I thought we can use the database query as a business rule but I found out its wrong. Business rules are used to set boundaries of the data.

6

B,C,D

B,C,D

The primary need not be defined for all the database tables; it can be a combination of 1 or more columns and is unique for each row or the database. The primary key columns may or may not be present in the reference table, even the candidate key can be used as a reference constraint.

7

A,B,D,E

A,B,D

I thought that the integrity constraints are one to one relationships mostly but when I went back and check I found out they can be 1 to many also.

8

C,D

B,C

I didn’t know that we can define the referential constraint in the Relationships panels in MS Access. I went back and check and found that we can actually define it.

9

B,C,E

B,C,E

A relational table may/may not appear in the conceptual database design, though it is the primary storage unit of databases. It may/may not assign a data type and it can be a combination of multiple data types too. Every relational table has a unique name and duplicates are not allowed in databases.

10

A,B,D,E

A,B,D,E

The format may be changed while viewing using the SQL query so data type doesn’t restrict the data that may be stored in the view.