Data vs Information
Information System vs Database
Why have a database?
Transaction States + Updates
Maintaining data consistency and integrity
Database Transaction
Concurrency in Data Sharing Situation
Validation vs Verification of Data
DBMS vs RDBMS
DBMS functions + tools
DBMS promotes data security
Schema
Three Levels: Conceptual, Logical, Physical
Data Dictionary (A2.6 - A2.8)
Relationship within Database
One-to-one
One-to-many
many-to-many
Redundant Data
Referential Integrity in a normalized database
1NF
2NF
3NF
Characteristics of a normalized database
ERD Diagram
Role of a DB administrator
End Users interacting with a Database
Different methods of DB recovery
How does integrated database systems function?
Real Life uses of databases (stock control, police records, health records, employee data)
Privacy of Personal Data and responsibility of the holder
Governing agencies right to access such data
Data matching vs Data mining
ACID
Atomicity
Consistency
Isolation
Durability
Query vs Update
How does a query provide view of a database
Query Use
Boolean Operators (AND, OR, NOT)
Parameter Queries
Derived Fields (Making new dynamic columns)
Database Terms
Table
Record
Field
Primary Key
Secondary Key
Foreign Key
Candidate Key
Composite Primary Key
Inner Join
Evaluate the appropriateness of the different data types.
Problem Solving:
Generating 3NF database
Last updated 2 months ago