The course will introduce fundamental concepts in relational databases,
such as: the relational model and relational algebra; the Standard Query
Language (SQL); database design theory; conceptual design; database
application development; database security.
Students registering for CS430/630 must have previously completed courses
in data structures and discrete mathematics. Also, they are required to
have working knowledge of Java and C programming languages, as well as
familiarity in using the UNIX operating system.
- The Relational Data Model and Relational Algebra
- Standard Query Language (SQL)
- The Entity-Relationship Data Model
- Database Design Theory
- Database Application Development
- Database Security
- R. Ramakrishnan, J. Gehrke (R&G), Database Management
Systems, 3rd edition, 2002. Available in .pdf form online.
- J. Murach (M), Oracle SQL and PL/SQL for Developers,
2nd edition, 2014. Please purchase a print copy (under $50).
Note: No electronic devices are allowed in open-book exams, so be prepared
to print out parts of online books
Recommended book: just published (on
), covers nearly all of R&G topics, plus newer topics: W.
Lemahieu, S. vanden Broucke, B. Baesens, Principles of Database
, Cambridge U. Press, 2018. Videos
Simple point system. Midterm exam: 100 points, Final exam: 150 points,
Assignments: various, about 100 points total. The exams are
open-print-books, posted solutions, your own assignment papers, closed
Class attendance is strongly encouraged, and students are expected to
participate actively in class by asking and answering questions.
Occasional classes will have "labs", i.e., practice work in class, with
credit for completed papers. In case of missed class, students are
responsible to get up-to-date with course materials and announcements
available at the class web page www.cs.umb.edu/cs630
ACCOMMODATIONS: The University of Massachusetts
Boston is committed to providing reasonable academic accommodations for
all students with disabilities. This syllabus is available in
alternate format upon request. Students with disabilities who need
accommodations in this course must contact the instructor to discuss
needed accommodations. Accommodations will be provided after the student
has met with the instructor to request accommodations. Students must be
registered with the Ross Center for Disability Services, UL 211,
email@example.com , 617.287.7430 before requesting accommodations
from the instructor.
CONDUCT: It is the expressed policy of the University that
every aspect of academic life—not only formal coursework situations, but
all relationships and interactions connected to the educational
process—shall be conducted in an absolutely and uncompromisingly honest
manner. The University presupposes that any submission of work for
academic credit indicates that the work is the student’s own and is in
compliance with University policies. In cases where academic dishonesty
is discovered after completion of a course or degree program, sanctions
may be imposed retroactively, up to and inc
luding revocation of
the degree. Students are required to adhere to the Code of Student Conduct, including
requirements for academic honesty, delineated in the University of
Massachusetts Boston Bulletin, found at: http://www.umb.edu/life
- For R. Ramakrishnan, J. Gehrke, "Database Management Systems",
- For Murach, "Oracle SQL and PL/SQL for Developers", 2nd
Homework 1 Oracle, keys, relational algebra. Due
Wed., Feb. 13 in class, on paper. Solution
Homework 2 Getting started with mysql, foreign
keys, SQL (with subqueries, group by, having) Due Sunday, Mar 3 by
midnight in your cs630/hw2 directory.
Homework 3 RA/SQL Division, Outer Join, E-R,
Views. Due Wed., Apr. 3 in class on paper and files by midnight in
Questions, comments? Visit our Piazza