An example; Characteristics of Database approach; Actors on the screen; Workers behind thescene; Advantages of using DBMS approach; A brief history of Database Applications; Whennot to use a DBMS. Data Models, Schemas and Instances; Three-Schema Architecture and DataIndependence; Database Languages and Interfaces; The Database System Environment;Centralized and Client-Server Architectures for DBMSs; Classification of DatabaseManagement Systems
Using High-Level Conceptual Data Models for Database Design; An Example DatabaseApplication; Entity Types, Entity Sets, Attributes and Keys; Relationship Types, RelationshipSets, Roles and Structural Constraints; Weak Entity Types; Refining the ER Design forCOMPANY Database; ER Diagrams, Naming Conventions and Design Issues; RelationshipTypes of Degree Higher than Two, Relational Database Design Using ER- to-RelationalMapping
Relational Model Concepts; Relational Model Constraints and Relational Database Schemas;Update Operations, Transactions and Dealing with Constraint Violations; Unary RelationalOperations: SELECT and PROJECT; Relational Algebra Operations from Set Theory; BinaryRelational Operations: JOIN and DIVISION; Additional Relational Operations; Examples ofQueries in Relational Algebra;
SQL Data Definition and Data Types; Specifying Constraints in SQL; Schema ChangeStatements in SQL; Basic Queries in SQL; More Complex SQL Queries, Insert, Delete andUpdate Statements in SQL; Specifying Constraints as Assertions and Triggers; Views (VirtualTables) in SQL; Additional Features of SQL; Database Programming: Issues and Techniques;Embedded SQL, Dynamic SQL; Database Stored Procedures and SQL / PSM.
Informal Design Guidelines for Relation Schemas; Functional Dependencies; Normal FormsBased on Primary Keys; General Definitions of Second and Third Normal Forms; Boyce-CoddNormal Form
Introduction, Language fundamentals, conditional and sequential control, Iterative processingand loops. Exception handlers, triggers. Functions, procedures. Creating and planningPL/SQL.