Loader
FILE ORGANISATION AND FUNDAMENTAL DATABASE

FILE ORGANISATION AND FUNDAMENTAL DATABASE

Rs. 90 Rs. 86 5% OFF

Details

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.

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