Page 315 - IT 402 v2.0 class 10
P. 315
. hat is MS
Ans. R D B M S is a r e l a t io n a l D B M S in w h ic h t a b l e s a r e l in k e d t o e a c h o t h e r b y f ie l d s . I n a d d it io n t o a l l t h e a d va n t a g e s o f
D B M S , R D B M S h e l p s in t h e m a n a g e m e n t o f a d a t a b a s e in a b r o a d e r w a y .
. hat is database server xplain rimary key and Foreign key.
ns. atabase servers are dedicated computers that can hold the actual databases. It can run only the MS and its
related software. atabases available on the database servers are accessed through ommand ine or raphic
ser Interface tools also called as Frontends. Other servers are referred to as ackends that process the re uest
and provides the data.
Primary Key: rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field
and it cannot be left blank. There can be only one primary key in a table. If there are more than one primary
keys then there will be two identities against a row. here can be only one identity against a row. So we cannot
have more than one primary key. To make retrieval of records faster, Primary keys are indexed in database.
Foreign Key: he main table of a database is referred to as the Master able and the tables in which the related
data is stored are referred to as ransaction able . he tables are related and are linked through a field which
is common. his common key field in the transaction table is called the Foreign key and its value depends on
the primary key values of the master table.
. hat are lip rts ifferentiate between inking and mbedding an ob ect.
ns. lip rts are collections of pictures or images that can be imported into an o ce application.
ifference between inking and mbedding an ob ect:
Linking: hen an ob ect is linked information can be updated if the source file is modified.
Embedding: hen an ob ect is embedded it becomes a part of the file and does not get updated if the source
file is modified.
. hat do MS and MS stand for xplain in short.
ns. MS stands for atabase Management System. It is a software that controls the creation maintenance and use
of a database.
MS stands for elational atabase Management System. In this database system tables are linked to each
other by fields and helps in management of database in a broader way.
. hat do you mean by primary key and foreign key
Ans. Primary Key: rimary key is a field which is used to uni uely identify records in a database. It is a uni ue field
and it cannot be left blank. There can be only one primary key in a table. If there are more than one primary
keys then there will be two identities against a row. here can be only one identity against a row. So we cannot
have more than one primary key. To make retrieval of records faster, Primary keys are indexed in database.
Foreign Key: he main table of a database is referred to as the Master able and the tables in which the
related data is stored are referred to as ransaction able . he tables are related and are linked through a
field which is common. his common key field in the transaction table is called the Foreign key and its value
depends on the primary key values of the master table.
Database Management 313

