Russell C. Fish
I S 480
Examines the business need for database processing. Discusses database development and administration, including data modeling, role normalization, use of SQL for DDL, and DML. Students practice converting data models to database design. Covers application development for Web databases, data warehouses, OLAP. Prerequisite: I S 310; may not be repeated. Offered: AWSp.
Robust access to enterprise data is a key concern for every organization. This course focuses on the design of database schemas and the implementation of database systems. To effectively develop database applications, a thorough understanding of database terminology, data modeling methods, and structured query language (SQL) is necessary. When a complete, robust design is available, the implementation process begins. Issues surrounding database development provide valuable insight into the modeling phase, as well as positive feedback for future projects.
This course covers both of these issues by providing a solid understanding of the database modeling and design process, and by offering students the opportunity to design small but useful applications using the Microsoft Office suite of tools, and in particular Microsoft Access 2000.
This course assumes that the student has successfully completed IS300 (Introduction to Information Systems) and IS320 (Fundamentals of Application Programming). A moderate to high level of comfort with the Visual Basic programming language is assumed, and limited instruction on basic programming issues (material covered in chapters 1-9 of Burrows and Langford) is provided.
Class Assignments and Grading
Database development/programming assignments in Access/VBA
The course grade is determined using the percentages below: Assignments: 35% First Exam: 30% Second Exam: 35%