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
BCS 120 or BCS 185
At the completion of this course, students will:
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
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.