Summer 2019 - CMPT 354 D100
Database Systems I (3)
Class Number: 4800
Delivery Method: In Person
Course Times + Location:
Tu 1:30 PM – 2:20 PM
AQ 3181, Burnaby
Th 12:30 PM – 2:20 PM
SSCB 9200, Burnaby
Exam Times + Location:
Aug 12, 2019
12:00 PM – 3:00 PM
RCB IMAGTH, Burnaby
Instructor:Ouldooz Baghban Karimi
Prerequisites:CMPT 225, and (MACM 101 or (ENSC 251 and ENSC 252)).
Logical representations of data records. Data models. Studies of some popular file and database systems. Document retrieval. Other related issues such as database administration, data dictionary and security.
Introduction to the principles, concepts, approaches, tools, and methodology of database design and implementation, and Database Management Systems. Covers theoretical foundations and practical languages for relational databases, their implementation, use and optimization.
- Relational Data Model
- Relational Algebra
- Constraints and Triggers
- Database Applications
- Advanced Topics
Assignments (20%) Quizzes (10%) Midterm (20%) Final (50%)
- A First Course in Database Systems, Ullman, Widom, Pearson, 2007, 9780136006374, Edition
- Database Management Systems, Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2003, 9780072465631, 3rd Edition
- Database Systems: The Complete Book , Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom, Prentice Hall , 2009, 9780131873254, 2nd Edition
SFU’s Academic Integrity web site http://www.sfu.ca/students/academicintegrity.html is filled with information on what is meant by academic dishonesty, where you can find resources to help with your studies and the consequences of cheating. Check out the site for more information and videos that help explain the issues in plain English.
Each student is responsible for his or her conduct as it affects the University community. Academic dishonesty, in whatever form, is ultimately destructive of the values of the University. Furthermore, it is unfair and discouraging to the majority of students who pursue their studies honestly. Scholarly integrity is required of all members of the University. http://www.sfu.ca/policies/gazette/student/s10-01.html
ACADEMIC INTEGRITY: YOUR WORK, YOUR SUCCESS