The Project Database Design The following is the

The Project – Database Design. The following is the high mark band for the Database design: • Analysed a given situation and produced analysed a given data set, identified all related sets of data and designed suitable data structures to enable the data to be managed effectively. The design will specify correct and suitable fieldnames, data types, field sizes and key fields. It will also include comprehensive proposals for validation rules and input masks that will control data input and limit errors • Produced designs for input formats that propose a range of features to aid data entry • Included proposals for output and clearly illustrated the intended layout of reports to be generated • Identified and provided detailed examples of the required data sorting, searches and calculation to be carried out

The Project – Database Design. Below is what the specification requires of this section. Section Description Tables Produce a design for a database that is suitable for implementation by a competent third party. Analyse a given data set, identify related sets of data and design suitable data structures that will allow the related data to be managed efficiently. Specify suitable fieldnames, data types, field sizes and key fields. Specify suitable validation rules and input masks that will control data input and limit errors. Input Design input forms that will facilitate accurate data entry through the use of features such as combo boxes, user instructions and radio buttons. Interface Design forms that will provide an interface to aid user efficiency. Consider accessibility and usability Output Design the output required in terms of content, layout and presentation. Efficiency Describe the processing stages required in terms of data sorting, searches and calculations.

The Project – Database Design. A good format for this document may be like this for example: 1) Table design – Essentially a data dictionary for each table with the following headings – Field Name / Data Type / Field Size / Example Data / Validation / Additional Notes (e. g. primary key, foreign key etc. . 2) Under each table design – a paragraph explaining some of your decisions. 3) Outline of the relationships of the tables to each other. A more detailed account of how each field in each table may relate to each other and other tables. 4) Detailed explanation and design of all your queries. 5) Detailed designs of all your user forms – including designs for the coding of your buttons / macros. Sketches of your forms. 6) Detailed designs and explanations of all your reports cross referencing back to your queries and tables and how some of the values will be calculated.