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

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.

1. Jeffrey A. Hoffer, Mary B.Prescott and Heikki Topi, Modern Database Management, 9^th edition, Pearson Education, Inc., 2009 (ISBN: 0-13-600391-5)
2. Articles and web sites referenced throughout lecture notes with links to articles when available.
3. Software –MS Office, Visio, Access (all loaded in labs), MySQL, MySQL Workbench

D. Scott Weaver, Assistant Professor of Computer Science

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

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 and OO modeling approaches and 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 database access objects using PHP for integration with database applicatons for the Internet.

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.