data mangment ch 4 quiz

A primary key column and its related foreign key must ............................................

• be the same table

• have the same domain of values

• have the same column name

• not be in the same table

Which of the following is necessary to implement a 1-to - many binary relationship in a relation database design?

• Place the primary key of the entity on the many sides (child) into the entity on the one side (parent). The foreign key must be unique.

• Place the primary key of the entity on the one side (parent) into the entity on the many sides (child) as a foreign key. The foreign key must be unique

• place the primary key of the entity on the many side (child) into the entity on the one side (parent). The foreign key must not be unique.

• Place the primary key of the incident on the one side of (parent) into the entity on the many side (child) as a foreign key period the foreign key must not be unique.

Which of the following is true when representing A one-to-one binary relationship using the relational model?

•  

  The foreign key column is added to the table representing the entity with the most attributes

•  

  the foreign key is always added to the entity on the left in the EDR

•  

  a foreign key column is added to the table representing the entity on the left and a foreign key column is also added to the table representing the entity on the right.

• The foreign key column is added to whichever table will reduce the chances of having null values.

   

 which of the following is true about a foreign key column that implements a many to many binary relationship?

• The column will never require unique values. That is, the column will allow duplicate values

•  

  it is not possible to know whether the foreign key column will or will not require unique values without seeing the ERD

•  

  The column will always require unique values. That is, the column will not allow duplicate values

 which of the following is necessary to create a one to one relationship?

•  

  The foreign key and the primary key columns in the table design must have the same name

•  The relationship must cascade deletes.

• The foreign key column in the table design must not allow null values.

•  The foreign key column in the table design must be unique no duplicates.

   

Which of the following is true about a foreign key column that implements a many to many binary relationship?

•  

  The foreign key must contain unique values. that is given a value can only appear once in the foreign key column

•  

  It is not possible to know whether the foreign key column will or will not require unique values without seeing the ERD.

• The foreign key column doesn't need to contain unique values. That is, the same value can appear multiple times in the foreign key column.

Which of the following is true about a foreign key column that implements A one to many binary relationship?

• The foreign key column can have null values

•      

  It is not possible to know whether the foreign key column will or will not allow null values without seeing the ERD

• The foreign key column cannot have any null values.

Which of the following are accomplished during the relational database design? Select all that apply.

• Creates a design for a relational tables that will meet the database performance requirements of the organization

• create a design for a relational tables able to store the organization data in a non redundant manner

• creates relationships between entities with foreign keys.

• Create a design for a relational tables that implements the organization's business rules

Which of the following is the first step in representing entities using relational model?

• Determine foreign keys

• define a primary key

• define a table for each entity.

•  Determine identifiers

• DrawingNumber

• BuilderID

• LicenseNumber

• RevisionNumber

• DateCreated