Loader
DATABASE MANAGEMENT SYSTEM

DATABASE MANAGEMENT SYSTEM


Rs. 180 (सर्व कर समावेश)

Rs. 171 5% OFF

माहिती

प्रस्तावना

Contents
1. Database Management System
1. Database and Database Users
1.1 Concept of Data
1.2 Characteristics of Data in a Database
1.3 Need of Database Management
1.4 Role of Database Management System
1.5 History of Database Management System (DBMS)
1.6 Components a Database System
2. Database Users
2.1 Database Administrators (DBA)
2.2 Database Designers
2.3 Application Programmers
2.4 End Users
3. File Processing System
4. Database Management Systems
4.1 Characteristics of the Database
4.2 Limitations of DBMS
4.3 Functions of DBMS
4.4 Structure of DBMS
4.5 Comparison of File Management System with Database Management System
5. Database Schema and Instances
6. Data Abstraction
7. Data Independence
8. Centralized and Client Server Architecture of DBMS
8.1 Centralized Database Systems
8.2 Client-Server Systems
2. Data Models
1. Data Models
2. ER Model for Conceptual Design
2.1 Entity
2.2 Attribute
2.3 Relationships, Relationship Sets
3. Mapping Cardinalities
4. Types of Keys
5. ER - Diagram
3. Relational Model
1. RELATIONAL DATA MODEL
1.1 Relational Model Concepts
1.2 Relational Model Constraints
1.3 Terminologies
2. Relational Algebra
2.1 Basic Operations
2.2 Addition Operations
3. SQL- A Relational Database Language
3.1 The Terminology
3.2 Data Manipulation Commands
3.3 Join
3.4 Group by Clause
3.5 Having Clause
3.6 Union Clause
3.7 Subqueries
4. Indexing
5. Views
5.1 Constructing a View
5.2 Grouped View
5.3 Updating a View
5.4 Dropping a View
6. Security in SQL
7. Triggers
4. Relational Database Design
1. Introduction
2. Functional Dependencies
3. Undesirable Properties of a Bad Database Design
4. E.F. Codd’s Rules
5. Steps followed by Application Developer to Design Application Scheme
6. Normalization Process
6.1 First Normal Form (1NF)
6.2 Second Normal Form (2NF)
6.3 Third Normal Form (3NF)
6.4 Boyce-Codd Normal Form (BCNF)
6.5 Fourth Normal Form (4NF)
6.6 Fifth Normal Form (5NF)
7. Advantages and Disadvantages of Normalization
7.1 Advantage of Normalization
7.2 Disadvantages of Normalization
8. Denormalisation
9. Loseless Joins
10. Decompositions
5. Transaction and Concurrency Control
1. Concept of Transaction
2. Properties of Transaction
2.1 Atomicity
2.2 Consistency
2.3 Isolation
2.4 Durability
3. State of Transaction
4. Implementation of Atomicity and Durability
5. Concurrent Executions
6. Concurrency Control Techniques
7. Concurrency control
7.1 Lock Based Protocols
7.2 Two-Phase Locking Protocol
7.3 Time-stamps
7.4 Deadlocking
7.5 Multiversion Techniques
7.6 Multiple Granularity
6. Crash Recovery and Backup
1. Why Recovery is Needed?
1.1 Types of Failures
2. Storage Structure
2.1 Storage Types
2.2 Stable Storage Implementation
2.3 Data Access
3. Recovery and Atomicity
3.1 Log Based Recovery
3.2 Checkpoint and Commitpoint
3.3 Types of Rollbacks
3.4 Recovery using Deferred Update Method
3.5 Recovery using Immediate Update Method
3.6 Dirty Read Problem
3.7 Shadow Paging
4. Failure with loss of Non-volatile Storage
5. Recovery from Catastrophic Failure
6. Remote Backup Systems
7. Security and Privacy
1. Introduction
2. Database Security and the DBA
3. Discretionary Access Control Method
3.1 Types of Discretionary Privileges
3.2 Role based Authorization
4. Mandatory access control method
5. Uses of Views in Security Enforcement
6. Overview of Encryption Technique for Database
7. Statistical Database Security
8. Data Warehousing and Data Mining
1. What is a Data Warehouse?
1.1 Contrasting a Data Warehouse with an OLTP System
1.2 Typical Data Warehouse Architectures
2. Data Warehousing with Materialized Views
2.1 Data Warehouse Components
2.2 Oracle Tools for Data Warehousing
3. Understanding the Framework of the Data Warehouse
4. Data Warehouse Options
4.1 Data Warehouse Scope
4.2 Data Redundancy
5. Type of End-user
6. Developing Data Warehouses
7. Avoiding Warehouse Failures
8. Data Mining
8.1 Tools used during Data Mining
8.2 Application of Data Mining
8.3 Data Mining and Knowledge Discovery

9. Difference between Data Mining and Normal Query
solved papers of oct 12,apr 13,oct 13.

शैक्षणिक माहिती

  • शैक्षणिक टप्पा मास्टर पदवी

  • विद्याशाखा Computer Application

  • इयत्ता पहिले वर्ष

  • सत्र I

  • माध्यम इंग्रजी

  • मंडळ/विद्यापीठ पुणे

  • विषय Management

अभिप्राय

  • या वस्तूबद्दल शेरा/अभिप्राय उपलब्ध नाही. अभिप्राय लिहिणारे सर्वप्रथम व्हा.
शिपिंग बद्दल माहिती
  • लागू असलेल्या ऑर्डरवर फ्री शिपिंगचा आनंद घ्या:
    • पुण्यामध्ये 3०० पेक्षा अधिक किमतीच्या खरेदीवर
    • महाराष्ट्रात 500 पेक्षा अधिक किमतीच्या खरेदीवर
    • भारतात 1000 पेक्षा जास्त किमतीच्या खरेदीवर
  • सामान्यतः 4-5 व्यावसायिक दिवसात डिलेव्हरी होते
  • कॅश ऑन डिलिव्हरी सेवा उपलब्ध
आपल्यासाठी विशेष ऑफर
  1. ऑनलाइन ऑर्डर्सवर विशेष ऑफर
  2. पुस्तके आणि स्टेशनरीवर उत्कृष्ट सवलत मिळवा

DATABASE MANAGEMENT SYSTEM

DATABASE MANAGEMENT SYSTEM