Catalogue Description of Course: This course introduces the fundamental concepts and implementation of the relational database system. The student will be exposed to SQL methodology and Entity-Relationship models.

Overview of Course: This is an introductory course on database management and its system implementation techniques. It covers the structure of database management systems, relational database theory, the structural query language (SQL), and database system development and management using the industrial database system ORACLE. The course is to include lectures, lab sessions, and student team presentations. The student is graded on exams, written homework, class presentations, and a final examination.

Outline of Topics would include the following:

• Introduction to Database Management & The Database Environment
• Database Development Process
• The Entity-Relationship Model
• The Enhanced E-R Model and Business Rules
• Object-Oriented Modeling
• Logical Database Design and the Relational Model
• Physical Database Design
• Introduction to Structured Query Language (SQL)
• Single-Table Queries
• Multiple-Table Queries