W18_420-320-VA_Database_I_CourseOutline_MohandChebbine - Copy.pdf

W18_420-320-VA_Database_I_CourseOutline_MohandChebbine - Copy.pdf

  • No School
  • AA 1
  • 4

This preview shows page 1 - 3 out of 4 pages.

Database I Course Outline, Winter 2018 Page 1 / 4 Vanier College Faculty of Science and Technology Computer Science Department Course Title Database I Teacher Mohand Chebbine Course Number 420-320-VA Office D-228 Section 001 & 002 Phone (514) 744-7500 ex. 7669 Ponderation Theory: 3, Lab: 3, Homework: 2 Email through MIO Semester Winter 2018 Office Hours By appointment C OURSE D ESCRIPTION The purpose of this course is to teach relational database concepts, SQL and E-R data modeling. A brief coverage of different database models and a comparison of some existing database management systems e C OURSE O BJECTIVES This course covers the relational database concepts, SQL (Structured Query Language), and data modeling using E-R (Entity-Relationship). Its purpose is not to teach any particular software, but current relational database management systems RDBMS (Oracle) will be used in the labs, mainly for the SQL portion. S TATEMENT OF COMPETENCIES Number Description 016U 016P 0173 0175 017B 017D Carry out an information search Solve Mathematical and Statistical problems relating to computers Develop conceptual models using the structured approach Create and manage a database Design and develop a database application Design and develop a hypermedia application on internal and worldwide networks C OURSE C ONTENT Introduction to databases and database systems The relational database model (tables, entities, attributes and keys) Using Oracle SQL to create tables, define integrity constraints (primary key, foreign key, check, null and unique), drop tables, insert data, modify data, and delete data Using Oracle SQL to query the database (select, conditions, built-in functions, formatting, group functions, joins, set operations, sub-queries) Logical design of relational databases using the Entity Relationship model (E-R diagram), and conversion from E-R diagrams to tables Normalization of database tables and functional dependencies
Image of page 1

Subscribe to view the full document.