Transcription
CS 638Principles of DatabaseManagement & UseM. Tamer Özsutamer.ozsu@uwaterloo.ca
CS 638nnThis is an online course that will be run on the flippedclassroom model – course lecture videos will be online andwe will have regular online meetingsWeekly meeting times – may change so chackannouncementsqnnYou cannot get by just by listening to the lectures; the bookmaterial is an important component – you need to read therelevant parts of the book.Please make sure you do not fall behind; you will need topace yourself.qCS 638Fridays 11:00AM-12:00noon Eastern timeThe weekly schedule that you should follow and the readingmaterial is on the course site and later in these slides2
Getting helpnWe use LEARNqqnWhen you register and get into LEARN, you should see CS638in your list of courseshttps://learn.uwaterloo.caMessaging forumqqqqAsk public questions hereAssignments and solutions postedAnnouncements postedQuizzes and exams through LEARN as wellnnCS 638They will be open for a few daysOnce you start, you will have to finish in a given period of time(exams usually 2-3 hours; quizzes in about half hour)3
Course objectives“A user-oriented approach to the management of largecollections of data. Relational database technology, relationalalgebra, SQL, database views, transactions, data modellingmethodology, entity-relationship models. Introduction toseveral current topics in database research, such aswarehousing, data mining, managing data streams, datacleaning, data integration, and distributed/parallel databases.Master of Health Informatics students only.” CS 638Use database terminology knowledgeablyUnderstand DB concepts that arise in the workplaceInteract with (direct, understand) IT personnelUnderstand technical articles involving DB technology4
Course ContentnnnnnnnnnnnnnnnCS 638Introduction to database systemsRelational data modelSQL (ad hoc queries)Relational algebraEntity-Relationship (ER) modelExtended ER modelMapping ER models to relationalDesign theory: normalizationTransactionsDatabase security and privacyDistributed databasesParallel databasesData warehousesNoSQL systemsStreaming data managementRelational databaseprinciplesData modelingDBMS useAdvanced topics5
Course ScheduleWeekModuleTopicReadings (7e)Readings (6e)1 (8 Sep)0Introduction to the Course2 (12 Sep)1Introduction to Database Man.1,21,23 (19 Sep)2Relational Data Model533Relational Algebra8 (8.1-8.5)6 (6.1-6.5)4 (26 Sep)4Basic SQL645 (3 Oct)4aAdvanced SQL756 (10 Oct)5Conceptual Modeling: ER Model375aConceptual Modeling: EnhancedER Model486Logical Modeling: ER-to-RelationalMapping997Design Theory: Normalization14 (14.114.3,14.5)15 (15.115.3,15.5)7 (17 Oct)8 (24 Oct)CS 638Exam 16
Course Schedule (cont’d)WeekModuleTopicReadings (7e)Readings (6e)9 (31Oct)8Transactions and TransactionSupport in SQL202110 (7 Nov)9Database Security & Privacy302410Data Warehouses & DecisionSupport292911Distributed Database Systems232512Parallel Database Systems13NoSQL Systems14Streaming Data Management11 (14 Nov)12 (21 Nov)13 (28 Nov)Free for review and catchup9-10 DecFinal ExamCS 63822&237
Textbook (Recommended)nnnCS 638R. Elmasri and S. Navathe, Fundamentals of DatabaseSystems, 7/E, Pearson, 2016, or6/E, Addison Wesley, 2010.Note: Course notes adapted from authors’ book slides8
MarkingnnnnAssignments (4)QuizzesExam 1Final ExamqCS 63820%15%25%40%comprehensive9
Principles of Database Management & Use M. Tamer Özsu tamer.ozsu@uwaterloo.ca. CS 638 n This is an online course that will be run on the flipped classroom model – course lecture videos will be online and we wil
