1. Database Design
1.1 Given a scenario, design tables for storing data
• Identify entities, rows/records, columns/fields
1.2 Given a scenario, identify the appropriate primary key • Primary key, composite/compound key
1.3 Given a scenario, choose data types to meet requirements • Definition and importance of data types; how data types affect storage requirements; data types for storing text, numbers, dates and times, and Boolean values
1.4 Given a scenario, design relationships between tables • How to establish relationships using primary and foreign keys, entityrelationship diagrams (ERDs), referential integrity
1.5 Normalize a database • Reasons for normalization, how to normalize a database to third normal form (3NF)
1.6 Given a scenario, identify data protection measures • Backups, restore, principle of least privilege , GRANT, WITH GRANT OPTION, REVOKE, purpose of roles
1.2 Given a scenario, identify the appropriate primary key • Primary key, composite/compound key
1.3 Given a scenario, choose data types to meet requirements • Definition and importance of data types; how data types affect storage requirements; data types for storing text, numbers, dates and times, and Boolean values
1.4 Given a scenario, design relationships between tables • How to establish relationships using primary and foreign keys, entityrelationship diagrams (ERDs), referential integrity
1.5 Normalize a database • Reasons for normalization, how to normalize a database to third normal form (3NF)
1.6 Given a scenario, identify data protection measures • Backups, restore, principle of least privilege , GRANT, WITH GRANT OPTION, REVOKE, purpose of roles
Application Security Scenarios in SQL Server _ Microsoft Docs.pdf