Course Goals:
- Introduce entity-relationship models for databases
- Present the relational data model for databases
- Describe SQL, a database query language
- Provide practical database design methods that use UML
- Describe the physical and logical methods for storing and retrieving data from a database
- Present optimized techniques for processing database queries
- Introduce fundamental concepts for transaction processing
- Present an overview of advanced database concepts including object databases,
security issues, and distributed databases
Course Objectives: By the end of this course, you should
- Know how to model data using the entity-relationship model
- Be able to model data using a relational model
- Be able to manipulate relational data using relational algebra and calculus
- Understand and be able to use the basic SQL constructs
- Be able to identify functional dependencies in relational databases
- Know several database design algorithms and be able to use them
- Know how to design a database using UML
- Understand the relationships among disk organization, file structures, and hashing
- Know several indexing structures for files and be able to use them
- Know several algorithms for processing queries and be able to use them
- Understand how to tune a database
- Understand the basic concepts behind transaction processing
| 
