Spring 2009: Database Management (INFS-614)
-
Instructor's Office Hours: M 5-7pm, Rm 449 ST2.
-
TA's Office Hours: T 2-5pm, Rm 330 ST2.
-
Prerequisites: INFS 501, INFS 515, INFS 590. Specifically:
good background in discrete mathematics
(e.g., mathematical logic,
set theory, relations and functions); programming (good knowledge
of either
C, C++ or Java), data structure and algorithms, computer
architecture and operating systems.
NOTE: PREREQUISITES ARE STRICTLY ENFORCED.
-
Textbooks:
R. Ramakrishnan and J. Gehrke, Database Management Systems,
Third Edition, McGraw-Hill, 2003.
R. Sunderraman, Oracle 9i Programming: A Primer, Addison Wesley, 2004.
-
Course Description:
Introductory course in databases.
Topics covered include:
Entity-Relationship model, Relational model, Relational Algebra, SQL,
Theory of database design.
-
Course Format:
Lectures by the instructor.
Grading will be based on homework assignments,
a midterm exam, and a final exam.
All work in this course
must be done on an individual basis. This includes tests and homework
assignments.
Any deviation from this policy will be considered a
violation of the GMU Honor Code.
Schedule of Classes
We meet in Thompson Hall 112, T 4:30pm - 7:10pm
-
Computing Resources:
- General: Oracle database management system is installed in an IT&E
Unix server, accessible from Rooms ST2-12, ST2-133, ST2-137.
It is also available via network or modem.
- Accessing Oracle: An Oracle account has been created for all students enrolled in this class. Each student should have received an e-mail with the instructions to set up his/her account. The same instructions can also be found
here
(Click on FAQ's). Basically, go to https://access.ite.gmu.edu and select Oracle from the menu bar on the right. The link also gets to the VPN client download to connect to zeus from home.
To verify that your account has been set, login to zeus.ite.gmu.edu,
and type sqlplus. If you get the Oracle prompt SQL>, your account is ready
to go; otherwise send an email to the Oracle administrator.
- Working with Oracle: You may find this small
primer useful, as it
provides information of our particular computing environment.