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