Course Objectives
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.
Prerequisites
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.
Topics Covered
- The Relational Data Model and Relational Algebra
- Standard Query Language (SQL)
- The Entity-Relationship Data Model
- Database Design Theory
- Database Application Development
- Database Security
Textbooks
- 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 being published (available
9/30/18
on
Amazon), covers nearly all of R&G topics, plus newer topics: W.
Lemahieu, S. vanden Broucke, B. Baesens,
Principles of Database
Management, Cambridge U. Press, 2018.
Videos
Grading
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
electronic devices.
Attendance Policy
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,
www.ross.center@umb.edu , 617.287.7430 before requesting accommodations
from the instructor.
ACADEMIC
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 including 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
on_campus/policies/community/code.
Textbook Resources:
- For R. Ramakrishnan, J. Gehrke, "Database Management Systems",
3rd edition.
- For Murach, "Oracle SQL and PL/SQL for Developers", 2nd
edition:
Homework Assignments:
Homework 1 Oracle, keys, relational algebra. Due
Monday, Sept. 24 in class, on paper.
Solution
Homework 2 Mysql, foreign keys, SQL (including with
subqueries, group by, having) Due Tues., Oct. 9 by midnight in your
cs630/hw2 directory.
Solution
Homework 3 RA/SQL Division, Outer Join,
E-R, Views. Files due by midnight Tues., Oct. 30, paper by class, Wed.,
Oct. 31.
Solution (
files)
Homework 4 JDBC. Files due by midnight Tuesday,
Nov. 27
Solution files (
zip)
Homework 5 More JDBC, also PL/SQL Files due by
midnight Wed., Dec. 5
Solution files (
zip)
Homework 6 FDs, Normalization, Authorization
(GRANT command). Due in class Wed., Dec. 12 (
Solution)
Piazza
Site: post your questions here