Databases

by Corina Paraschiv

1. Notes

2. Scalability

3. Performence

4. Functions

4.1. Redundency

4.2. Inconsistency

4.3. Integrity

5. Protection

5.1. Security

6. New node

7. Four components

7.1. Data Definition

7.1.1. Data dictionary

7.1.1.1. Variable names

7.1.1.1.1. Each field has a name.

7.1.1.2. Business rule

7.1.1.2.1. Validation rule

7.1.1.2.2. Duplicate

7.1.1.3. Keys

7.1.1.3.1. Foreign key

7.1.1.3.2. Primary key

7.2. Data manipulation

7.2.1. Query-by-example

7.2.2. Structured query language

7.3. Data

8. Relationships

8.1. one-to-many

8.2. many-to-many

8.3. one-to-one