MIS 134

INTRODUCTION TO DATABASE

Spring 2005

Instructor: Özgür AKIN, http://www.ozyazilim.com/ozgur

E-Mail: ozgur@ozyazilim.com

Assistant: Arzu TUNÇALP

Credit: 3

The purpose of this course is to introduce the student the basic concepts of database management systems. Integrated with applications in laboratory, the basic concepts such as table definition and modification, sorting and indexing, control structures storage and output operations and also screen and report generations will be covered. In addition to these, the roles of SQL in Access will be discussed.

TEXTBOOK: There will be no single textbook but several sources will be used.

REFERENCE BOOK: Roger Jennings, Special Edition Using Access 2000, Que.

COURSE OUTLINE

1. Introduction to DBMS (1 week)

2. Working with Access Databases and Tables (2 weeks)

2.1 Table Creation

2.2 Table-Fields Properties

2.3 Table Structures, Index Mechanisms

3. Forms (2,5 weeks)

3.1 Creating and Using Forms

3.2 Designing Custom Multitable Forms

3.3 Preparing Advanced Forms

4. Queries (2,5 weeks)

4.1 Designing Access Queries

4.2 Creating Multitable and Cross Queries

4.3 Modifying Data with Action Queries

5. Reports (2 weeks)

5.1 Creating Basic Reports

5.2 Preparing Advanced Reports

6. Working with SQL (2 weeks)

EVALUATION: 30 % Mid, 15 % Lab, 30% Project, 25% Final.

Midterm: There will be a lab exam.

Final: There will be closed book, written exam.

Project: The groups will consist of 2 or 3 students (selected by me). A 20 points penalty (for each day) will be given for late submissions. The projects that are late for more than 2 days will not be accepted. The other details will be given later.

Lab: There will be a take-home assignment and a quiz.

ATTENDANCE: At least 70 % of attendance is required both for lecture and lab section. The students whose attendance is less than 70% will be given F as the final grade.