Page 207 - Computer - 10(A&B)

Distributed Database

In the distributed database system, a central database is distributed
at multiple locations within a network. As the database is Database
distributed, different users can access it without any interference
with one another. Data
Database
Database Servers
Database servers are dedicated computers that host databases
Database
with the DBMS and related software. These databases are accessed
remotely as required by clients.

RDBMS
RDBMS stands for Relational Database Management System, which as the name suggests is a database
management system which uses the Relational model. In relational model, all data is represented in the form of
tuples, which are grouped into relations.

Session 2

Create and Edit Tables Using Wizard and Design View

Data in a table is organised in the form of fields and records wherein each field represents a specific attribute or
property of the object about which the information is stored in the table. So, the basic structure of a table defines
the logically related common properties of the object or entity whose information is to be stored in that table.
Before designing a table structure, it is important to decide its field names and the type of data to be stored under
these fields.
Relational Database is a database system that stores and retrieves data in a tabular format organized in the
form of rows and columns. A relational database is a type of structured database that allows us to identify and
access data in relation to another piece of data in the database. A Relational database use Structured Query
Language (SQL), which is a standard user application that provides an easy programming interface for database
interaction.

Database Objects

A database consist of the following components:
v Tables: Tables are the basic components of a database management system. Information in a table is stored
in the form of columns called fields or attributes, and different entries of related field values called records
or tuples. An individual field value of a record is called data value or data item. It represents the smallest
possible value stored in the database.

Name English Maths Hindi Science SSt

Trilok 89 77 94 67 87
Arjun 90 98 97 88 90

Neha 97 90 78 56 78
Jawahar 87 96 55 45 76

v Queries: A query is a database component which extracts or retrieves information from one or more tables
of the database that satisfy a specific criteria.
v Forms: A form is a database component that acts as a user interface to enter, edit, view, or search the data
stored in single or multiple tables.

89