Loader
FILE ORGANISATION AND FUNDAMENTAL DATABASE

FILE ORGANISATION AND FUNDAMENTAL DATABASE


Rs. 90 (Inclusive of all Taxes)

Rs. 86 5% OFF

Details

About the book

1. File Organization
Introduction
1.1 Physical files and logical files
1.2 File operation
1.3 Special characters in files
1.4 Fields and record organization
1.5 Types of file organization
1.6 Choosing a file organization
2. Indexed File Organization
Introduction
2.1 Overview of indexes
2.2 Types of simple level ordered indexes
2.3 Multilevel indices
3. Introduction to DBMS
Introduction
3.1 Traditional file system vs DBMS
3.2 Describing and storing data
3.3 Levels of abstraction
3.4 Data independence
3.5 Queries in a DBMS
3.6 Structure of a DBMS
3.7 Users of a DBMS
3.8 Advantages of DBMS
3.9 The Database Admisistrator (DBA)
4. Conceptual Design (E-R Model)
4.1 Introduction
4.2 Basic concepts of the E-R model
4.3 Mapping constraints for relationship types
4.4 Keys
4.5 Weak entity sets
4.6 Notations used for E–R diagram
4.7 Relationship Type of degree higher than 2
4.8 Extended E–R Features
4.9 Conceptual design using E-R
4.10 Case study
5. Relational Data Model
5.1 Relational model concepts
5.2 Reduction of E–R schema into tables
5.3 Conversion of hospital E–R schema, Gmart to their respective tabular representations
5.4 Integrity constraints 10
6. Relational Algebra
Introduction
6.1 Fundamental operations
6.2 Addition operations
6.3 Some relational algebra queries
7. Structured Query Language (SQL)
Introduction
7.1 Data definition language
7.2 Basic structure of SQL
7.3 Order by clause and simple queries
7.4 Aggregate function
7.5 Joins
7.6 Nested queries
7.7 Data manipulation language
8. Functional Dependency
Introduction
8.1 Problems caused by redundancy
8.2 Functional dependencies
8.3 Desirable properties of decomposition
8.4 Normalization

Academic Details

  • Phase Graduation

  • Stream Science

  • Branch Computer Science

  • Standard/Year Firstyear

  • Medium English

  • Board/University Pune

  • Subject File Organisation And Fundamental Database

Reviews

  • No Reviews written for this product. Be the first to write a review.
Shipping Info
  • Enjoy Free Shipping charges & free shipping on applicable orders:
    • Above 300 in Pune
    • Above 500 in Maharashtra
    • Above 1000 in India
  • Generally, delivered in 4-5 Business Days
  • Cash on Delivery Available
Special Offers for You
  1. Special Offer on Online Orders
  2. Get Best Discount on Books and Stationery

FILE ORGANISATION AND FUNDAMENTAL DATABASE

FILE ORGANISATION AND FUNDAMENTAL DATABASE