Lecture Notes || SNS Courseware

Lecture Notes

UNIT 1:

Database languages – Transaction management – Storage management – Database Administrator – Database users

Basic concepts – Design issues – Mapping constraints – keys

– E-R diagram ,Weak entity sets ,Extended E-R features

UNIT 2:

Structure of Relational Databases ,The relational algebra ,Tuple relational calculus ,The domain relational calculus

Pitfalls in relational-database design ,decomposition,Normalization using fundamental dependencies

UNIT 3:

Naming Rules and Conventions ,Data Types

Creating Oracle Table ,Constraints

Displaying Table Information ,Altering an Existing Table ,Dropping, Renaming, Truncating Table – Table Types – Spooling – Error codes

UNIT 4:

Set operations

Updating and Deleting an Existing Rows/Records – retrieving Data from Table

Set operations

UNIT 5:

A Programming Language: History – Fundamentals – Block Structure – Comments – Data Types – Other Data Types – Declaration – Assignment operation – Bind variables – Substitution Variables – Printing

SQL in PL/SQL – Data Manipulation –Transaction Control statements. PL/SQL Composite Data Types: Records – Tables – Varrays.

Arithmetic Operators. Control Structures and Embedded SQL: Control Structures – Nested Blocks

Lecture Notes

Announcements

Recent Files

Copyright © SNS College Of Engineering 2014 Developed bySNSCE