Networking Database Concepts Wk 11062023

Which is fundamental to any computer system?

• Entity

• Data

• Attribute

• Instance

What is the first step in database design?

• Avoid storing the same data

• Data modelling

• Stay up-to-date

• Keep consistency with relevant raw facts

True or false: Can databases be a simple file or a complex set of related tables?

• True

• False

How are "Fields" defined in a relational database?

• The ability to keep data consistent with relevant raw facts

• The ability to store, sort, and search data

• The single cell bisecting row and column

• Categories of data being stored within the table

How are "Fields" defined in a Microsoft Excel flat file database?

• The ability to keep data consistent with relevant raw facts

• The ability to store, sort, and search data

• The single cell bisecting row and column

• Categories of data being stored within the table

True or False: When multiple people want to access "the data" at the same time, does this pose a challenge for databases?

• True

• False

What is the significance of "Transactions" and "Transaction Processing" in a database?

• To use objects that represent real-world occurrences

• To represent a property, quality, or characteristic of the entity

• To ensure that the data does not get out of sync.

• To enable the ability for an attribute to accept null values

What are the specific requirements that data models are designed to fulfill?

• Define the type of data that the database will store

• Define the rules and restrictions that will apply to the data

• Define the database applications that will be joined with the database

• Define the needs of the users that will interact with the database applications

True or False: An entity does not represent an object in the real world?

• True

• False

How is an "Attribute" best defined in a relational database?

• Used to represent a property, quality, or characteristic of an entity

• The type of data that the database will store

• Able to store, sort, and search data

• A field that bisects, including system row and column