This course provides the student with database system concepts. Topics introduced include: conceptual, logical and physical designs, Entity Relationship (ER), ER diagramming, ER mapping, normalization, SQL, coreDBMS functions, transaction management, triggers, views, stored procedures, and indexes. Several types of database systems will be reviewed with the focus of study on relational database systems. Students will design and build databases using SQL Server. 3 lecture hours; 0 lab hours per week.
Textbook info is available at http://www.bhc.edu/on-campus/bookstore/ You will need to know the BHC course #, e.g. BL 201, and the section #.
Upon successful completion of this course, the student shall be able to: A. Describe core database system components and functions. B. Evaluate database models to determine appropriate model to support requirements. C. Define the fundamental terminology and basic principles used in the relational data model. D. Develop an ER (entity-relation) model based on business rules applying appropriate types or relationships between entities, cardinality, and modality. E. Map ER model to relations that can be used to create a database. F. Normalize a database by applying the first, second, and third normal forms. G. Create a relational database schema in SQL that incorporates key, entity integrity, and referential integrity constraints. H. Retrieve information from a database using the SQL SELECT statement or modify data using SQL INSERT, DELETE, and UPDATE statements. I. Write a stored procedure that uses parameters and has some control flow. J. Explain the concepts of transactions and concurrency control. K. Create a transaction. L. Identify appropriate indices for given relational schema and query set. M. Describe and use objects in SQL Server database.
Black Hawk College: 6600 34th Ave Moline, IL 61265 Phone: 3097965000