Design

Design

1. Entity-Relationship

   • Entity name
   • Attributes
   • Relationship (one-to-many)

2. Data Dictionary

   • Entity Name
   • Attribute Name
   • Primary and Forgein Key
   • Attribute Type
   • Attribute Size
   • Validation

3. Query

   • Multiple Tables
   • Search Criteria
   • Sort Order
   • Field Types
     • Text
     • Numeric
     • Date
     • Time
     • Graphics
     • Calculation
     • Link
     • Object
     • Boolean

4. General Data Protection Regulation (GDPR)

   • Processed lawfully, fairly and in a transparent manner in relation to inviduals
   • Used for the declared purpose only
   • Limited to the data needed for the declared purpose
   • Accurate
   • Not kept for longer than necessary
   • Held securely