Course outlinee PDF

Preview

Summary

Download Course outlinee PDF

Description

University*of*Ottawa* * School*of*Electrical** Engineering*and*Computer*Science* Faculty*of*Engineering* * CSI2132*Databases*I! Winter*2019* Course*Outline*

Taught*by* Professor: ! !

!Verena!Kantere! !Office:!SITE!5!060 Email: [email protected]

TAs:! CSI2132A! Mr!Di,[email protected]! Mr!Muktineni,[email protected]! Mr!Parthiban,[email protected]!

CSI2132B! Mr!Hou,[email protected]! Mrs!Mediratta,[email protected]! Mr!Dharuman,[email protected]!

!

1

Taught at

Taught at

2

Course*Goal

!

!The!goal!of!this!course!is!to!introduce!the!students!to!basic! topics!of!data!management.!If!we!have!time!we!will!also! discuss!some!modern!topics!of!broad!data!management.

!

Course curriculum The course curriculum is: 1. Introduction to databases/overview 2. Entity Relationship model 3. Relational model 4. Relational algebra and relational calculus 5. The query language SQL 6. Database normalisation (normal forms and functional dependencies) 7. Physical organisation and storage 8. Hashing and indexing

3

Literature Basic!Reading:! !  Database Management Systems,! ◦  Ramakrishnan & Gehrke ! 

!Database System Concepts,!Sixth Edition, ◦  Silberschatz,!Korth &!Sudarshan

! 

A First Course in Database Systems, 3nd Edition ◦  Jeff Ullman, and Jennifer Widom.

! 

(Database Systems:The Complete Book, ◦  Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom)

Expected*Outcomes*of*the*Course !

! 

A solid knowledge of the basic data management theoretical issues and solutions

A solid knowledge of SQL !  Installing and operating a DBMS ! 

Creating and querying a database !  Creating a web application on top of a database ! 

4

Evaluation .!

Grading! Midterm ! Assignment ! !  Course!project !  Final!exam! ! !  ! 

! ! ! !

!10% !10% !30% !50%

!!

Requirements!for!success!in!the!course:! (i)!More!than!50%!of!the!grade!in!the!midterm!exam! (ii)!More!than!50%!of!the!grade!in!the!final!exam !  (iii)!More!than!60%!of!the!grade!in!the!course!project! !  ! 

Course Project In pairs (i.e. two students together) you will have to design and implement a database and develop a web application on top of it, for which we will give you the requirements. You will have to submit: 1st part: 1.  The ER model 2.  The relational model The implemented database 2nd part: 1.  The web application 2.  Queries/triggers/views etc on the database needed for the functionality of the database 3. 

5

Tentative Calendar Midterm on ER, relational model and relational algebra Possibly the week of 4-7 February 1st and 2nd part of the project: Announced end of January 1st part : Deadline for submission middle of February 2nd part : Deadline for submission end of March Assignment on normalization and other material (possibly hashing and indexing): announced beginning of March and deadline for submission at the end of courses.

6...