| COURSE: | INFORMATION SYSTEMS 408 DATA BASE MANAGEMENT SYSTEMS |
|
| PROFESSOR: | DR. MABEL T. KUNG | |
| OFFICE: | LH 517 | |
| OFFICE HRS: | MTWTh 12 – 1PM | |
| PHONES: | (714) 278-3077 (MY
OFFICE) (714) 278-2221 (SECRETARY) |
|
| EMAIL: | mkung@fullerton.edu | |
| TEXT: | Adamski, Hommel,
Finnegan, Microsoft Access Comprehensive, Course Technology. Post, Database Systems Management and Design, Boyd & Fraser. Pratt, A Guide to SQL featuring ORACLE, Course Technology. |
|
| GRADING: | PROJECTS EXAM 1 EXAM 2 COMPREHENSIVE FINAL |
20% 25% 25% 30% |
NO MAKEUP EXAMS WILL BE GIVEN.
| EXAM DATES: | |
| EXAM 1 ….…………..JUNE 11 | (MONDAY) |
| EXAM 2 …………….. JUNE 18 | (MONDAY) |
SBAE LAB: Microsoft ACCESS, Visual Basic, and Oracle SQL will be used extensively for projects.
COURSE OUTLINE: (This is a tentative course outline subject to change)
TOPICS
Application Development of Database Systems
Data Structures for Database Processing
List Structures and File Organizations
Data Manipulation in the Relational Model
The Relational Algebra, Structured Query Language (SQL)
Normalization
SQL Commands in ORACLE
Multiple-Table Queries in ORACLE
Creating and using Scripts in ORACLE
Planning and Modifying the Table Structure
Maintaining Database Tables
Updating, Sorting, Compacting a Database
Querying Database Tables
Defining Selection Criteria, Performing Calculations,
Establishing Table Relationships
Database Design
The Entity-Relationship Model
Views and Relations
Designing Custom Forms
Creating Reports
Advanced Queries and Object Linking and Embedding (OLE)
Using the World Wide Web, the HyperText Markup Language (HTML) and Hyperlink Fields
Designing User Interface
Macros, Switchboards, Control Table, Dialog Boxes
Creating Autoexec Macros
Custom Menu Bar, Using the Menu Builder, Custom Toolbar
Access Basic
Procedures, Global Module, Event Procedures for the Dialog Box
DR. M. KUNG
SUMMER
ISDS 408 COMPUTER PROJECTS
(1) Linked Lists
Due Date: 6/12 (Monday)
(2) Case 1: Company Financial Information by FINSTAT Inc.
Due Date: 7/10 (Monday)
(3) Case 3: Internship Program for Pontiac College
Due Date: 7/10 (Monday)