|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Unit 311 Design and Use Databases 311.1 Design and Create Databases a) You obtain clear and accurate information on your customer’s database requirements b) You clearly identify the constraints imposed by the customer c) Where applicable, you make effective use of your time by making recommendations for the adaptation of existing databases d) You create fields with characteristics which effectively meet your customer’s database requirements e) When required, you modify field characteristics to meet customer requirements and maintain the integrity of existing data f) You effectively format database designs to meet your customer’s database requirements g) You present suitable design options to customers in a way which enables them to make an informed choice h) You save database files effectively to preserve their integrity and to comply with your organisation’s requirements i) The final design meets customer requirements 311.2 Extract Information by Interrogating the Database a) You discuss and agree your customer’s information requirements b) You correctly translate your customer’s information requirements by using data interrogation methods applicable to meeting your customer’s information requirements c) You correctly locate and effectively extract the information required by your customer d) Where necessary, you modify the data interrogation method to meet new information requirements e) You effectively establish data file relationships to extract the information required f) You make effective use of available on-line help to resolve any problems g) You promptly and clearly inform the relevant person(s) of any unresolved problems h) The extracted information is correct, and meets your customer’s requirements i) The extracted information is saved following your organisation’s requirements 311.3 Present the Database Information a) You discuss and agree any necessary alterations to the initial extracted information with your customer prior to proceeding with the work b) You discuss and agree the presentation style required for the extracted database information with your customer c) You select and use software facilities suitable for creating the required presentation style d) You select and effectively use page format and layout facilities for presenting the database information e) You select and use software functions to correctly link the database information with other applications to meet customer requirements f) Where necessary, you make effective use of available on-line help to resolve any database presentation problems that may arise g) You promptly report any unresolved problems to the relevant person(s) h) The final database presentation is accurate and complete and meets your customer’s requirements the cat sat on the mat and found a friend called pat.
Approximate Word count = 427
Approximate Pages = 1.7
(250 words per page double spaced)
|
|
|
|
|
|