null

Info
Ratings
Comments

Quiz by Ray Welland, created more than 1 year ago

Normalisation

Pinned to

No tags specified

level 5
uml
uml
level 5

	Created by Ray Welland over 11 years ago

704800

quiz

2016-02-19T07:13:16Z

UML Lec4 Quiz

Please wait - loading…

Question 1 of 6

The process of normalisation involves applying a series of refinements to groups of data items in order to produce relations that conform to specified standards, known as normal forms

Select one of the following:

True
False

Explanation

Question 2 of 6

What happens if you want to insert a new branch that does not have any members of staff yet?

Select one of the following:

Would work
Insertion Anomaly

Explanation

Question 3 of 6

What happens if you delete staff number S0415?

Select one of the following:

Would work
Deletion Anomaly

Explanation

Question 4 of 6

What happens if you want to change the telephone number of branch B001?

Select one of the following:

Would work
Modification Anomaly

Explanation

Question 5 of 6

To minimise data redundancy, relations that contain redundant data may potentially suffer from update anomalies, which is NOT true

Select one of the following:

Insertion anomalies
Deletion anomalies
Modification anomalies
Criteria anomalies

Explanation

Question 6 of 6

Is this true about Functionally Dependency?
In a table listing employee characteristics including Social Security Number (SSN) and name, it can be said that name is functionally dependent upon SSN (or SSN -> name) because an employee's name can be uniquely determined from their SSN. However, the reverse statement (name -> SSN) is not true because more than one employee can have the same name but different SSNs.

Select one of the following:

True
False

Explanation

To go back and change any of your answers, use the progress bar above or
jump back to the previous question.

Loading your results

As this is a preview, your results will not be submitted at this time.

Restart Preview

["https://examtimeassets.s3.amazonaws.com/uploads/multiple_choice_question/image/583988/desktop_insert.jpg","https://examtimeassets.s3.amazonaws.com/uploads/multiple_choice_question/image/583989/desktop_delete.jpg","https://examtimeassets.s3.amazonaws.com/uploads/multiple_choice_question/image/583990/desktop_modify.jpg"]

704800

quiz

2016-02-19T07:13:16Z

You need to log in to complete this action!