Database System Architecture - Basic Concepts: Data System, Operational Data, Data Independence, Architecture for a Database System, Distributed Databases, Storage Structures: Representation of Data. Data Structures and Corresponding Operators: Introduction, Relation Approach, Hierarchical Approach, Network Approach
Structure of relational databases – the relational algebra - the tuple relational calculus - the domain relational calculus. Relational Database Design: Pitfalls in relational-database design – decomposition – normalization.
DDL - DML– Data Types – Constraints – Creating Oracle Table – Displaying Table Information – Altering an Existing Table – Dropping, Renaming, Truncating Table.
Introduction to scripting –operators: logical-Increment and decrementoperators –Control structures-Loop Statements- Functions: Definition-scope rules-recursion.
Declaring arrays-passing arrays to functions-sorting arrays-object: Math object-stringObject-Date object-Boolean object and Number object
Reference Book:
1) Abraham Silberschatz, Henry F Korth- Database Systems Concepts, 7th Edition 2019, ISBN:9781449328016 2) Bipin C Desai - An introduction to Database Systems, Galgotia Publication, ISBN:10:8175156171/13:9788175156173
Text Book:
1) C.J.Date - An introduction to Database Systems, Seventh Edition 2007 ISBN:13:9781449328016