Database Exam

Tables

Graphs

Images

None of the above

Performing calculations

Encrypting database data

Backing up a database

Representing database structure visually

To sort the records alphabetically

To store duplicate data

To uniquely identify records

To delete data

Organization

Speed

Data redundancy

Security

Stores images

References a primary key in another table

Encrypts data

Acts as a duplicate entry

One record in a table is linked to one record in another table

One record is linked to multiple records in another table

Many records link to many records in another table

No relationship exists

1NF

UNF

2NF

3NF

REMOVE COLUMN

DELETE COLUMN

DROP COLUMN

ALTER COLUMN

Transitive dependencies

Partial dependencies

Multi-valued attributes

Foreign keys

To increase redundancy

To minimize data redundancy and dependency

To store data randomly

To make queries slower