DATABASE MANAGEMENT SYSTEM ORACLE SQL AND PL/SQL

1
DATABASE MANAGEMENT SYSTEM ORACLE SQL AND PL/SQL
Teaching Aid Material To be used along the
book The author invites your valuable feedback
and suggestions on the book p k d a s g u p t a _at_
g m a i l . c o m
2
DATABASE MANAGEMENT SYSTEM ORACLE SQL AND
PL/SQLPeriods Proposed relevant to each Chapter
Chapter 1 Page 1 to 21 Database Basics, System Analysis Design, Data Flow Diagram ER Model Model 2 Periods
Chapter 2 Page 22 to 50 Relational Algebra And Normal Forms 4 Periods
Chapter 3 Page 51 to 84 Query Processing, File Organization, Distributed Processing Data Mining 5 Periods
Chapter 4 Page 85 to 108 Transaction Processing, Concurrency Control, Oracle Architecture, Backup And Recovery 5 Periods
Chapter 5 Page 109 to 156 SQL Basics, Functions, Sub Query Joins 1 Period Theory 3 Periods Practical
Chapter 6 Page 157 to 200 Data Manipulation Language, Objects, Constraints And Security In Oracle 1 Period Theory 3 Periods Practical
Chapter 7 Page 201 to 220 Oracle PL/SQL Basics 1 Period Theory 3 Periods Practical
Chapter 8 Page 201 to 236 Function, Procedure And Package 1 Period Theory 3 Periods Practical
Chapter 9 Page 237 to 255 Oracle Exception Handler, Database Triggers And Implicit Cursor 1 Period Theory 3 Periods Practical
Chapter 10 Page 256 to 285 Explicit Advance Cursors 1 Period Theory 3 Periods Practical
3
DATABASE MANAGEMENT SYSTEM ORACLE SQL AND
PL/SQL Important Guidelines to the Faculty/
Instructor
Chapter 1 Page 1 to 21 Majority of the Figures included in the Teaching Aid Material. Please elaborate SDLC and ER Model preferably on the Black Board.
Chapter 2 Page 22 to 50 Majority of the Figures/ Tables included in the Teaching Aid Material. Please proceed slow and ensure students understand NFs and related concepts.
Chapter 3 Page 51 to 84 Majority of the Figures/ Tables included in the Teaching Aid Material. Please illustrate the text relevant to the example from the book on the Black Board. Simultaneously show the relevant figure/ table included in the Teaching Aid Material using LCD projector.
Chapter 4 Page 85 to 108 Majority of the Figures/ Tables included in the Teaching Aid Material. Please illustrate the text relevant to the example from the book on the Black Board. Simultaneously show the relevant figure/ table included in the Teaching Aid Material using LCD projector.
Chapter 5 Page 109 to 156 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.
Chapter 6 Page 157 to 200 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.
Chapter 7 Page 201 to 220 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.
Chapter 8 Page 201 to 236 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.
Chapter 9 Page 237 to 255 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.
Chapter 10 Page 256 to 285 Quickly cover the theory using the Teaching Aid Material. Please discuss examples provided in the book. Use of LCD Projector for demonstration of examples are extremely useful. Kindly ensure that students do hands-on to achieve maximum benefit from the book.