ICT 285 Databases
Question 1
Correct Mark 1.00 out of 1.00
The first step in transforming an E-R model into a relational database design is to ________.
Select one:
a. create a table for each relationship
b. evalu
...
ICT 285 Databases
Question 1
Correct Mark 1.00 out of 1.00
The first step in transforming an E-R model into a relational database design is to ________.
Select one:
a. create a table for each relationship
b. evaluate the entities against the normalization criteria
c. create a table for each entity
d. remove any recursive relationships
e. document referential integrity constraints
The correct answer is: create a table for each entity
Question 2
Correct Mark 1.00 out of 1.00
Each attribute of an entity becomes a(n ) ________ of a table.
Select one:
a. column
b. primary key
c. foreign key
d. alternate key
e. primary key or alternate key
The correct answer is: column
Question 3
Correct Mark 1.00 out of 1.00
The ideal primary key is ________.
Select one:
a. short
b. numeric
c. fixed
d. A and B
e. A, B and C
The correct answer is: A, B and C
Question 4
Correct Mark 1.00 out of 1.00
To represent a one-to-many relationship in a relational database design ________.
Select one:
a. the key of the child is placed as a foreign key into the parent
b. the key of the parent is placed as a foreign key into the child
c. an intersection table must be created
d. the key of the table on the "many" side is placed in the table on the "one" side
e. the keys of both tables are joined into a composite key
The correct answer is: the key of the parent is placed as a foreign key into the child
Question 5
Correct Mark 1.00 out of 1.00
Many-to-many relationships are represented by ________.
Select one:
a. two tables with an M:N relationship
b. two tables with a 1:N relationship
c. an intersection table which has M:N relationships with each of the two tables
d. an intersection table which has 1:N relationships with each of the two tables
e. two intersection tables which each have 1:N relationships with the two tables
The correct answer is: an intersection table which has 1:N relationships with each of the two tables
Question 6
Correct Mark 1.00 out of 1.00
To which of the following actions on tables are referential integrity constraints NOT applied?
Select one:
a. CREATE
b. INSERT
c. UPDATE
d. DELETE
e. referential integrity constraints are applied to all of the listed actions
The correct answer is: CREATE