Course ObjectivesThe 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.
PrerequisitesStudents 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/Linux operating system.
- The Relational Data Model and Relational Algebra
- Standard Query Language (SQL)
- The Entity-Relationship Data Model
- Database Design Theory
- Database Application Development: JDBC and PL/SQL
- Database Security
- If time, intro to GraphQL, a new query language
TextbooksR. Ramakrishnan, J. Gehrke (R&G), "Database Management Systems", 3rd edition. Available in .pdf.
J. Murach (M), "Oracle SQL and PL/SQL for Developers", 2nd edition. 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
GradingSimple 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 PolicyClass 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 (completed in that class period). 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.
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, firstname.lastname@example.org , 617.287.7430 before requesting accommodations from the instructor.