Section 6

Question 1

A UID that is a single attribute is a ……….. ……….

Answer 1

simple UID

Question 2

However, sometimes a single attribute is not enough to uniquely identify an instance of an entity. If the UID is a combination of attributes, it is called a ………… ……….

Answer 2

composite UID

The date of performance or seat number alone does not identify a concert ticket. On any given date, there are many seats available. The same seat number is sold for many different dates.

Question 3

………… …………. are those that don’t occur in the natural world but are created for purposes of identification in a system

Answer 3

Artificial UIDs

Question 4

A UID can be both artificial and ………….

Answer 4

composite

Question 5

Answer 5

R 1

Question 6

It is possible for an intersection entity to use an artificial attribute as the UID, instead of the barred relationships to the originating entities

Answer 6

R 2

Question 7

Sometimes two or more possible UIDs exist. For example, when you order a product from a commercial website, you will usually be assigned a unique customer code and asked to enter your e-mail address. Each of these uniquely identifies you, and each could be chosen as the UID. These are both ………… ……….

Answer 7

candidate UIDs

Question 8

Sometimes two or more possible UIDs exist. For example, when you order a product from a commercial website, you will usually be assigned a unique customer code and asked to enter your e-mail address. Each of these uniquely identifies you, and each could be chosen as the UID. These are both ………… ……….

Answer 8

candidate UIDs

Question 9

Only one of the candidate UIDs is chosen as the actual UID, this is called the ……… ………. The other candidates are called ……….. ………..

Answer 9

primary UID

secondary UIDs

Question 10

Secondary UIDs can be useful as an alternative means of …………………………..

Answer 10

searching for data.

• You forgot your student ID, but you have your badge with you.
• You have a frequent-shopper card at the supermarket but did not bring it with you. Some systems can find your information if you provide your telephone number.

Question 11

Answer 11

R 2

Question 12

…………………..: A series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database. These steps reduce data redundancy and the chances of data becoming inconsistent (because two copies and somebody update only one of them).

Answer 12

Normalization

useful memory aid: some legal systems require that a witness in court swears to tell “the truth, the whole truth and nothing but the truth”. One way of stating the normalization rules is that “Every non-UID attribute must be dependent on the UID, the whole UID, and nothing but the UID”.

Question 13

One of your goals as a database designer is to “store information in …… ………. and in the best possible place“

Answer 13

one place

Question 14

1NF eliminates repeating groups (multiple values) within an attribute by transferring the attribute to a
new entity and then connecting the entities with a ………. relationship.

Answer 14

1:M

Question 15

Following the rules of 2NF allows us to validate that every attribute is in the correct …………, and identify entities that may have been missed in our original ERD.

Answer 15

entity

Question 16

Note that the rule of Second Normal Form states that any …………. field must be dependent on the ……………

Answer 16

non-UID / entire UID

Question 17

An entity is considered to be in 2NF if the UID of the entity is ………….

Answer 17

simple

Question 18

The rule of Third Normal Form (3NF) states that no ……….. attribute can be dependent on another ………… attribute

Answer 18

non-UID

Question 19

A ………. ………… exists when any attribute in an entity is dependent on any other non-UID attribute in that entity

Answer 19

transitive dependency

Third normal form: The form of database normalization where all non key fields are dependent on the key, the whole key, and nothing but the key

Question 20

Third Normal Form ………… transitive dependencies

Answer 20

prohibits

Question 21

Third Normal Form Violations are hiding ………. ………

Answer 21

another entity.

Question 22

For an entity to be in Third Normal Form, it must also be in ……… ……… ………..

Answer 22

Second Normal Form

Question 23

Answer 23