Understanding Database Design Principles

What is data redundancy in a database?

• Data redundancy is the process of compressing data in a database.

• Data redundancy is the method of indexing data for faster retrieval in a database.

• Data redundancy refers to the encryption of sensitive data in a database.

• Data redundancy is the unnecessary duplication of data in a database.

How does data redundancy affect storage space?

• Data redundancy increases storage space usage.

• Data redundancy decreases storage space usage.

• Data redundancy has no effect on storage space.

• Data redundancy only affects data integrity, not storage space.

What are the potential issues caused by data redundancy?

• Reduced data processing time

• Simplified data management

• Data inconsistency, increased storage costs, and management difficulties.

• Improved data accuracy

Define data integrity in the context of databases.

• Data integrity is the accuracy and consistency of data in a database.

• Data integrity is the process of backing up data in a database.

• Data integrity is the total amount of data stored in a database.

• Data integrity refers to the speed of data retrieval in a database.

What principles can be implemented to ensure data integrity?

• Use outdated software for data management

• Ignore user access permissions

• Implement data validation, access controls, regular backups, encryption, and audit trails.

• Implement data compression techniques

What is normalization in database design?

• A way to combine multiple databases into one

• Normalization in database design is the process of organizing data to minimize redundancy and dependency.

• A technique for data encryption

• A method to increase data redundancy

How can validation be included in database design?

• Incorporate data type constraints, primary/foreign keys, check constraints, and triggers.

• Rely solely on user input for data integrity

• Use only text fields for all data

• Ignore relationships between tables

What is access control in a database system?

• Access control is the set of policies and mechanisms that restrict access to database resources based on user permissions.

• Access control is the process of backing up database data.

• Access control refers to the speed of database queries.

• Access control is the method of encrypting database information.

List some components of good password policies.

• No password expiration policy

• Encouragement of simple passwords

• 1. Minimum length (e.g., at least 12 characters), 2. Complexity requirements (e.g., mix of uppercase, lowercase, numbers, and symbols), 3. Regular password changes (e.g., every 3-6 months), 4. Prohibition of common passwords, 5. Multi-factor authentication (MFA) encouragement, 6. Secure password storage (e.g., hashing), 7. User education on password security.

• Use of the same password across multiple accounts

Why is it important to manage user rights and privileges?

• To simplify user management by eliminating user roles.

• It is important to manage user rights and privileges to prevent unauthorized access and ensure data security.

• To ensure that all users can access sensitive information without restrictions.

• To increase system performance by granting all users full access.