Page 307 - IT 402 v2.0 class 10
P. 307
Report: It displays information in a customised format as per the user s re uirement. eports can be
printed. It can present information from single as well as multiple tables.
. hat are the different types of relationship that may exist between tables
ns. he different types of relationships that may exist between tables are:
One to one
One to many
Many to many
. hat do you mean by ata edundancy
ns. ata edundancy means duplication or repetition of data. It means storage of the same data in multiple
places. It leads to increase in the size of the database as well as database inconsistencies.
5. hat is ata Sharing
ns. ata sharing means that the data stored in one place can be shared by multiple users. It is cost-effective as
well as reduces memory usage. It saves time as the table or the data is created just once and shared among
its users.
. here can an O ob ect be used in ase
ns. O ob ect is used to insert images pictures graphics finger prints or iris patterns in a database. If you are
thinking of storing any image or graphic in any field you can assign the data type for that particular field as
O .
. hat do you understand by the term efault value of a field in ase
ns. his field property is used to enter a default value in a field. henever the users enter a new record in the
table the default value gets automatically filled as the new record and the users saves the time that would be
spent on data entry in that particular field.
. an there be multiple primary keys in a table ustify your answer.
ns. No there can be only one primary key in a table. rimary key is that field of a table which contains uni ue values
and thus its values cannot be repeated. For example in a S N table there can be various fields such as
roll number name age marks etc. So here roll number can be made the primary key because other fields may
contain duplicate values, i.e., two students of a particular class can have same name as well as marks.
. Mention any two integer data types of a table field in database. S Sample aper
ns. IN IN SM N IN N M I I IN
. Name the relationship in which one column of the primary key table is associated with all the columns of the
associated table and vice versa. S Sample aper
Ans. One to Many elationship or Many to One elationship
. efine eports of a database. S Sample aper
Ans. A report helps to display the data in a summarized manner. It is used to generate the overall work outcome
in a clear format. ou can create reports in the database.
. ow ntry e uired and efault alue properties of a table field in a database are different from each
other S Sample aper
Ans. Entry Required: if set to yes then it will be necessary for the user to insert the value in the field which
means that field cannot be left blank.
Default Value: default value can be set for a field if user don t provide any value while entering the values
in the table.
Database Management 305

