Study

MCQ2 No2 Data Modelling revision

  •   0%
  •  0     0     0

      Back   Restart
  • what is the best practice used in your ERD design?
    clear, consistent naming, avoid redundancy, ensure all entities have primary keys.
  • What does cardinality mean (in relation to ERD)?
    how many instances of one entity can be associated with instances of another
  • What do you use when creating ERD?
    entities, relationships, attributes, connecting lines and cardinality
  • How is a physical data model different from conceptual and logical data models?
    data now ready for database creation, considers specific system and database requirements
  • What does ERD stand for?
    Entity Relationship Diagram
  • What would be common mistakes in ERD?
    missing primary keys, redundant relationships, inappropriate attributes.
  • What is considered to be best practice when designing data models?
    Regular review and updates as needs change, test thoroughly before implementation.
    • Your experience on this site will be improved by allowing cookies.