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 be able to:

    1. Identify and describe the main concepts of database systems and of relational databases
    2. Describe the functions of a database management system.
    3. Recognize and explain the basic Entity-Relationship (E-R) diagram components.
    4. Build an E-R diagram using business rules
    5. Convert an ER Diagram into relational database tables
    6. Normalize a relational database up to and including Boyce-Codd Normal Form.
    7. Explain the role of database development within the Systems Development Life Cycle.
    8. Demonstrate a working knowledge of a commercial database management system.

 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.  This system may be built as a team project at the discretion of the professor. 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.