Intro to databases midterm exam

Anomalies

Norma Forms

Normalized database

Primary key

Foreign Key

C

Candidate Key

Composite Key

A

About MS Access

Entity and its relationship to itself

F

Functional dependencies

Read-only databases

DBMS

Integrity constraints(exclusive, decisive, Using Discriminator Column)

DB tables, rows and column

S

SQL queries

I

IW Crow’s Notation

Minimum Cardinality

N

Normal forms (charasteristics of the relations): 1NF, 2NF, 3NF, BCNF, 4NF

Be able to look at SQL and know what the output will be

Be able to find errors in SQL

SQL Commands(WHERE, GROUP BY, ORDER BY, HAVING, etc)

STRONG/WEAK ENTITY

Benefits of having a surrogate key

Attributes of a primary key

K

Know the charactersitics of a relation (there are 8 of them), primary key is not one of them.

R

Referential Integriy Constraint

Domain Integrity Constraint

Entity Integrity Constraint

Data Integrity Constraint

HO

How to make a subquery

Types of recursive relationships: 1-to-1, 1-to-many, none-to-many

W

What makes up a table: rows, columns

What makes a relation? Attribute, tuples

What does a FIle need to contain? Field, record

H

ow to remove a multivalued dependency?

Metadata

Concurrency Control

K

now/Identify strong and weak relationships

F

FROM/SELECT/HAVING/WHERE

Data manipulation language

D

Data definiton language

Enterprise-class

R

Read-only database