Database design and development

Database design and development

1. DESIGN

   • entity-relationship diagrams
     • entity name
     • attributes
     • relationship (one-to-many)
   • data dictionary
     • entity name
     • attribute name
     • primary and foreign key
     • attribute type
       • text
       • number
       • date
       • time
       • Boolean
     • attribute size
     • validation
       • presence check
       • restricted choice
       • field length
       • range
   • solution to the query
     • multiple tables
     • fields
     • search criteria
     • sort order

2. Implementation

   • pre-populated relational databases
     • select
       • from
       • where
         • AND, OR, <, >, =
         • order by with a maximum of two fields
     • insert
     • update
     • delete
     • equi-join between tables

3. TESTING

   • SQL operations work correctly at this level

4. Evaluation

   • Evaluate solution in terms of
     • fitness for purpose
     • accuracy of output