What else is there CMPT 454 Database Systems

What else is there? • CMPT 454: Database Systems II. – Transaction Management. – Query Planning. – Optional topics, e. g. data mining, information retrieval, OLAP. • CMPT 470: Web-based Info Systems. – Ch. 7, some of Ch. 6, like Assignment 3. – Major project, often build a web page with database behind it.

Final Exam Points CMPT 354 Spring 2014

Content • Cumulative over course, with emphasis on queries (Ch. 4, 5) and post-midterm material (Ch. 6, 7, 8, 12). • See Lecture Schedule for details in chapters. • Ch. 1 -3 not covered. • Ch. 7 only material covered in the lecture. – E. g. , not css style sheets.

• • • Resources You can bring a cheat sheet, both sheets. No calculators, smartphones, textbook, notes. SQL keywords and such are provided in the exam. Website: – Links to sample exams as well. – Unfortunately, these come with solutions. – Instructions. Textbook: – Review questions. – Half the exercises are on-line with solutions. – Key concepts in bold. Online videos, exam questions, quizzes: try Stanford’s database course http: //class 2 go. stanford. edu/db/Winter 2013 Study Groups. There is no email support. Regular Office Hour next Wednesday.

Instructions • Please bring ID to the exam. • Please bring a pencil. • There will be multiple choice questions with a bubble sheet (centron). • No calculators, smartphones, textbook, notes. • Be on time. • Read the instructions ahead of time – posted on the web.

Post Mortem • You can see your exam grade on courses. cs. sfu. ca when it’s ready. • You can visit with your final exam Wednesday, May 7, 2014, 10: 30 am-12 pm in my office. • That’s the only visitation time. • See syllabus for grade review policy.