Which of the following is not an element of the E-R Model?

Select one:

a. Use case

b. Entity

c. Cardinality

d. Relationship

Clear my choice

Question 2

Not yet answered

Marked out of 1.00

Flag question

Question text

Referential integrity constraints are concerned with checking INSERT and UPDATE operations that affect the parent child relationships.

Select one:

True

False

Question 3

Not yet answered

Marked out of 1.00

Flag question

Question text

Given a relation R with three attributes A, B, C with the following dependencies:

C A

C B

Assume that there is not any multivalued attribute, what is the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF)?

Select one:

a. 1NF

b. 2NF

c. 3NF

d. BCNF

Clear my choice

Question 4

Not yet answered

Marked out of 1.00

Flag question

Question text

The result of a SELECT statement can contain duplicate rows.

Select one:

True

False

Question 5

Not yet answered

Marked out of 1.00

Flag question

Question text

Which of the following is true about a relation?

Select one:

a. There is a single attribute in each relation

b. The order of the tuples of a relation is determined by the primary key

c. A relation is a one-dimensional table

d. All the values in any column must be of the same type

Clear my choice

Question 6

Not yet answered

Marked out of 1.00

Flag question

Question text

What is wrong about a surrogate key?

Select one:

a. A surrogate is an attribute or set of attributes that uniquely identifies a record in a relation

b. A surrogate key does not exist in the real world as a real attribute of an entity set

c. A surrogate key is usually a generated unique number

d. It is not a good practice to use a surrogate key

Clear my choice

Question 7

Not yet answered

Marked out of 1.00

Flag question

Question text

Database application development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system, and then implementing the operations in the system.

Select one:

True

False

Question 8

Not yet answered

Marked out of 1.00

Flag question

Question text

In an E-R diagram, it is possible that an entity can have a relationship to itself.

Select one:

True

False

Question 9

Not yet answered

Marked out of 1.00

Flag question

Question text

Considering all the other tables exist in the database, which of the following SQL statements that are used to create tables gives an error?

Select one:

a. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Unique (ID) );

b. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), CONSTRAINT pk Primary Key (ID) );

c. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Foreign Key (Name) );

d. Create Table Instructor( ID integer Not Null, Name varchar (40), SureName varchar (40), Primary Key (ID), Foreign Key (Name) References Departments );

Clear my choice

Question 10

Not yet answered

Marked out of 1.00

Flag question

Question text

tblProducts Table

ProductID	SupplierID	CategoryID	ProductName
1	1	1	Chai
2	1	1	Chang
3	1	2	Aniseed Syrup
4	2	2	Chef Anto's Cajun

Using the tblProducts Table shown above, which of the columns could be a Primary Key of another table?

Select one:

a. SupplierID

b. CategoryID

c. ProductName

d. All of the above