Erstellt von Yorria Raine
vor fast 10 Jahre
|
||
File Based Systems
Database System
DataBase Management System (DBMS)
Client Server Database System Architecture Includes what two things?
Database System Arch. Server Process
Database System Arch. Client
Personal Database Management Systems (include example)
Client/Server Database Management System Advantages
Relational Database Model includes what two things?
Set Theory
Predicate Logic
Name the aspects of a Relational Database Model
Structural Aspect of Relational Model
Integrity Aspect of Relational Model
Manipulative Aspect of Relational Model
Table (relation)
Integrity Aspect Key Fields and Types
Primary Keys
Candidate Keys
Surrogate Keys
Foreign Keys
Composite Key
Properties of Relations Structural Aspect
E.F.Codd's Twelve Rules for Fully Relational Database
Codd's Summary:
Entity-Relationship Model Goal
Normalization
User Views
Information Level Design Steps
Relationship Types
One to One (1:1)
Rarely implemented as such
Many-to-Many(N:M)
One-to-Many(1:M)
General Design Principles
Functional Dependence
First Normal Form
Second Normal Form
Third Normal Form
4NF
Design Methodology
IDEF1X
IDEF1X Shapes (Rectangle / Line Type)
The Entity-Relationship Model
Refinement: Existence Dependence
Weak Entity
Cardinality
Structured Query Language
Basic Categories for SQL Commands
User Accounts and Schema
SELECT Statement
Basic Queries
Entity Subtypes