SOLANO COMMUNITY COLLEGE 

             COMPUTER AND INFORMATION SCIENCES 78

                  DATABASE MANAGEMENT SYSTEMS

INSTRUCTOR: Earl T. Wylie, Ph.D.

PHONE:

             864-7000 voice mail box 662

             EMAIL – earl.wylie@solano.edu

              Web - www.earlwylie.com

Data Files http://busdiv-iis.solano.cc.ca.us

M:

Class outline: H:/ewylie/cis78/Fall04

Software Purchase: www.collegesoftware.org

OFFICE HOURS: Room 514

CLASS DATES: 8/23/04/04 to 12/15/04

CLASS ROOM: Room 503

CLASS TIME: 11:00 am MWF

LAB HOURS: ROOM 507-504  Lab Hours vary from semester to semester. Check bulletin board outside of rooms 507 or 504 or Vacaville Lab or Vallejo Lab.

REQUIRED TEXT

Adamski, J,  &  Finnegan,K.  Microsoft Access 2003, Comprehensive Enhanced. Course Technology, Cambridge, MA. 2000. ISBN 0-619-20672-1

The first two tutorials of this book cover Windows XP. These chapters will not be covered in lectures in this class.  If you have any questions on Windows XP please feel free to ask during class.

SOFTWARE USED:  MS Access 2003

MATERIAL REQUIRED

1 USB Flash Memory (EEROM).

Three (3) -882 scantron

OBJECTIVES

 

1.     Comprehend relational database concepts and database design.

2. Work with Tables, Forms, Queries, Reports, Macros, and Modules

3. Understand the process of setting up a data base.

a.       Identify all fields/attributes of the fields

b.      Group field into tables

4.   Integrity Issues - Referential, Domain, Entity, Normalizing, one to many, one to one, many to many..

5. Work with data types and Assign properties to each field.

6. Work with data types and properties

7. Relate multiple tables

8. SQL - Introduction

9. Automating task with Macros and Modules (Visual Basic)

                       10. Print database documentation, encrypt and decrypt, set password, link  databases, set         user profiles and security.

GRADING

Test - Level 1  = 100

Test - Level 2  = 100

Test - Level  3  = 100

Labs 1 to 14    = 140

Lab 15             = 100

Total                   540

Lab assignments 1 to 14, Level 1, Level 2, and Level 3 exams will determine your final grade. The following scale of total points will be used to assign course grades:

            92-100%         A          Excellent       >=496

            82-91%           B         Good              >=442

            70-81%           C         Satisfactory    >=378

            60-69%           D         Passing           >=324

            0-59%                         F          Failure            <=299

 

NOTE: when saving your work to a floppy disk do not use long file names.  Keep your file names limited to 8 characters and a 3 character extent.  filename.ext.  

CIS78 LAB ASSIGNMENTS

1. From your home you will type in http://busdiv-iis.solano.cc.ca.us.

2. Click on M drive.

3. Click on CIS 78

4. Click on Wylie

5. Right Click on 2089-xd.exe
6. Click on save target as
7. Save it where you want.
8. This is a zip file so you must unzip it.

From the classroom or computer lab on mail campus

Level 1 files are for chapters 1-4

These files will be available on M:/CS78/wylie

Level 2 files are for chapters 5-8

These files will be available on M:/CS78/wylie

Level 3 files are for chapters 9-12

These files will be available on M:/CIS78/wylie

Class outline is on H:\EWYLIE\CIS78\Fall04\cis78mwf11.doc or www.earlwylie.com

When we are working the tutorial in class at the beginning of class you will copy the tutorial files to desktop and at the end of the lab copy the files back to  A:

All lab assignments will have the students name, class, instructor, and date in the top right hand corner of the assignment.  All assignments larger than one page will be stapled in the top left hand corner. All lab assignments must be completed and turned in.  The following lab assignments are required:

All labs are to be turned in at the beginning of class on the day that they are

due. Labs not turned in at the time they are due will receive no credit – 0  Note you must do step 1 through all steps of each lab.  Additionally you must do all the preceding chapters of CASE 4 Mountain River Adventures in order to turn in the assigment for chapter 4, 7, and 11.

           Lab                                                                                        Due Date

All reports and forms will have your company logo on it and grand totals in the report footer.

Your class project is to be handed in on disk or CD. You must have a least 30 records in the database.

The guidelines on what should be contained in the final project are located at www.earlwylie.com

When the student first begins to use the tutorial database they must save all of the tables, queries, reports, forms, and macros created with the student's initials at the beginning of the name and tbl, qry, rpt. frm, or mac at the end of the name.  Due to conflicts with advance macros and visual basic there will be no spaces in module names.    Furthermore, all forms and reports created by the student will have a label box in the form or report header with the students name, class, date, chapter, page and lab number.  The text will be colorful.  

Make up of missed exams and extra credit work by arrangement with the instructor.

Class Schedule

                Date           Lecture