Understanding Database Design Concepts

What is a database?

• A database is a physical storage device for computers.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a type of software used for web development.

• A database is a programming language for data manipulation.

What are the main components of a database?

• The main components of a database are DBMS, data models, schemas, tables, and relationships.

• Data warehouses

• Cloud storage services

• Network protocols

Define the term 'entity' in the context of databases.

• An entity is a type of database management system.

• An entity refers to a database query.

• An entity is a method for data retrieval.

• An entity is a distinct object or thing in a database that has attributes and can be identified.

What is an attribute in database design?

• An attribute is a type of database query.

• An attribute is a method for data retrieval.

• An attribute is a database table that stores records.

• An attribute is a property or characteristic of an entity in a database.

Explain what an instance is in a database.

• An instance refers to the database server itself.

• An instance is a specific realization of a database schema, containing actual data.

• An instance is a backup of a database schema.

• An instance is a type of database query.

What is Barker's notation used for?

• Barker's notation is used for web development.

• Barker's notation is used for programming languages.

• Barker's notation is used for graphic design.

• Barker's notation is used for data modeling and database design.

List two advantages of using a database over a flat file system.

• Increased storage costs.

• Limited data sharing capabilities.

• Simplified data backup processes.

• 1. Improved data integrity and consistency. 2. Enhanced data retrieval and manipulation efficiency.

How does data integrity benefit from using a database?

• Data integrity is improved by increasing data redundancy in a database.

• Data integrity is achieved by storing data in plain text files instead of a database.

• Data integrity is enhanced by enforcing constraints and ensuring consistent data through transactions in a database.

• Data integrity is maintained by allowing multiple users to edit the same record simultaneously.

What is the role of a primary key in a database?

• The role of a primary key in a database is to uniquely identify each record in a table.

• To store large amounts of data in a single field.

• To group multiple records together in a table.

• To define the data type of each column in a table.

Describe the concept of normalization in database design.

• Normalization in database design is the process of organizing data to minimize redundancy and dependency by dividing it into related tables.

• Normalization involves merging all data into a single table.

• Normalization is the process of increasing data redundancy.

• Normalization is a method for encrypting sensitive data in databases.