Q.2 - Unit-II (18 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. Q.3 - Unit-III (17 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. Q.4 - Unit-IV (18 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. ote: Options should be given in all questions HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN Programme code : PGDCA Programme Name : PGDCA Course Code PGDCA202CC Semester : 2 Advanced Database Management System (AMS) Course type : Core Course Total Credit : 04 Teaching time (hours) Examination Marking scheme Theory Practical Internal External Total (hrs) (hrs) (Marks) (Marks) (Marks) 4 X 15 = 60 30 70 ( Paper of 3 hrs) 100 Topic Marks Unit Content Hrs. Credit No. W + % No. 1 Transition Management: Recovery, concurrency, security: 17 4 Introduction, Discretionary access control, Mandatory access control, Statistical databases, Data encryption, Distributed Databases: Introduction, Some Preliminaries, The twelve objectives, Problems of distributed systems. 2 Structured Query Language (SQL): Introduction to SQL, Constraints, 18 DDL, DML, DCL, Create, Alter, Drop, Rename, Grant, Revoke, Select Clause, Functions, Different Types of Joins, set operators. 3 PL/SQL: Index, View, Sequence, Trigger, Procedure, Cursor, Exception 17 Handling. 4 Decision Support: Introduction, Aspects of decision support, Database 18 design for decision support, Data Warehouses and Data marts, Online analytical processing, Data mining Reference Books No Book Name 1 Introduction to Database System C. J. Date (7th edition) Low Price Edition 2 SQL, PL/SQL Evan Bayross (2nd edition) BPB
Q.2 - Unit-II (18 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. Q.3 - Unit-III (17 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. Q.4 - Unit-IV (18 Marks) A. Objective/ Short Questions. B. Descriptive/ Long questions. ote: Options should be given in all questions HEMCHANDRACHARYA NORTH GUJARAT UNIVERSITY, PATAN Programme code : PGDCA Programme Name : PGDCA Course Code PGDCA202CC Semester : 2 Advanced Database Management System (AMS) Course type : Core Course Total Credit : 04 Teaching time (hours) Examination Marking scheme Theory (hrs) Practical (hrs) Internal (Marks) External (Marks) Total (Marks) 4 X 15 = 60 30 70 ( Paper of 3 hrs) 100 Unit No. Topic No. Content Hrs. Marks W + % Credit 1 Transition Management: Recovery, concurrency, security: Introduction, Discretionary access control, Mandatory access control, Statistical databases, Data encryption, Distributed Databases: Introduction, Some Preliminaries, The twelve objectives, Problems of distributed systems. 17 4 2 Structured Query Language (SQL): Introduction to SQL, Constraints, DDL, DML, DCL, Create, Alter, Drop, Rename, Grant, Revoke, Select Clause, Functions, Different Types of Joins, set operators. 18 3 PL/SQL: Index, View, Sequence, Trigger, Procedure, Cursor, Exception Handling. 17 4 Decision Support: Introduction, Aspects of decision support, Database design for decision support, Data Warehouses and Data marts, Online analytical processing, Data mining 18 Reference Books No Book Name 1 Introduction to Database System C. J. Date (7th edition) Low Price Edition 2 SQL, PL/SQL Evan Bayross (2nd edition) BPB
PGDCA.docx