course covers basics to intermediate knowledge for the design,
implementation, and use of relational database systems. The main topics
include the relational data model, Entity-Relationship (ER) model for
database design, Relational Algebra, SQL, database programming,
functional dependencies and normalization, and indexing.
Students will practice to design, develop, and implement a relational
ORACLE database and use the database for queries, transaction
processing, and report generation.
Engineering Building 4419
jessica [AT] cs [DOT] gmu [DOT] edu
TA Yuyang Gao
ygao13 [AT] gmu [DOT] edu
Office Hours: TBA
Innovation Hall 206
- Knowledge of fundamental
concepts of file and database management.
- Knowledge of database
design principles, and ability to model real-world environments using
the ER model.
of the formal principles of the relational database model and its query
languages, and ability to design relational databases and express
queries in the relational algebra and calculus.
of the Structured Query Language (SQL) and database programming
principles, and ability to author SQL queries and implement Java
database applications using the Oracle database system.
of the basic principles of the mathematical theory of database design,
and ability to design databases that adhere to Boyce-Codd Normal Form.
- Experience in the
complete database creative process: from database design, to database
constuction, to database programming.
C or better in CS 310 (Data Structures) and CS 330
(Formal Methods and Models)
There will be two midterm exams and one final exam
covering lectures and
readings. All exams will be in class, closed book. The final exam is
must be taken at the scheduled time and place, unless prior arrangement
has been made with the instructor. Missed exams cannot be
is in effect at all times. In addition, the CS Department has further
honor code policies regarding programming projects, which are detailed here. Any deviation from both the GMU and CS department Honor Code is considered
an Honor Code violation. All assignments for this class are individual unless otherwise specified. Required: Database
System Concepts, 6th Edition, by Silberschatz, Korth and Sudarshan.
Recommended: Oracle 10g Programming: A Primer
Topics Class Website
|Part 1: Relational Databases
Ch.2: Introduction to the Relational Model
Ch.6: Formal Relational Query Languages (Relational Algebra)
Part 2: Database Design
Ch.7: Database Design and the E-R Model
Ch.8: Relational Database Design
Ch.9: Application Design and Development
Ch.11: Indexing and Hashing
Note: If time permits, more
chapters will be added.