Transcript What is a Database Management System?

Course Review
Database Management
COP4540, SCS, FIU
Basic Concepts
• Basic concepts
– Different types of DBMS
– Advantages over file systems
– Two famous RDBMS prototypes
– What is metadata
– What are data models
– What is a transaction? Why transaction?
– ...
Database Management
COP4540, SCS, FIU
Database Design
• Database design
– Design goals
• Minimize redundancy in order to eliminate the
modification anomalies in database.
• Represent the situation accurately
– Design Stages
• Conceptual (product independent)
• Logical (product specific)
• Physical / Implementation (product specific)
Database Management
COP4540, SCS, FIU
Database Design
• Conceptual level design
– ER and ODL
• Logical level design
– Relational design
• PK and FK, Constraints, Assertions
• Normalization, functional dependencies
– How to write DDL statements in SQL to
implement a database
• Physical level design
– index and cluster
Database Management
COP4540, SCS, FIU
Database Language SQL
• Three components: DDL, DML, QL
• Fundamental: relational algebra
– basic operators
•
•
•
•
Syntax of SQL
How to define queries by using SQL
When and how to create views
Oracle PL/SQL and database triggers
Database Management
COP4540, SCS, FIU