2023-2024-Term2-IntroductiontoDatabase-Computing-B12-Activity-2

What is a database?

• A method of storing physical files

• A structured collection of data

• A form of social media platform

• A type of computer hardware

Explain the concept of relational databases.

• Relational databases store and provide access to data points that are related to one another using a structured format.

• Relational databases store and provide access to data points that are not related to one another using a structured format.

• Relational databases do not store data points that are related to one another using a structured format.

• Relational databases store and provide access to data points that are related to one another using an unstructured format.

What is a database management system (DBMS)?

• A DBMS is a type of computer programming language

• A DBMS is a method for organizing physical files on a computer

• A DBMS is a hardware device used to store data

• A database management system (DBMS) is a software that allows for the creation, maintenance, and use of a database.

Define primary key in the context of databases.

• A primary key is a foreign key in a database table.

• A primary key is a unique identifier for each record in a database table.

• A primary key can have duplicate values in a database table.

• A primary key is used to store non-unique values in a database table.

What is a foreign key and how is it used in databases?

• A foreign key is a type of encryption used to secure data in databases.

• A foreign key is a unique identifier for a record in a database table.

• A foreign key is a data type used to store text values in databases.

• A foreign key is a field in a relational database table that is used to establish a link between two tables. It is used to create a relationship between the data in the two tables, typically by referencing the primary key of another table.

Explain the concept of relationships and queries in databases.

• Relationships in databases connect tables through foreign keys, while queries are requests for specific information or data retrieval using SQL or other query languages.

• Relationships in databases are only used for connecting tables with the same data type.

• Queries in databases are used to physically rearrange the data within the tables.

• Relationships in databases are used to organize files and folders within the database system.

What is an object database?

• An object database is a type of graphic design tool

• An object database is a database management system in which information is represented in the form of objects as used in object-oriented programming.

• An object database is a type of cloud storage system

• An object database is a type of spreadsheet software

Provide an introduction to Microsoft Access.

• Microsoft Access is a spreadsheet program developed by Microsoft

• Microsoft Access is a video editing software from Microsoft

• Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

• Microsoft Access is a web browser created by Microsoft

What are the key features of Microsoft Access?

• Integration with Adobe Photoshop

• Built-in web browser

• Ability to edit photos and videos

• Ability to create and manage databases, build forms and reports, and integrate with other Microsoft Office applications.

How does Microsoft Access differ from other database management systems?

• Microsoft Access is part of the Microsoft Office suite, while other database management systems may be standalone or part of different software packages.

• Microsoft Access is designed for large-scale enterprises, while other database management systems are designed for small businesses.

• Microsoft Access is open-source, while other database management systems are proprietary software.

• Microsoft Access does not support SQL, while other database management systems do.