Normalization is a process for evaluating and correcting table structures to minimize data
redundancies, thereby reducing the likelihood of of data anomalies. This takes place through a series of
stages called normal forms. 1NF, 2NF, 3NF, and 4NF. The hig
Each row in a column in a relational database describes an entity occurrence within an entity set.
Most databases support numeric, character, date, and logical data.
A column's range of permissible values is known as its domain.
Each table must have a pri
A required attribute is an attribute that must have a value. This is opposite an optional attribute.
A domain is a set of possible values that an attribute can have.
Identifiers are like primary keys.
Key attributes are also underlined in a frequently use
Multiple Table Queries Quiz(s)
A customer has come to you, wanting a database created in order to store information about purchases
along with some querying capabilities. The customer has provided you with a sample of 6 invoices (see
attached Excel file).
May 3, 2011
Order ID #:
742 Evergreen Terrace
532 Blue Road
NORTHERN KENTUCKY UNIVERSITY
COLLEGE OF INFORMATICS DEPT. OF BUSINESS INFORMATICS
INF-282 INTRODUCTION TO DATABASES
INF 282 (005) Fall 2015
LOCATION: GH 150
CLASS TIME: M, W 3:25 4:40 p.m.