CS312 - Database Modeling and Design
Course Page
Mcqs
Q & A
Video
Downloads
Course Category: Computer Science/Information Technology
Course Level: Undergraduate
Credit Hours: 3
Pre-requisites: N/A

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 Contents

Introduction to Data and Information, Data Storage Mechanisms, 3-Tier Architecture and Process to Database Design, Fact Finding Techniques, Implementing Fact Finding Techniques, Process of Database Design, Relational Database, Conceptual Data Modeling and Entity Relationship Diagram Overview, Entities, Attributes and Relationship, Extended Entity Relationship Diagram (EERD), Example of Entity Relationship Diagram, Anomalies, Normalization, Denormalization, 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, Structured Query Language basics, Advanced SQL, Examples of SQL, Introduction to Sequence and Synonyms with implementation in Oracle 11g, Indexes in Databases Implementing Indexes in Oracle 11g, Transactions and Concurrency Problems in Databases, Locks and granularity in Databases.
Course Instructor

Sheraz Pervaiz
MS in Software Technology Stuttgart University of Applied Sciences, Germany
Books

Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke

Database Modeling and Design by Toby Teory, Sam Lightstone, Tom Nadaeu, H.V.Jagadish

Database System by Thomas Connolly and Carolyn Beg

Database System Concepts by Silberschatz-Korth-Sudarshan

Data Modeling and Relational Database Design by Jan Speelpenning, Patrice Daux, Jeff Gallus

Oracle Database 11g: A Beginners Guider by Ian Abramson, Michael Abbey, Michael J Corey and Michelle Malche

Oracle Database 11g: SQL Fundamentals by Salome Clement, Brian Pottle, Puja Singh