CS312 : Database Modeling and Design

Course Overview

Course Synopsis

CS312 offers students an introduction to the design and modeling of database system. The students will cover Fact Finding Techniques, Process of Database Design, Conceptual Data Modeling and Entity Relationship Diagram Overview. Further, students will also cover Introduction to Oracle 11g on Cloud, Using Data Definition Language (DDL) in Oracle 11g, Using Data Manipulation Language (DML) and Data Control Language (DCL) in Oracle 11g.

Course Learning Outcomes

At the end of this course, you should be able to:

  • • State the importance of Data and Information
  • • Analyze the basic structure of Database and recognize the different views of the database.
  • • Draw and investigate Entity Relationship Diagram
  • • Use and experiment common Oracle 11g statements
  • • Explain the terms Transaction Processing and Concurrency Control


Course Calendar

TopicLectureResourcePage
Introduction to Data and Information.1PPTX
Data Storage Mechanisms2PPTX
3-Tier Architecture and Process to Database Design3PPTX
Fact Finding Techniques4PPTX
Implementing Fact Finding Techniques5PPTX
Assignment No. 1
Process of Database Design6PPTX
Relational Database7PPTX
Conceptual Data Modeling and Entity Relationship Diagram Overview8PPTX
Entities, Attributes and Relationship9PPTX
Quiz No. 1
Extended Entity Relationship Diagram (EERD)10PPTX
Example of Entity Relationship Diagram11PPTX
Assignment No. 2
Mid term Examination
Anomalies12PPTX
Normalization13PPTX
Denormalization14PPTX
Introduction to Oracle 11g on Cloud15PPTX
Using Data Definition Language (DDL) in Oracle 11g16PPTX
Using Data Manipulation Language (DML) and Data Control Language (DCL) in Oracle 11g17PPTX
Structured Query Language basics18PPTX
Advanced SQL19PPTX
Quiz No. 2
Examples of SQL20PPTX
Graded Discussion Board
Database Views and Data Dictionaries in Oracle 11g21PPTX
Introduction to Sequence and Synonyms with implementation in Oracle 11g22PPTX
VIVA
Indexes in Databases23PPTX
Implementing Indexes in Oracle 11g24PPTX
Transactions and Concurrency Problems in Databases25PPTX
Locks and granularity in Databases.26PPTX
Final Term Examination
Note: This is tentative schedule and subject to change.
 
 
Back to Top