The page uses Browser Access Keys to help with keyboard navigation. Click to learn moreSkip to Navigation

Different browsers use different keystrokes to activate accesskey shortcuts. Please reference the following list to use access keys on your system.

Alt and the accesskey, for Internet Explorer on Windows
Shift and Alt and the accesskey, for Firefox on Windows
Shift and Esc and the accesskey, for Windows or Mac
Ctrl and the accesskey, for the following browsers on a Mac: Internet Explorer 5.2, Safari 1.2, Firefox, Mozilla, Netscape 6+.

We use the following access keys on our gateway

n Skip to Navigation
k Accesskeys description
h Help
   
Website Catalog
SUNY Broome Community College
   
 
  Jan 22, 2018
 
 
    
Website Catalog
[Add to Portfolio]

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- Corequisite
Prerequisite:  CST 119 Computer Concepts and Applications, and an introduction to programming course

Credits: 3
Hours
2 Class Hours, 2 Laboratory Hours
Course Profile
Learning Outcomes of the Course:

Upon successful completion of this course the student will be able to:

1.  Describe the advantages and disadvantages of database systems.
2.  Describe and compare Relational, Network, and Hierarchical data models.
3.  Design and create relational databases including tables, forms, queries, and reports.
4.  Create and execute SQL queries.
5.  Describe relational model views, indexes, catalogues, and integrity as they relate to databases.
6.  Describe and implement normalization as it relates to databases.
7.  Describe and implement database functions of concurrency, recovery, and security.
8.  Generate custom database applications.
9.  Program a database using macros.
10.  Describe client/server systems and SQL servers.



[Add to Portfolio]