PRINCIPLES OF RELATIONAL DATABASE MANAGEMENT SYSTEM

UNIT 1

1.       The relational database model.

1.1     Structure of relational database.
1.2     Relational algebra, extended relational algebra.
1.3     Relational calculus.
1.4     Modification of database.
1.5     Views.

2.       Integrity constraints.

2.1     Domain constraints.
2.2     Referential integrity constraints.
2.3     Triggers.
2.4     Functional dependencies.

3.       Controlling database access - users, groups, user authentication, user profiles and roles.

UNIT 2

4.       Structured Query Language- SQL/92.

4.1     DCL, DDL and DML statements.
4.2     DDL statements- Select, Insert, Update and Delete.
4.3     DDL statements- Create, Alter, Drop,Rename, Truncate, Grant, Revoke.
4.4     Database transaction and transaction control statements-
          Commit, Rollback, Save point.
4.5     Explanation about the stages in proceeding and SQL DML statement.
4.6     Embedded SQL- Declare cursor,Open,Close,Declare Database,Connect.

5.       Database Triggers.

5.1     Row triggers and statement triggers.
5.2     Before and after triggers.
5.3     Instead of triggers.
5.4     Cascaded triggers.
5.5     Enabled and disabled triggers.

UNIT 3

NOTE: - The syllabus is depending upon the implementation

6.       Programming language interface.

6.1     Constants, Variables, Data Types, Data subtypes, Composite Data types.
6.2     Control Structures.
6.3     Cursor and exception handling.
6.4     Subprograms / functions.
6.5     Stored Procedure.
6.6     Calling external DLL’s.

7        Forms interface (syllabus not implemented, as it is implementation dependent)

8.       Reports interface (syllabus is not expanded as it is implementation dependent)