Course Description
This course presents the fundamental concepts of database design and use. It provides a study of data modeling, logical and physical database design, and query facilities including SQL, data normalization, database administration, and data warehousing. It also looks at the new trends in databases. The knowledge of the above topics will be applied in the design and implementation of a database application using MS Access. Another software you may use is MySQL. However, while it is briefly introduced, MS Access is the primary database software for the class.
Required Text
📚
Database Concepts, 9th Edition
David Kroenke, David Auer, Scott Vandenberg, and Robert Yoder
Prentice Hall, 2020
ISBN-13: 9780135188149
Course Objectives
Upon completion of IS 613, students should be able to:
- Introduce the basic concepts of the database approach, the underlying models and organizational issues.
- Provide students with the tools to design a conceptual data model (entity-relationship diagram) and a well-structured logical data model (relational data model).
- Expose students to the Structured Query Language (SQL) and its use in creating, maintaining, and querying a database.
- Introduce the process of normalization and its role in producing a well-designed relational database.
- Familiarize students with the basic issues of database administration.
- Expose students to the concepts of data warehousing.
- Provide students with hands-on experience in using a commercial database management package.