Partial preview of the text
Download Database programming and more Summaries Computer Science in PDF only on Docsity!
Database Programming (Elective) BEG475DB Year IV Semester II Teaching Schedule oo Hours/Week Examination Scheme Theory | Tutorial | Practical intemal Final Total Assessment Theory | Practical | Theory | Practical | 3 1 2 20 35 80 125 1. Introduction (Shrs) 1.1 Overview of data, database, DBMS,RDBMS,ORDBMS 1.2 Importance and needs of DBMS 1.3 Database administrator and other database users 1.4 Relationship among data(one to one, many to one, many to many) 1.5 Database Models (Hierarchical, Network, Relational) 1.6 Codd’s Rule of relational database management System 2. SQL (10 hrs) 2.1 Introduction to SQL 2.2 SQL Commands (DDL,DML,DCL;TCL) 2.3 Creating database and Users 2.4 Categories of SQL Statements 2.5 Oracle Data types 2.6 The CREATE, DROP, ALTER Statement 2.7 Integrity Constraints (Entity, Domain, Referential Constraints) 2.8 DML Statements (Select ,Insert, delete, Update) 2.9 Transaction Control Statements(Commit, Rollback, Save point) 2.10 Data Control Statements(Grant, Revoke) 2.11 Comparison Operators, IN and NOT IN Operators, BETWEEN Operator 2.12 The LIKE Operator, Logical Operators, IS NULL and IS NOT NULL, 2.13 set operators, Union, Union all, Intersect, Minus, GROUP BY Clause, 2.14 HAVING Clause, The DISTINCT Keyword, Miscellaneous Functions, 2.15 Mathematical Functions, String Functions, Date Functions, Conversion . Functions 3. Joining Tables (4 hrs) 3.1 Joins, Cartesian Product nner Joins, Equi-Join, Outer Joins, Right Outer Join, Left Outer Join, Full Outer Join - 4. Locks and Partition of Tables (4 Hrs) 4.1 Introduction 4.2 Row level and table level lock 4.3 Table partitions 4,3 Maintaining Partitions Sy gh . 4L 
