Log In / Register

Virtual University of Pakistan

Find Course


Featured Courses


CS312 : Database Modeling and Design

I like this Course

Course Info

Course Category

 Computer Science/Information Technology

Course Level

 Undergraduate

Credit Hours

 3

Pre-requisites

 N/A

Instructor

 Sheraz Pervaiz
MS ( Software Technology)
University of Applied Sciences Stuttgart

Course Contents

Definition of data Example of Data Definition of information Example of information Comparison of Data and Information Example-1 and 2 to elaborate difference between Data and Information Life with and without Database Benefits of using Database Why Database not Information Base? Difference between Database and Database Management System with Example Example of Difference between Database and Database Management System Component of Database Management System Data Model Basics Flat File Basics How Flat File Works? Hierarchical Database Basics How Hierarchal Database Work? Network Database Basics How Network Data Model Work? Introduction of Three Tier- Architecture Rationale for Three-Tier Architecture External Level (Client Interface) Conceptual Level (Business Logic) Internal Level (Data Level) Layer Independence Example: Presentation Layer of Independence Examples-1 of Logical Layer Independence Example of Data Layer Independence Roles in Database Management System Client Server Architecture Example of Client Server Architecture Distributed Processing Example of Distributed Processing Examine Document Basics Documenting Examine Document Conducting Interview: Basics Types of Interview Example of Types of Interview Observe the enterprise in operation Have and Have Not’s for Observing Research Basics Questionnaire Examples of creating Questionnaires From Fact-finding to Requirement Writing Example of translating Interview to Requirements Example of translating Questionnaire to Requirements Defining System Definition from Requirements-I Defining System Definition from Requirements-II Process of Extracting System Definition Motivation for Requirements Major Challenges in Requirements Attributes of Software Requirements-Verifiable Attributes of Software Requirements-Completeness Attributes of Software Requirements-Consistent Attributes of Software Requirements-Traceability Requirement Engineering Discipline Requirement Engineering Example of Requirement Management Requirement Development Requirement Elicitation Project Business Requirement Example of Project Business Requirement Get User Involvement Defining Quality Metric[Ileitis] Example of Reliability Example of Robustness Example of User Friendliness Requirement Analysis Requirement Prioritization Requirement Specification Requirement Verification Inspect Requirement Specification Bugs and Defects Rule-1: Information Rule Rule-2: Guaranteed Access Rule-3: Systematic Handling of Null Example Rule-3: Systematic Handling of Null Rule-4: Active Online Catalogue Rule-5: Powerful Language Example Rule-5: Powerful Language Rule-6: View Updation Rule Rule-7: Relational Level Operation Rule-8: Physical Data Independence Rule-9: Logical Data Independence Rule-10: Integrity Independence Rule-11: Distribution Independence Rule-12: Non-Subversion Rule Database Schema Database Schema with Example Introduction to Keys Structured Query Language Data Definition Language(DDL) Data Manipulation Language(DML) Data Control Language(DCL) Data Retrieval language(DRL) Concept of ERD Components of ERD Entity Attributes Relationships Process to Create ERD Extracting Entities from Scenario Extracting Attributes from Scenario Primary Key Identifying Primary Key from Sample Requirement Super Key Extracting Super Key from Scenario Unique Key Extracting Unique Key from Scenario Candidate key Foreign key Example of Foreign Key Composite Primary Key(CPK) Example of Composite Key Relationships Optionality with Example Cardinality with Example Basic Relationships One-to-Many Relationship Example of One-to-Many Relationship Many-to-Many Relationship Example Many-to-Many Relationship One-to-One Relationship Example of One-to-One Relationship Referential Integrity Constraint Cascading Cascade Delete Example of Cascade Delete Cascade Update Example of Cascade Update Restrict Delete and Update Surrogate Key Example-1: Scenario and Generating ERD Example-1: Generating Physical Models from ERD Example-2: Scenario and Generating ERD Example-2: Generating Physical Models from ERD Example-3: Scenario and Generating ERD Example-3: Generating Physical Models from ERD What is Anomaly? Why Anomalies are Critical? Insert Anomaly Delete Anomaly Update Anomaly Neer for EERD Super Type Sub Type Example of Super Type and Subtype Exhaustive Example of Exhaustive Mutually Exclusive Example of Mutually Exclusive Example of EERD Normalization Basics Normalization Through Reports 1st Normal Form(1NF) Example of 1NF 2nd Normal Form(2NF) Example of 2NF 3rd Normal Form(3NF) Example of 3NF Example of Normalization Example of Normalization-2NF Example of Normalization-3NF What is Denormalization? Need for Denormalization Normalization Vs Denormalization When to Denormalize? Storing End Date Storing Detail in Master Example of Storing Detail in Master Short-Circuit Key Example of Short-Circuit Key Current Indicator Column Example of Current Indicator Column Storing Calculating Value Example of Storing Calculating Value Oracle 11g on Cloud: Introduction Oracle 11g on Cloud: Login Creation on Cloud Oracle 11g on Cloud: Login to Cloud Oracle 11g on Cloud: Exploring the Cloud Create Table Syntax Creating Single Table Creating Table with Foreign Key Describing a Table and SQL *Plus Alter Table and Describing the Change Implementing Delete Cascade Cascading Drop Table Insert Statement Syntax Implementing Insert Statement Viewing Data from Table Limited Column Data Insertion Update Table Syntax Implementing Single Column Update Statement Implementing Multiple Column Update Statement Delete Statement Syntax Implementing Delete Statement Truncate Table Transaction Basics Commit Statement Rollback Statement SQL SQL Syntax Implementing SQL SQL and WHERE Clause Implementing SQL and WHERE Clause SQL and Logical Operators Implementing Logical Operator 01 Implementing Logical Operator 02 Wildcard Characteristics in SQL Like Operator in SQL LIKE Syntax Implementing Like – 01 Implementing Like – 02 IN Operator Implementing IN Operator BETWEEN Operator Implementing BETWEEN Operator Single Row Function Implementing Single Row Function Group or Multiple Row Function Implementing: Group Functions GROUP BY Clause Implementing GROUP BY Clause 01 Implementing GROUP BY Clause 02 HAVING Clause Implementing HAVING Clause – 1 Implementing HAVING Clause – 2 ORDER BY Clause Date Handling Implementing Date Manipulation Date Functions Cartesian Product Cartesian Product & Joins Join or Inner Join Join Example Self-Join Implementing Self-Joins - I Implementing Self-Joins - II Outer Join Left Outer Join Implementing Left Outer Join Right Outer Join Implementing Right Outer Join Subquery Basics Implementing Subqueries Motivation for Views Syntax of a View Writing Views Writing Complex Views Data Dictionary Concepts Using Data Dictionary Concepts Data Dictionary and Views Motivation for sequence Syntax of Sequence Implementing Sequence: Sequence & DML Index Basics Searching Using Index Creating Index in Oracle Indexes and Data Dictionary Transaction Basics Atomicity Property of Transaction Consistency Isolation Durability Concurrent Transaction Lost Update Problem Uncommitted Data Rationale for Lock Lock Basics Granularity of Locks Level of Locks Deadlock Deadlock Prevention Deadlock Detection
facebook        facebook        facebook
  

© 2011 Virtual University of Pakistan.
Developed by IT Department, Virtual University of Pakistan.