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
|
|
|
Week 01
|
3
|
Definition of Information
|
|
5
|
Comparison of Data and Information
|
|
6
|
Example-1 and 2 to elaborate difference between Data and Information
|
|
7
|
Life with and without Database
|
|
8
|
Benefits of using Database
|
|
9
|
Why Database not Information Base
|
|
10
|
Difference between Database and Database Management System with Example
|
|
11
|
Example of Difference between Database and Database Management System
|
|
12
|
Component of Database Management System
|
|
16
|
Hierarchal Databases Basics
|
|
17
|
How Hierarchal Database Work
|
|
19
|
How Network Data Model Work
|
Week 02
|
20
|
Introduction of Three Tier- Architecture
|
|
21
|
Rationale for Three-Tier Architecture
|
|
22
|
External Level (Client Interface)
|
|
23
|
Conceptual Level (Business Logic)
|
|
24
|
Internal Level (Data Level)
|
|
26
|
Example: Presentation Layer of Independence
|
|
27
|
Examples-1 of Logical Layer Independence
|
|
28
|
Example of Data Layer Independence
|
|
29
|
Roles in Database Management System
|
|
30
|
Client Server Architecture
|
|
31
|
Example of Client Server Architecture
|
|
32
|
Distributed Processing
|
|
33
|
Example of Distributed Processing
|
|
34
|
Examine Document Basics
|
|
35
|
Documenting Examine Document
|
|
36
|
Conducting Interview: Basics
|
|
38
|
Example of Types of Interview
|
|
39
|
Observe the enterprise in operation
|
|
40
|
Have and Have Not’s for Observing
|
Week 03
|
43
|
Examples of creating Questionnaires
|
|
44
|
From Fact-finding to Requirement Writing
|
|
45
|
Example of translating Interview to Requirements
|
|
46
|
Example of translating Questionnaire to Requirements
|
|
47
|
Defining System Definition from Requirements-I
|
|
48
|
Defining System Definition from Requirements-II
|
|
49
|
Process of extracting System Definition
|
|
50
|
Motivation for Requirements
|
|
51
|
Major Challenges in Requirements
|
|
52
|
Attributes of Siftware Requiremnets-Verifiable
|
|
53
|
Attributes of Software Requiremnets-Completeness
|
|
54
|
Attribute of Software Requirements-Consistent
|
|
55
|
Attribute of Software Requiremnets-Traceability
|
|
56
|
Requirement Engineering Discipline
|
|
57
|
Requirement Engineering
|
|
58
|
Example of Requirement Management
|
|
59
|
Requiremnet Development
|
|
60
|
Requirement Elicitation
|
|
61
|
Project Business Requirement
|
|
62
|
Example of Project Business Requirement
|
|
64
|
Defining Quality Metric[Ileitis]
|
|
65
|
Example of Reliability
|
|
67
|
Example of User Friendliness
|
|
69
|
Requirement Prioritization
|
|
70
|
Requirement Specification
|
Quiz No.01
|
71
|
Requirement Verification
|
|
72
|
Inspect Requirement Specification
|
Assignment No.1
Week 04
|
74
|
Rule-1: Information Rule
|
|
75
|
Rule-2: Guaranteed Access
|
|
76
|
Rule-3: Systematic Handling of Null
|
|
77
|
Example Rule-3: Systematic Handling of Null
|
|
78
|
Rule-4: Active Online Catalogue
|
|
79
|
Rule-5: Powerful Language
|
|
80
|
Example Rule-5: Powerful Language
|
|
81
|
Rule-6: View Updation Rule
|
|
82
|
Rule-7: Relational Level Operation
|
|
83
|
Rule-8: Physical Data Independence
|
|
84
|
Rule-9: Logical Data Independence
|
|
85
|
Rule-10: Integrity Independence
|
|
86
|
Rule-11: Distribution Independence
|
|
87
|
Rule-12: Non-Subversion Rule
|
|
89
|
Database Schema with Example
|
|
91
|
Structured Query Language
|
|
92
|
Data Definition Language(DDL)
|
|
93
|
Data Manipulation Language(DML)
|
|
94
|
Data Control Language(DCL)
|
|
95
|
Data Retrieval language(DRL)
|
Week 05
Quiz No.02
|
101
|
Process to Create ERD
|
|
102
|
Extracting Entities from Scenario
|
|
103
|
Extracting Attributes from Scenario
|
|
105
|
Identifying Primary Key from Sample Requirement
|
|
107
|
Extracting Super Key from Scenario
|
|
109
|
Extracting Unique Key from Scenario
|
Week 06
|
112
|
Example of Foreign Key
|
|
113
|
Composite Primary Key(CPK)
|
|
114
|
Example of Composite Key
|
|
116
|
Optionality with Example
|
|
117
|
Cardinality with Example
|
|
120
|
Example of One-to-Many
|
|
124
|
Example of One-to-One
|
|
125
|
Referential Integrity Constraint
|
|
128
|
Example of Cascade Delete
|
|
130
|
Example of Cascade Update
|
|
131
|
Restrict Delete and Update
|
|
133
|
Example-1: Scenario and Generating ERD
|
|
134
|
Example-1: Generating Physical Models from ERD
|
|
135
|
Example-2: Scenario and Generating ERD
|
|
136
|
Example-2: Generating Physical Models from ERD
|
|
137
|
Example-3: Scenario and Generating ERD
|
|
138
|
Example-3: Generating Physical Models from ERD
|
GDB
Week 07
|
140
|
Why Anomalies are Critical
|
|
147
|
Example of Super Type and Subtype
|
|
149
|
Example of Exhaustive
|
|
151
|
Example of Mutually Exclusive
|
Week 08
|
154
|
Normalization Through Reports
|
|
161
|
Example of Normalization
|
|
162
|
Example of Normalization-2NF
|
|
163
|
Example of Normalization-3NF
|
Week 09
|
164
|
What is Denormalization
|
|
165
|
Need for Denormalization
|
|
166
|
Normalization Vs Denormalization
|
|
169
|
Storing Detail in Master
|
|
170
|
Example of Storing Detail in Master
|
|
172
|
Example of Short-Circuit Key
|
|
173
|
Current Indicator Column
|
|
174
|
Example of Current Indicator Column
|
|
175
|
Storing Calculating Value
|
|
176
|
Example of Storing Calculating Value
|
Week 10
|
177
|
Oracle 11g on Cloud: Introduction
|
|
178
|
Oracle 11g on Cloud: Login Creation on Cloud
|
|
179
|
Oracle 11g on Cloud: Login to Cloud
|
|
180
|
Oracle 11g on Cloud: Exploring the Cloud
|
|
182
|
Creating Single Table
|
|
183
|
Creating Table with Foreign Key
|
|
184
|
Describing a Table and SQL *Plus
|
|
185
|
Alter Table and Describing the Change
|
|
186
|
Implementing Delete Cascade Cascading
|
Week 11
|
188
|
Insert Statement Syntax
|
Quiz No.03
|
189
|
Implementing Insert Statement
|
|
190
|
Viewing Data from Table
|
|
191
|
Limited Column Data Insertion
|
|
193
|
Implementing Single Column Update Statement
|
|
194
|
Implementing Multiple Column Update Statement
|
|
195
|
Delete Statement Syntax
|
|
196
|
Implementing Delete Statement
|
Assignment No.2
Week 12
Quiz No.04
|
205
|
Implementing SQL and WHERE Clause
|
|
206
|
SQL and Logical Operators
|
|
207
|
Implementing Logical Operator 01
|
|
208
|
Implementing Logical Operator 02
|
|
209
|
Wildcard Characteristics in SQL
|
|
212
|
Implementing Like – 01
|
|
213
|
Implementing Like – 02
|
|
215
|
Implementing IN Operator
|
|
217
|
Implementing BETWEEN Operator
|
|
219
|
Implementing Single Row Function
|
|
220
|
Group or Multiple Row Function
|
|
221
|
Implementing: Group Functions
|
|
223
|
Implementing GROUP BY Clause 01
|
|
224
|
Implementing GROUP BY Clause 02
|
|
226
|
Implementing HAVING Clause – 1
|
|
227
|
Implementing HAVING Clause – 2
|
|
230
|
Implementing Date Manipulation
|
Week 13
|
233
|
Cartesian Product & Joins
|
|
237
|
Implementing Self-Joins - I
|
|
238
|
Implementing Self-Joins - II
|
|
241
|
Implementing Left Outer Join
|
|
243
|
Implementing Right Outer Join
|
|
245
|
Implementing Subqueries
|
Week 14
|
249
|
Writing Complex Views
|
|
250
|
Data Dictionary Concepts
|
|
251
|
Using Data Dictionary Concepts
|
|
252
|
Data Dictionary and Views
|
|
253
|
Motivation for sequence
|
|
255
|
Implementing Sequence:
|
Week 15
|
258
|
Searching Using Index
|
|
259
|
Creating Index in Oracle
|
|
260
|
Indexes and Data Dictionary
|
|
262
|
Atomicity Property of Transaction
|
|
266
|
Concurrent Transaction
|
Week 16
|
|
|