Nov 21, 2019
CST 213 - Database Systems
A comprehensive course in database management with a focus on the effective use of database systems, database design, and application development with Access and Visual Basic for Applications. Topics will include database concepts and architecture for both micro and mainframe computers, creating tables, queries, forms and reports, object linking and embedding, SQL, macro programming, integrity constraints, concurrency control, and transaction processing.
Prerequisite: CST 119 Computer Concepts and Applications, and an introduction to programming course
2 Class Hours, 2 Laboratory Hours
Learning Outcomes of the Course:
Upon successful completion of this course the student will be able to:
- Describe the advantages and disadvantages of database systems.
- Describe and compare Relational, Network, and Hierarchical data models.
- Design and create relational databases including tables, forms, queries, and reports.
- Create and execute SQL queries.
- Describe relational model views, indexes, catalogues, and integrity as they relate to databases.
- Describe and implement normalization as it relates to databases.
- Describe and implement database functions of concurrency, recovery, and security.
- Generate custom database applications.
- Program a database using macros.
- Describe client/server systems and SQL servers.
[Add to Portfolio]