04-11-2017, 02:04 AM
QUESTION PAPERS:-
SYLLABUS:-
UNIT-I
Introduction: An overview of database management system, database system Vs file system, Characteristics of database approach, DBMS architecture , data models, schema and instances, data independence. Data Modeling using Entity Relationship Model: Entity, Entity types, entity set, notation for ER diagram, attributes and keys, Concepts of composite,derived and multivalued attributes, Super Key, candidate key, primary key, relationships, relation types, weak entities, enhanced E-R and object modeling, Sub Classes:, Super classes, inheritance, specialization and generalization.
UNIT–II
Introduction to SQL: Overview , Characteristics of SQL. Advantage of SQL, SQL data types and literals. Types of SQL commands: DDL, DML, DCL. Basic SQL Queries. Logical operators :BETWEEN, IN, AND, OR and NOT Null Values
isallowing Null Values, Comparisons Using Null Values Integrity constraints: Primary Key, Not NULL, Unique, Check, Referential key Introduction to Nested Queries, Correlated Nested Queries, Set-Comparison Operators, Aggregate Operators: The GROUP BY and HAVING Clauses, Joins:Inner joins, Outer Joins, Left outer, Right outer, full outer joins. Overview of views and indexes.
UNIT–III
Relational Data Model: Relational model terminology domains, Attributes, Tuples, Relations, characteristics of relations, relational constraints domain constraints, key constraints and constraints on null, relational DB schema.Codd’s Rules Relational algebra:Basic operations selection and projection, Set Theoretic operations Union, Intersection, set difference and division, Join operations: Inner , Outer ,Left outer, Right outer and full outer join. ER to relational Mappingata base design using ER to relational language. Data Normalization: Functional dependencies, Armstrong’s inference rule, Normal form up to 3rd normal form.
UNIT–IV
Transaction processing and Concurrency Control: Definition of Transaction, Desirable ACID properties, overview of serializability, serializable and non serializable transactions Concurrency Control: Definition of concurrency, lost update, dirty read and incorrect summary problems due to concurrency Concurrency Control Techniques: Overview of Locking,2PL,Timstamp ordering, multiversioning, validation Elementary concepts of Database security: system failure, Backup and Recovery Techniques, authorization and authentication.
SYLLABUS:-
UNIT-I
Introduction: An overview of database management system, database system Vs file system, Characteristics of database approach, DBMS architecture , data models, schema and instances, data independence. Data Modeling using Entity Relationship Model: Entity, Entity types, entity set, notation for ER diagram, attributes and keys, Concepts of composite,derived and multivalued attributes, Super Key, candidate key, primary key, relationships, relation types, weak entities, enhanced E-R and object modeling, Sub Classes:, Super classes, inheritance, specialization and generalization.
UNIT–II
Introduction to SQL: Overview , Characteristics of SQL. Advantage of SQL, SQL data types and literals. Types of SQL commands: DDL, DML, DCL. Basic SQL Queries. Logical operators :BETWEEN, IN, AND, OR and NOT Null Values
isallowing Null Values, Comparisons Using Null Values Integrity constraints: Primary Key, Not NULL, Unique, Check, Referential key Introduction to Nested Queries, Correlated Nested Queries, Set-Comparison Operators, Aggregate Operators: The GROUP BY and HAVING Clauses, Joins:Inner joins, Outer Joins, Left outer, Right outer, full outer joins. Overview of views and indexes.UNIT–III
Relational Data Model: Relational model terminology domains, Attributes, Tuples, Relations, characteristics of relations, relational constraints domain constraints, key constraints and constraints on null, relational DB schema.Codd’s Rules Relational algebra:Basic operations selection and projection, Set Theoretic operations Union, Intersection, set difference and division, Join operations: Inner , Outer ,Left outer, Right outer and full outer join. ER to relational Mapping
ata base design using ER to relational language. Data Normalization: Functional dependencies, Armstrong’s inference rule, Normal form up to 3rd normal form.UNIT–IV
Transaction processing and Concurrency Control: Definition of Transaction, Desirable ACID properties, overview of serializability, serializable and non serializable transactions Concurrency Control: Definition of concurrency, lost update, dirty read and incorrect summary problems due to concurrency Concurrency Control Techniques: Overview of Locking,2PL,Timstamp ordering, multiversioning, validation Elementary concepts of Database security: system failure, Backup and Recovery Techniques, authorization and authentication.