Data Storage and Database Management 2

Data Storage and Database Management 2

Entity-Relationship (ER) modelling:

• Differentiate between conceptual data model, logical data model and physical database model
• Define key concepts in ER modelling, including entities, attributes, relationships, and cardinality
• Differentiate between entity types and relationship types in an ER diagram
• Determine the cardinality and participation constraints of relationships based on business rules
• Identify entities and their attributes from real-world scenarios or business requirements
• Define appropriate data types and constraints for entity attributes in an ER model

Database Normalization:

• Purpose of normalization and how it can be used when designing a relational database
• Define the concept of normalization and its importance in relational database design
• Identify common data anomalies (such as insertion, update, and deletion anomalies) that normalization aims to mitigate
• Understand the concept of functional dependencies between attributes within a relational schema
• Identify functional dependencies and determine candidate keys in a given set of attributes
• The Normalization process: 1st, 2nd, and 3rd normal forms
• Validate the normalization process by analysing the resulting schema
• Verify that the normalized schema preserves data integrity and minimizes redundancy

Basic Database Application Development:

• Explain the client-server architecture of database applications
• Establish database connections in a programming language
• Implement connection pooling and resource management for efficient database access

Database Security and Administration:

• Introduction to Database Administration
• Database administration tasks
• Database security features: Access control, user privileges and roles in Databases
• Data protection and Data retention issues
• Database backup and recovery strategies.