Database - Midterm Cards

What is structural independence? Why is it important?

What is data?

What is information?

Character or group of characters with a specific meaning

One or more fields that describes a person, place, thing

Collection of related records

Database Types (Number of Participants)

Database Types (Localization)

Database Types (Strategy)

Database Types (Structure)

What is data redundancy?

What is data inconsistency

What is data anomalies?

What are the three redundancy/anomalies problems?

The 5 roles of people

The 9 funtions of DBMS

What does the data dictionary management? (DBMS)

What does the data storage management? (DBMS)

What does the data transformation, and presentation? (DBMS)

What does the security management? (DBMS)

What does the multi-user access control? (DBMS)

What does the backup and recovery management? (DBMS)

What does the data integrity management? (DBMS)

What does the database access languages and application programming interfaces? (DBMS)

What does the database communication interfaces? (DBMS)

What is an Relational Database Model?

What is an entity?

What is a compound attribute?

What is a single valued attribute?

What is a multi valued attribute?

What is a derived attribute?

What is an attribute?

What relationships do you know?

What is a constraints and what constraints do you know?

Business Rules!

Level Architecture. What is that?

What is schema and subschema?

External model (Level Achitecture)

Conceptual model(Level Achitecture)

Internal model(Level Achitecture)

Physical model(Level Achitecture)

What does a key and what keys do you know?

Integrity Rules?

DBMS Language SQL supports what languages?

What is DDL?

What is DML?

What is DCL?

What relational operators do you know?

What does SELECT? (relational operators)

What does PROJECT? (relational operators)

What does UNION? (relational operators)

What does INTERSECT? (relational operators)

What does DIFFERENCE? (relational operators)

What does PRODUCT? (relational operators)

What JOINS do you know and what are they doing? (relational operators)

For what is an assosiative entity mostly used?

Where do you implement multiplicity and where not?

What does cardinality mean?

What it the difference of Non-Identifying and Identifying Relationship?

UNARY
BINARY
TERNARY
- Relationships

What is a HOMONYM and a SYNONYM?

What are the iterative steps to design a database?

What is important to know about database design?

NORMALIZATION!!! Whats that?