This 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.
Friday 10:30am-1:10pm
ONLINE via Blackboard or Zoom (TBA)
Dr. Jessica Lin
Phone: 703-993-4693
Email: myfirstname [AT] gmu [DOT] edu
Office Hours: (Online) Tuesday 2-4pm
Hamed Savari
Tasfisa Mashiat
Office Hours: TBA
C or better in CS 310 (Data Structures) and CS 330 (Formal Methods and Models)
Assignments: 30%
Project: 20%
Midterm + quizzes: 30%
Final: 20%
There will be one midterm and one final exam covering
lectures and readings. The
final exam is comprehensive. Exams must be taken at the scheduled time,
unless prior arrangement has been made with the instructor.
Missed exams cannot be made up. There will be quizzes throughout the
semester.
This class will be 100% online this semester. Technology requirements to successfully complete this class include:
You must use your Mason email account for all email correspondence having anything to do with your work at Mason. Federal laws protecting your privacy rights require that we only communicate student information directly to students – and use of the university email system is our only way to validate your identity. You may forward your campus email elsewhere, but we can respond only to a Mason email account
The GMU Honor Code 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 the GMU or the CS department Honor Code is considered an Honor Code violation. All assignments for this class are individual unless otherwise specified.
If you have a documented learning disability or other condition which may affect academic performance, make sure this documentation is on file with the Office of Disability Services and then discuss with the professor about accommodations.