Does NothingDoes NothingDoes NothingDoes Nothing NowtAdminCase Studiesmodule1Module2Module3Module4Module5Module6Glossary  
nowtPolicy / StrategySoftware evaluationDatabase managementDistributed SystemsNetwork security and accountingHuman Computer InteractionHuman Computer InterfaceSoftware DevelopmentSoftware reliabilityPortability of Datanowt
NowtCommunication and Information SystemsNetwork ApplicationsDistributed SystemsDistributed DatabasesQuestions - networksQuestions - databasesNowt
 

Questions 1- Database management concepts

1. A company sports centre uses a database management system to operate a membership and fixture system. Normally members register for at least three sports, although they can play any of the sports offered by the centre. Fixtures against many other organisations are arranged in a wide range of sports involving a large number of teams.
  1. Name three database files you would expect to find in this system. (3)
  2. For each of the database files you have named, list the fields required to enable this system to be maintained with minimum redundancy. (6)
  3. Draw a diagram to show the relationship between the database files named in part (a). (3)
  4. Describe three reports that the system might be required to produce. (3)
  5. The manager of the centre intends to send out personalised letters to each of the members. This is to be done using the mail-merge facility offered by a word-processor in conjunction with the database. Explain how this is achieved
2. A college library uses a relational database management system to operate a membership and loans system. Staff and students can borrow as many books as they wish at any given time.
  1. Name three database tables that you would expect to find in this system. In each case, identify the columns and keys required to enable this system to be maintained with minimum redundancy. (6)
  2. Draw an entity relationship diagram to show the links between the database tables named in part (a). (3)
  3. Describe the capabilities of the relational database management system that might be used to identify and output details of overdue loans (6)
3. A company makes use of a computerised flat file information storage and retrieval system. The company is experiencing problems due to the use of this flat file system.
  1. Describe three benefits that the company would gain by using a relational database as opposed to a flat file system. (6) 
  2. The company currently has three files in use; customer, stock and orders. During conversion to a relational database system these files would need to be normalised. Explain clearly what you understand by the term normalisation. (2)
   

©LEV