Data and Databases - Database architecture, relational databases

4 important questions on Data and Databases - Database architecture, relational databases

What is a database

shared, integrated computer structure that stores: end user data (raw facts) and metadata (data about data, zoals de bronvermelding)

Data is processed by the hardware via software. A database is software that runs on the hardware. Hardware stress the data, software processed the data.

What is a Database Management system

– collection of programs that manages database structure and controls access to data. Possible to share data among multiple applications or users. Make data management more efficient and effective.

Why is Database design important?

• Defines the database’s expected use
• Different approach needed for different types of databases
• Avoid redundant data
• Poorly designed database generated errors, leads to bad decisions, can lead to failure of organization.
  • Higher grades + faster learning
  • Never study anything twice
  • 100% sure, 100% understanding
Discover Study Smart

What is data redundancy?

Data redundancy results in data inconsistency.
Different and conflicting versions of the same data appear in different places.
Errors more likely to occur when complex entries are made in several different files and recur frequently in one or more files.
Data anomalies develop when required changes in redundant data are not made successfully  

Data redundancy is a direct result of storing copies of the same data in more than one place in a database (duplication of data). Increase of use of disk storage and reduces efficiency of data updates.

The question on the page originate from the summary of the following study material:

  • A unique study and practice tool
  • Never study anything twice again
  • Get the grades you hope for
  • 100% sure, 100% understanding
Remember faster, study better. Scientifically proven.
Trustpilot Logo