number of relationships in which an entity can appear
number of items in an entity
number of entity sets which may be related to a given entity
Correct answer: (B) number of relationships in which an entity can appear
352. Normalization of database is essential to
avoid accidental deletion of required data when some data is deleted
eliminate inconsistencies when a data item is modified in the database
allows storage of data in a computer's disk
use a database management system
i and iii
i and ii
ii and iii
ii and iv
Correct answer: (B) i and ii
353. A second Normal Form (2 NF) relation should
be in 1 NF
not have a composite key
not have attributes dependent on key attribute
not have attributes dependent on one another
Correct answer: (A) be in 1 NF
354. Given the following relation
Student (roll no, name, course no, course max. marks, year of study, address)
The corresponding 3 NF relations are
student (roll no, name, year of study, address) course (course no, course max. marks)
student (roll no, name, year of study, address) student (roll no, course no)
course (course no, course max. marks)
student (roll no, name, address)
year (roll no, year of study)
course (course no, course max. marks)
student (roll no, name, address)
course (course no, course max. marks, year of study)
Correct answer: (B)
student (roll no, name, year of study, address) student (roll no, course no)
course (course no, course max. marks)/p>
355. The project guidance relation of Exercise 10.8.3 needs further normalization to 5 NF because
There are too many multivalued dependencies
Multivalued dependency and simple dependency are mixed in the 4 NF relation
Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects
4 NF relations have composite keys
Correct answer: (C) Spurious tuples got introduced when the 4 NF relations are combined due to the fact that a professor can guide only specified projects
356. Data availability is often difficult in file based system
as files are duplicated
as unnecessary data are stored in files
as one has to search different files and these files may be in different update states
redundant data are stored in files 8.5.4 Management policy changes are difficult to implement in a file based system because
Correct answer: (C) as one has to search different files and these files may be in different update states
357. A database models data so that it is
appropriate for application
independent of application program
optimized for most frequent applications
optimized for all applications
Correct answer: (B) independent of application program
358. Data integrity is ensured by
good data editing
propagating data changes to all data items
preventing unauthorized access
preventing data duplication
Correct answer: (B) propagating data changes to all data items
359. A check pointing system is needed
to ensure system security
to recover from transient faults
to ensure system privacy
to ensure system integrity
Correct answer: (B) to recover from transient faults
360. A good database design
is expandable with growth and changes in organization