|
CS3380 Database Application and Information Systems
Syllabus
Overview: This course covers the fundamental topics of database management systems (DBMS) and database-enabled applications, as they relate to today’s Information Systems (IS). Topics will include a brief history of secondary storage & databases, data modeling, introductory SQL, an overview of current database trends, and current popular database systems. Students will develop hands on experience through weekly labs and a series of small projects implementing increasingly larger databases and various data access methods.
Textbook: Michael V. Mannino
Design, Application Development, and Administration, 2nd Ed
McGraw-Hill, 2003
Prerequisites: CS 2050
Topics: 1. History of Secondary Storage and database systems (1.0 weeks)
2. Relational Data Modeling: conceptual, logical, physical (1.5 weeks)
3. Entity-Relationship-Diagrams (2.0 weeks)
4. Relational Algebra (1.0 weeks)
5. Database Normalization (1.0 weeks)
6. Database Architectures (1.0 weeks)
7. Information Systems and Database integration (2.0 weeks)
8. SQL (2.0 weeks)
9. Procedural DB Interfacing: PHP/Java (1.5 weeks)
10. ODBC/JDBC (1.0 weeks)
11. PL/SQL (1.0 weeks)
12. Database Maintenance/Tuning (1.0 weeks)
Prepared by: Grant Scott
Date: September 2004
Covers fundamental top-
ics of database management systems (DBMS)
and database-enabled applications. Topics
include a brief history of secondary storage and
databases, data modeling, introductory SQL, an
overview of current database trends, and current
popular database systems. Prerequisite: CS
2050. Graded on A/F basis only.
|
