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 Summer 2016
Content • Focuses on material after midterm: – – – queries (SQL, RA) application development HTML, XPath, object exchange model file organization, file access methods Evaluating RA operators (join, selection, projection) • See Lecture Schedule for details in chapters. • Not covered: database design, ER diagram, creating schemas, database functionality. • Application Development, Query Planning: only material covered in the lecture. – E. g. , not css style sheets, not query optimization.
• • 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. – Other resources like Stanford database course Textbook: – Review questions. Study Groups. There is no email support. Regular Office Hour next Thursday.
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. • Go to the bathroom before the exam • Read the first two pages 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, July 19, 2016, 10: 30 am-12 pm in my office. • That’s the only visitation time. • See syllabus for grade review policy.
- Slides: 6