Fundamentals of Database Management System and RDBMS

Module I

Database System concepts and applications Introduction to databases, File Systems vs DBMS, Advantages and Disadvantages of using DBMS Approach, Database administrators and user, Data Models, Schemas, and Instances, Types of Data Models, Three Schema Architecture and Data Independence, Database Languages and Interfaces. Conceptual Data Models for Database Design Entity Relationship Models, Concept of Entity, Entity Sets, Relationship Sets, Attributes, Domains,Constraints, Keys, Strong and Weak Entities. Concepts of EER

Module II

Relational Data Model Relations, Domains and Attributes, Tuples, Keys. Integrity Rules, Relational Algebra and Operations, Relational Calculus and DomainCalculus. Relational Database Design using ER to Relational Mapping. SQL Data Definition in SQL creation, updation , deletion of tables, modifying the structure of tables, renaming, dropping of tables. Constraints. Database Manipulation in SQL Select command, Logical operators, Range searching, Pattern matching, Grouping data from tables in SQL, GROUP BY, HAVING clauses, Joins Joining Multiple Tables, Joining a Table to itself. Views Creation, Renaming the column of a view, destroys view.

Module III

Relational database design Anomalies in a Database, Normalization Theory,Functional Dependencies. First, Second and Third Normal Forms, Relations with more than one Candidate Key, Good and Bad Decompositions, Boyce Codd Normal Form, Multivalued Dependencies and Fourth Normal Form, Join Dependencies and Fifth Normal Form.

Module IV

Transaction Management and Concurrency Control Transaction Properties(ACID), states, Commit, Rollback; Concurrency ControlLost update problems, Locks, two phase locking.

Module V

Programming with SQL: Data types, Using set and select commands, procedural flow, if, if /else, while, goto, global variables, Security: Locks, types of locks, levels of locks. Cursors: Working with cursors, Error Handling, Developing stored procedures, create, alter and drop, passing and returning data to stored procedures,using stored procedures within queries, building user defined functions, creating and calling a scalar function, implementing triggers, creating triggers, multiple trigger interaction.

 

References:

1. Abraham Silberschatz, Henry F Korth, S.Sudharshan, Database System
Concepts
2. Ivan Bayross, PL/SQL: The Programming Language of Oracle SQL.
3. Alex Krigel and Boris M.Trukhnov, SQL Bible, Wiley pubs
4. Paul Nielsen, Microsoft SQL Server 2000 Bible, Wiley Dreamtech India Pubs.
5. CJ Date, Introduction to Database Systems, Addison Wesley.
6. Ramkrishnan, Database Management Systems, McGraw Hill.

Fundamentals of Database Management System and RDBMS
Course Information
  • Course Id:BCS4B06
  • Credit:3
  • Timings:75Hrs

Related Courses -