ISYS 200 - Database Design and Implementation

Winter 2004

 

Instructor:

Name: Jon Huhtala
Office: Business 366
Phone: 231-591-2477  (extension 2477 on campus)
E-mail:

When sending e-mail, mention ISYS 200 in the subject line or your e-mail will be deleted.

 

My Classroom and Office Schedule:

 

M

T

W

R

F

  8:00

 

 

 

 

 

  9:00

 

 

 

 

 

10:00

   

 

 

 

11:00

         

12:00

 

       

  1:00

ISYS 216   ISYS 216   ISYS 216

  2:00

         

  3:00

Office Office Office Office  

  4:00

ISYS 200 ISYS 200 ISYS 200 ISYS 200  

  5:00

" " " "  

 

Course Description:

Introduces the basic concepts of relational databases, tables, records, and fields. This course is an introduction to database design, and implementation using Microsoft Access. Relational database structures, normalization techniques, and integrity constraints are introduced. Beginning and intermediate query, form, report, and web publishing facilities are demonstrated and utilized. 

 

Course Outcomes:

Upon successful completion of this course, you will be able to:

1)      Understand the basic concepts of relational databases.

2)      Create tables, define data types, create data input rules and define relationships between tables.

3)      Use automated query, form, report, and web publishing tools in Access.

4)      Manually create multiple query types in Access that include joins and intermediate selection criteria.

5)      Manually create forms in Access from tables and queries that include subforms.

6)      Manually create reports in Access from tables and queries that include subreports.

7)      Demonstrate the ability to integrate tables, queries, reports, and web publishing for use in database management.

 

Prerequisite:

 

Text:

 

Web Resources:

The primary course Web site is Java Help. From the opening page, follow the links to "Courses from Ferris State University" and "ISYS 200 - Database Design and Implementation". There you will find links to the course syllabus, tutorial help, class schedule with links to assignments, and your current grade.

 

Required Supplies:

 

Data Files for Tutorials:

All the files you need to complete textbook tutorial "sessions" can be copied directly to your zip disk from the following College of Business network folder:

L:\BTC\JON HUHTALA\DATABASE\Data Files

This may be done at any time in any College of Business lab. Simply copy the entire "Data Files" folder to the root directory of your zip disk.

The "Data Files" folder contains the following subfolders:

 

Data Files for Cases:

All the files you need to complete case problems can be copied directly to your zip disk from the following College of Business network folder:

L:\BTC\JON HUHTALA\DATABASE\Case Problems

This may be done at any time in any College of Business lab. Simply copy the entire "Case Problems" folder to the root directory of your zip disk.

The "Case Problems" folder contains subfolders named "Case 1", "Case 2", etc. for each of the 9 cases you must complete this semester. Within each subfolder are the necessary database files along with a Word document that describes what you must do within the case.

 

Class Time:

Every class session will be an open lab. Working within the guidelines of the class schedule, use this time to complete the 23 "sessions" in Access tutorials 1 through 9 of the book, the 9 required case problems, or the major project. I will be available to help if you have problems.

 

Case Problems:

Each of the 9 Access tutorials has an accompanying case problem. The necessary files and a Word document describing the case must be copied from the College of Business network (see Data Files for Cases, above). For credit, you must send me an e-mail with answers to any case questions and the attached data base (.mdb) solution file on or before the due date listed in the class schedule. You will receive a return e-mail with your score within a few days of the case's due date.

 

Major Project:

After completing all Access tutorials and cases, you will design and develop a comprehensive database solution to a problem of your choice. Minimum requirements will be specified in the project assignment. For credit, you must send me an e-mail with the necessary attachments no later than the due date listed in the class schedule. I will send an e-mail reply with your score within a few days of the project's due date.

 

Competency Exam:

At the end of the semester, you must design and develop in class a small database that shows your competency in the material covered. You will have 100 minutes to complete the work independently.

 

Grades:

Your final grade will be based on the following:

Graded Item

Points Possible

  Case problems

90

  Major project

90

  Competency exam

60

Total              

240

Letter grades will correspond to the following:

Points Earned

Final Grade

216 and up

A

192 - 215 B
168 - 191 C
144 - 167 D
0 - 143 F

Note that:

 

Classroom Policies and Attendance:

It is expected that everyone will conduct themselves in a professional manner by following these rules: