+- studentsuvidha (https://studentsuvidha.com/forum)
+-- Forum: Student Stuffs (https://studentsuvidha.com/forum/Forum-Student-Stuffs)
+--- Forum: Indraprastha University IPU notes and papers (https://studentsuvidha.com/forum/Forum-Indraprastha-University-IPU-notes-and-papers)
+---- Forum: IPU BCA papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-IPU-BCA-papers-and-Notes-free-downloads)
+----- Forum: 2nd semester IPU BCA papers and Notes -free downloads (https://studentsuvidha.com/forum/Forum-2nd-semester-IPU-BCA-papers-and-Notes-free-downloads)
+----- Thread: DBMS IPU BCA notes and paper free download (/Thread-DBMS-IPU-BCA-notes-and-paper-free-download)
DBMS IPU BCA notes and paper free download - Dipesh S - 04-11-2017
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 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.