CIS 332 Database Concepts (3)

Catalog Description:

Relational databases. Semantic object modeling. SQL in both local and client-server environments, in both embedded and stand-alone applications. (Offered fall semester only.)


Prerequisites:

Because SQL is embedded in Java in one assignment to meet objective 5 above, CIS 283 Business Systems Applications or CIS 284 Computer Programming II is required. Most of this course requires only the maturity of an upper-division Information Sciences major, so as to be able to see more than one solution to a problem, and to handle abstract notation.


Required Course Materials:

  1. Jeffrey A. Hoffer, Mary B. Prescott and Heikki Topi, Modern Database Management, 9th edition, Pearson Education, Inc., 2009 (ISBN: 0-13-600391-5)
  2. Articles and web sites referenced throughout the course will be provided on Canvas.
  3. Software –MS Office, Visio, Access (all loaded in labs), MySQL, MySQL Workbench, XAMPP (free download) and Eclipse (free download)

 

Course Coordinator:


D. Scott Weaver, Assistant Professor of Computer Science

Course Audience:


Required by Computer and Information Science majors. Open to all students.

Course Objectives:

Upon completion of this course, successful students will have a significant appreciation for the important role database management systems (DBMSs) play in computer systems. This course will prepare students to:

  1. Describe and apply the concepts of data modeling, using both ER modeling approach to develop sound data models.
  2. Design new and re-design existing databases using normalization techniques, or to defend a decision to de-normalize a database.
  3. Create database queries using SQL.
  4. Demonstrate understanding in the use an open source relational database (MySQL).
  5. Develop views and other database structures required by the web application.

Topics:

  1. Entity-relationship modeling.
  2. Relational databases, normalization, and SQL.
  3. Embedded SQL in Java and other ODBC or JDBC client-server environments.
  4. Solving business problems as individual homework or laboratory assignments.
  5. Conceptual overview of the place of databases in the project life cycle and in corporate decision-making.

 

Revised: October 2013 (update); September 2011

Return to Course Index