Theme Options

NEWSLETTER

File Organisation and Fundamental Database

BI 1060

New

According to New Revised Syllabus w.e.f. 2008 PUNE, Maharashtra (INDIA)

Text Book of

File Organisation and Fundamental Database

FY BSc Computers

Author : Reena Bharthi

Book ID : 1060

More details

Rs.81

Rs.90

-10%

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

No customer comments for the moment.

Write a review

Write a review

30 other products

30 other products in the same category: