BCS Courses

 

Ready to Apply?
File your application
online through SUNY's
website.
Apply Now

 

BCS 260: Data Base


This course provides the fundamental knowledge of database concepts. Topics studied will include the history and advantages of database systems, and the process of database design including entity-relationship diagrams and database normalization. Students will have hands-on experience using a relational database system. Credits: 3.00

Prerequisite: 

BCS 120 or BCS 185

Course Objectives:

At the completion of this course, students will:

    1. Identify and understand the main concepts of database systems.
    2. Understand the functions of a database management system.
    3. Know the basic relational database components and concepts.
    4. Identify and describe basic Entity-Relationship (E-R) diagram components.
    5. Know how to use business rules in the development of E-R diagrams.
    6. Be capable of normalizing a relational database up to and including third normal form.
    7. Understand the role of database development within the Systems Development Life Cycle.
    8. Develop a working knowledge of MS Access.

 Textbooks:

Kroenke & Auer - Database Concepts, 6th Edition, ISBN 0132742926
Forta - SAMS Teach Yourself SQL in 10 minutes, 4th Edition, ISBN 0672336073
Goldberg - XML: Visual Quick Start Guide, 2nd Edition, ISBN 0321559673

Capstone:

During the semester the student will develop a database system either individually or as part of a team depending on the complexity of the system design. The final project portfolio will contain: description of requirements, description of each query and/or report, entity relationship diagram, layout of tables, description of each attribute, copies of data in each table, sample screens from all queries and reports, documentation including: detailed instructions on using the system, backup and recovery instructions.