DB Exam 1

Attribute

• Data type

• Column data

• Row data

• Data about data

Domain

• Data type

• Column data

• Row data

• Data about data

University of discourse

• Data type

• Miniworld

• Data about data

• Row data

Meta data

• Data type

• Row data

• Column data

• Data about data

True or false: Controlled redundancy ensures consistency and saves storage space 

• True

• False

Data record

• Data type

• Column data

• Row data

• Data about data

• ___ is the description of the database and changes very infrequently

• Database schema

• Database state

• SnapShot

___ refers to the content of a database at a moment in time and changes every time the database is updated

• Database schema

• Database State

• SnapShot

What are some examples of necessary redundancy?

• SSN for fafsa info

• Product number in Amazon

• Student ID at a college

• Item description in EBay

What are some examples of unnecessary redundancy?

• Customer name in Amazon

• Item description in EBay

• Student ID at college

• Type of car color