|
DATA
BASE MANAGEMENT SYSTEMS
|
West Valley College
CIS012 |
Data Base Management System |
SPRING 01 |
Instructor: Al
Mingione CDP, CSP
Class
time: TUESDAY 7:00 to 10pm ROOM: AAS18
Office
phone: 408/258-8791
E-MAIL [email protected]
PREFERRED COMMUNICATIONS
Required
Text: Database Processing - fundamentals, design, and
implementation; David M. Kroenke -6th EDITION, PRENTICE
HALL 98
COURSE
DESCRIPTION:
Database
Management System (DBMS) is the cornerstone technology for Information
Technology applications. The contents of the DBMS are Information
resources of an Organization. As managers you must understand how
to exploit these Information resources. As knowledge workers you must
access the operational databases and utilize a DBMS package (e.g.
ACCESS) to process your information needs. Data Management tasks have
changed and evolved over the last 30 years of rapid computer technology
advances. This course covers the evolution, concepts, terminology,
technology, and applications of DBMS. The Data Analysis and Data Design
techniques of DBMS will be demonstrated using Microsoft ACCESS.
COURSE
LEARNING OBJECTIVES:
At
the end of this course, each student should be able to:
-
Describe
the history of database concepts, techniques, and technologies
for developing business information systems.
2.
Identify and define the features and functions of DBMS software
package. Use ACCESS to demonstrate DBMS capabilities, and database
concepts.
3.
Perform the Data Analysis to create a conceptual business model,
and the Data Design to create a logical design model for Database
system development.
4.
Describe database administration to distribute, administer, share
and secure the organization’s information resources.
-
Apply
SQL and QBE access techniques for processing the content of DBMS.
-
Review
the OLAP techniques for data Warehouse, and data mining applications.
7. Discuss
the future DBMS technology including Internet, Intranet, and multimedia
CIS012 DATA
BASE MANAGEMENT SYSTEMS SPRING 01
PROJECT:
Part
of this course will be the development of an individual project (group
projects must be approved). You can do a research term paper or an
ACCESS application. Your grade will be reduced 10% if the deliverables
are LATE. Refer to the class schedule for dates.
Examples
of research subjects: Object Data Base, Multimedia, SAN, surfing the
INTERNET for Data Base topics/user groups etc.
A student
may select a project to develop a DataBase for their work or personal
use. Instructor must approve the scope of the application.
GRADING:
PROJECT
DELIVERABLES
EXAM
#1 30% Term Paper Outline/ Requirements 5%
EXAM
#2 40% Term paper Abstract / Design 5%
Term
Paper Report / Implementation 20%
Application
deliverables:
REQUIREMENTS:
Identify the scope of the application WORK and DATA.
Define the WORK using a decomposition diagram with a description
of the work process and identify the work tasks.
Define the DATA using the ER diagram and define the fields in
the data dictionary.
DESIGN:
Specify meta data, application meta data for input and output
IMPLEMENTATION:
Demonstrate the operation of the program for all inputs and outputs.
A: 90-100%
B: 80-89.9%
C: 70-79%.9%
D: 60-69.9%
F: Below 60%
CIS012 DATA
BASE MANAGEMENT SYSTEMS
CLASS
SCHEDULE
CLASS NO.
DATE
ASSIGNMENT
TOPIC
1
1/18
Introduction
2
1/25
CH. 1, 2
Overview of Data Base Processing & Development
3
2/1
CH 3, 4
Entity - Relationship Model
Semantic Object Model
4
2/8
CH. 5, 6
Data Base Design
Relational Model and Normalization
5
2/15
CH. 7
Data Base Design, Normalization continued
6
2/22
CH. 8
Data Base Application Design
7
3/1
REVIEW EXAM
EXAM - CHs. 1, 2, 3, 4, 5, 6, 7, 8
8
3/8
MID TERM
OUTLINE / REQUIREMENTS DUE
9
3/15
CH. 11
ACCESS practice
10
3/22
CH. 9
Relational model
11
3/29
CH. 10
SQL
12
4/5
CH. 12, 15
Data Administration & DB Administration,
PROJECT ABSTRACT/ DESIGN DUE
4/12
SPRING BREAK
13
4/19
CH. 15
Data Warehouse and OLAP
14
4/26
CH. 16
Internet, Intranet DB Connections
15
5/3
CH. 14
Distributed Processing, Client Server
16
5/10
PROJECT DUE
PROJECT PRESENTATIONS
17
5/17
REVIEW FINAL
18
5/24
FINAL EXAM
EXAM FINAL CHs. 9, 10, 11, 12, 14 15, 16
Instructor: Al Mingione CDP, CSP
Class time: TUESDAY 7:00 to 10pm ROOM: AAS18
Office phone: 408/258-8791
E-MAIL [email protected] PREFERRED COMMUNICATIONS
Required Text: Database Processing - fundamentals, design, and implementation; David M. Kroenke -6th EDITION, PRENTICE HALL 98
COURSE DESCRIPTION:
Database Management System (DBMS) is the cornerstone technology for Information Technology applications. The contents of the DBMS are Information resources of an Organization. As managers you must understand how to exploit these Information resources. As knowledge workers you must access the operational databases and utilize a DBMS package (e.g. ACCESS) to process your information needs. Data Management tasks have changed and evolved over the last 30 years of rapid computer technology advances. This course covers the evolution, concepts, terminology, technology, and applications of DBMS. The Data Analysis and Data Design techniques of DBMS will be demonstrated using Microsoft ACCESS.
COURSE LEARNING OBJECTIVES:
At the end of this course, each student should be able to:
-
Describe the history of database concepts, techniques, and technologies for developing business information systems.
2. Identify and define the features and functions of DBMS software package. Use ACCESS to demonstrate DBMS capabilities, and database concepts.
3. Perform the Data Analysis to create a conceptual business model, and the Data Design to create a logical design model for Database system development.
4. Describe database administration to distribute, administer, share and secure the organization’s information resources.
-
Apply SQL and QBE access techniques for processing the content of DBMS.
-
Review the OLAP techniques for data Warehouse, and data mining applications.
7. Discuss the future DBMS technology including Internet, Intranet, and multimedia
CIS012 DATA BASE MANAGEMENT SYSTEMS SPRING 01
PROJECT:
Part of this course will be the development of an individual project (group projects must be approved). You can do a research term paper or an ACCESS application. Your grade will be reduced 10% if the deliverables are LATE. Refer to the class schedule for dates.
Examples of research subjects: Object Data Base, Multimedia, SAN, surfing the INTERNET for Data Base topics/user groups etc.
A student may select a project to develop a DataBase for their work or personal use. Instructor must approve the scope of the application.
GRADING:
PROJECT DELIVERABLES
EXAM #1 30% Term Paper Outline/ Requirements 5%
EXAM #2 40% Term paper Abstract / Design 5%
Term Paper Report / Implementation 20%
Application deliverables:
REQUIREMENTS: Identify the scope of the application WORK and DATA.
Define the WORK using a decomposition diagram with a description of the work process and identify the work tasks.
Define the DATA using the ER diagram and define the fields in the data dictionary.
DESIGN: Specify meta data, application meta data for input and output
IMPLEMENTATION: Demonstrate the operation of the program for all inputs and outputs.
|
A: 90-100% |
B: 80-89.9% |
C: 70-79%.9% |
D: 60-69.9% |
F: Below 60% |
CIS012 DATA BASE MANAGEMENT SYSTEMS
CLASS SCHEDULE
|
CLASS NO. |
DATE |
ASSIGNMENT |
TOPIC |
|
1 |
1/18 |
Introduction |
|
|
2 |
1/25 |
CH. 1, 2 |
Overview of Data Base Processing & Development |
|
3 |
2/1 |
CH 3, 4 |
Entity - Relationship Model |
|
4 |
2/8 |
CH. 5, 6 |
Data Base Design |
|
5 |
2/15 |
CH. 7 |
Data Base Design, Normalization continued |
|
6 |
2/22 |
CH. 8 |
Data Base Application Design |
|
7 |
3/1 |
REVIEW EXAM |
EXAM - CHs. 1, 2, 3, 4, 5, 6, 7, 8 |
|
8 |
3/8 |
MID TERM |
OUTLINE / REQUIREMENTS DUE |
|
9 |
3/15 |
CH. 11 |
ACCESS practice |
|
10 |
3/22 |
CH. 9 |
Relational model |
|
11 |
3/29 |
CH. 10 |
SQL |
|
12 |
4/5 |
CH. 12, 15 |
Data Administration & DB Administration, PROJECT ABSTRACT/ DESIGN DUE |
|
4/12 |
SPRING BREAK |
||
|
13 |
4/19 |
CH. 15 |
Data Warehouse and OLAP |
|
14 |
4/26 |
CH. 16 |
Internet, Intranet DB Connections |
|
15 |
5/3 |
CH. 14 |
Distributed Processing, Client Server |
|
16 |
5/10 |
PROJECT DUE PROJECT PRESENTATIONS |
|
|
17 |
5/17 |
REVIEW FINAL |
|
|
18 |
5/24 |
FINAL EXAM |
EXAM FINAL CHs. 9, 10, 11, 12, 14 15, 16 |