Search   Home| Exercises:  Database - Normalisation - 1NF - 2NF - 3NF - 4NF-7NF 

Theory

Exercises

Web Links

Downloads

Discussion

Contact Us

Glossary

Click on the answer you think is correct.

          1. Which of the following are not a generic database?

a)  Flat File
b)
  Hierarchical
c)
  Normalisation
d)
  Relational

e)
  Network

 

          2. What are the benefits of a Flat File Database?
a)  Updating of record attributes are easy to carry out
b)
  It is a relatively straightforward procedure as all the data is stored in a single table
c)
  Identical information (such as an address) is stored in one place

d)
  All of the above

 

          3. What is the objective of the Network Model?
a)  To separate the data structure from physical storage.
b)
  To eliminate unnecessary duplication of data with associated errors and costs.

c)
  To use the concept of Many to Many linkages or relationships
d)
  All of the above

 

          4. Which company recognised that business organised their data in the form of 
                hierarchy opposed to flat file?
a)  Microsoft
b)
  Oracle
c)
  Macintosh
d)
  IBM

e)
  Packard Bell

 

          5. Which of the following are related to relational systems?
a)  Relational Databases use Many to Many relationships
b)
  Amendments can be difficult to keep track of
c)  No forward planning required to create the database.
d)
  None of the above

 

Normalisation Exercises Next>>>>