What is DBMS

DBMS
            A database management system is essential a collection of interrelated data and a set of programs to access this data. This collection of data is called the database. The primary objective of a DBMS is to provide a convenient environment to retrieve and store database information. Database system supports single user and multi-user. While DBMS lets only one person to access the database at a given time, RDBMS allows many users to simultaneously access the database.
Database management system offers the following services:-

Data Definition: - it is method of data definition and storage.
Data Maintenance: - It checks whether each record has fields containing all information about the particular item.
Data manipulation: - Allows data in the database to be inserted,update,deleted and sorted.
Data Display: This method helps in viewing data.
Data Integrity: This ensures the accuracy of the data.

RDBMS
RDBMS means Relational Database Management System. The concept of relational database is known since 1980’s but the idea of database management system is quite old. The most famous RDBMS packages are ORACLE,SYBASE and INFORMIX.

Normalization
            Normalization theory is built around the concept of normal forms. Normalization reduce the redundancy is unnecessary repetition of data. It can cause problems with storage and retrieval of data. During the process of normalization, dependencies can be identified which can cause problems during deletion and updation . Normalization theory is based on the fundamental notion of functional dependency, normalization helps in simplifying the structure of tables.

 

 

ORACLE CLIENT & SERVER TECHNOLOGY

Oracle server is a multiuser tool that works in a client/server environment. Client/server programming is form of distributed application processing. It has three distinct components, each focusing on a specific job. The three components are

  1. Oracle Server
  2. Oracle Client Tools
  3. Network for connecting the first two components

Operating system requirements for Oracle Client tolls

Before installing Oracle Client tools, an appropriate operating system like Windows98  or windows-NT Workstation needs to be installed on the client computer.

Oracle Client tolls are

  1. Oracle SQL *Plus
  2. Oracle Forms Designer
  3. Oracle Report Designer
  4. Oracle Graphics

The b,c,d are members in Developer 2000 front end tool

 

For
Online Classes

Contact Us: +919885348743