Relational Database Design: Features of good Relational designs Atomic – domains and First Normal Form Decomposition using functional dependencies – – Functional dependency theory Decomposition using functional Decomposition using – – multivalued dependencies more Normal forms database design process modeling – – – temporal data Unit III Database System Architecture: Centralized and Client-Server architecture Server – system architecture parallel systems Distributed systems Network types. Parallel – – – databases: I/O parallelism Interquery Parallelism Intraquery parallelism. Distributed – – Databases: Homogeneous and Heterogeneous databases Distributed Data storage – – Distributed transactions Distributed query processing. – Unit IV Schema Objects Data Integrity Creating and Maintaining Tables Indexes – – – Sequences Views Users Privileges and Roles – – –Synonyms. Unit V PL/SQL: PL/SQL Triggers Stored Procedures and Functions Package – – – – Cursors Transaction – Text Books: Database System Concepts SilberschatzKorthSudarshan, International (5th Edition) – McGraw Hill Higher Education 2006 Jose A.Ramalho Learn ORACLE 8i BPB Publications 2003 – Books for Reference: The and George Koch, Tata McGraw Hill, “Oracle 9i complete reference“, Kevin Loney 2004. Management and Gehrke, Mc Graw Hill, Third “Database Systems”, Ramakrishnan Edition, 2003. Programming Tata Mc Graw Hill, “Oracle 9i PL/SQL “Scott Urman, Oracle Press, 2002. ♣♣♣♣♣♣♣♣ III YEAR V SEMESTER – COURSE CODE: 7BCE5P1 CORE COURSE-XI–RELATIONAL DATABASE MANAGEMENT SYSTEMS LAB The following concepts must be introduced to the students: DDL Commands Create table, alter table, drop table • DML Commands Select, update, delete and insert statements • Condition specification using Boolean and comparison operators (and, • or,not,=,<>,>,<,>=,<=)
Relational Database Design: Features of good Relational designs – Atomic domains and First Normal Form – Decomposition using functional dependencies – Functional dependency theory – Decomposition using functional – Decomposition using multivalued dependencies – more Normal forms – database design process – modeling temporal data Unit III Database System Architecture: Centralized and Client-Server architecture – Server system architecture – parallel systems – Distributed systems – Network types. Parallel databases: I/O parallelism – Interquery Parallelism – Intraquery parallelism. Distributed Databases: Homogeneous and Heterogeneous databases – Distributed Data storage – Distributed transactions – Distributed query processing. Unit IV Schema Objects Data Integrity – Creating and Maintaining Tables – Indexes – Sequences – Views – Users Privileges and Roles –Synonyms. Unit V PL/SQL: PL/SQL – Triggers – Stored Procedures and Functions – Package – Cursors – Transaction Text Books: Database System Concepts – SilberschatzKorthSudarshan, International (5th Edition) McGraw Hill Higher Education 2006 Jose A.Ramalho – Learn ORACLE 8i BPB Publications 2003 Books for Reference: “Oracle 9i The complete reference“, Kevin Loney and George Koch, Tata McGraw Hill, 2004. “Database Management Systems”, Ramakrishnan and Gehrke, Mc Graw Hill, Third Edition, 2003. “Oracle 9i PL/SQL Programming “Scott Urman, Oracle Press, Tata Mc Graw Hill, 2002. ♣♣♣♣♣♣♣♣ III YEAR – V SEMESTER COURSE CODE: 7BCE5P1 CORE COURSE-XI–RELATIONAL DATABASE MANAGEMENT SYSTEMS LAB The following concepts must be introduced to the students: DDL Commands • Create table, alter table, drop table DML Commands • Select, update, delete and insert statements • Condition specification using Boolean and comparison operators (and, or,not,=,<>,>,<,>=,<=)
Sy0058.docx