DBMS

CMP 226.3 (Credit hours 3, Practical 3)

Database Management System

BCA, Second Year, Fourth Semester

Course Objectives:

This course introduces the fundamental concepts and implementations of the relational database system in enterprise. Students will be exposed to file organization and secondary stroage structures, relational model and relational database systems. These are followed by database design Entity-Relationship models, transactions, concurrency recovery and SQL methodology.

Course Contents:

1. Operating system Overview                                                                                              3 hours

Introduction to Database management system, Brief History of Database Management system Approach, components of a database management system, leading Commercial Database. 

2. Designing a Database                                                                                                         5 hours

Introduction, the Feasibility study, Designing systems, Identifying user requirements Designing systems with E-R Diagram, UML Clas Diagrams, Classes and Entities, Associations and times, Binary Objects, Computed values; Events

3. Data Normalization                                                                                                            6 hours

Introduction, Tables, Classes, and Keys, First Normal form, Second Normal Form, Third Normal form, Beyond Third Normal from, Data Rules and Integrity, Business Rules and Its effects, converting a class Diagram to Normalized Tables, Data Dictionary

4. Queries in Database                                                                                                           3 hours

Introduction, Creating a Query, Computations, Multiple Tables: Joining Tables, Identifying, Columns in Different Tables, Joining Many Tables, Hints on Joining Tables, Table Alias, Creating a View

5. Advanced Queries in Database                                                                                         6 hours

Introduction, Sub queries, More features and Tricks with SQL SELECT: Outer Joins, UNION, INTERSECT, EXCEPT, Multiple join Columns, Reflexive join, CASE Function, Inequality joins, Cross Tabulation, Questions with "Every" Need the EXISTS clause, SQL SELECT summary; SQL Data Definition Commands, SQL Data Manipulation Commands: INSERT and DELETE, UPDATE

6. Physical design                                                                                                                   5 hours

Introduction, Physical Data Storage, Data Storage Methods, Data Clustering and Partitioning

7. Database Administration                                                                                                   7 hours

Introduction, Data Administration, Database Administration, Database Tasks by Development Stages, Database Application Types: On Line Transaction Processing, On-Line Application Processing, Data Warehouses and Data Mining; Backup and Recovery, Security and Privacy: Data Privacy Threats, Physical security, Managerial controls, Logical security; Encryption

8. Distributed Database System                                                                                            6 hours

Introduction, Distributed Databases, Client/Server Databases, Client/sever versus File server, Brief Introduction to data Assess API (ODBC, DB Library, DAO, ADO, JDBC, OLEDB), Three-Tier Client/Server Model, The Back End: server Databases, The Web as a Client/Server System.

9. Objected oriented database and integrated applications                                                7 hours

Introduction, Data Types and Objects, Object-Oriented Databases and SQL3, Integrated Application, Microsoft DCOM and CORBA, Storing objects in the Database

Text Book:

1. Gerald V.Post: Database Management Systems, McGraw Hill International Edition.