Question

Briefly explain on each of the following

* A database
* Difference between a database(DB) and database management system (DBMS)
* Advantages of a database
* Principles outline in the data protection act of 1998
* Primary key
* Candidate key
* Natural key
* Surrogate key
* Foreign key
* Duties of a database administrator
* Difference between a compiler and interpreter Both assignments are due by 12t
March 2023. No late submission will be allowed.

Answer 1

A database holds structured data, while a DBMS is the software managing the database. Key types, such as primary, candidate, and foreign keys, facilitate data relationships within a DBMS. A compiler translates all source code at once, but an interpreter does so line by line.

Step-by-step explanation:

Database and Database Management System (DBMS)

A database is a structured collection of data that allows for easy access, management, and updating. A database management system (DBMS) is a software tool that uses standard methods to manage and interact with databases. The primary difference between a database and a DBMS is that the database is the actual set of data, while the DBMS is the software that facilitates operations on that data such as querying, updating, and administration.

Advantages of a Database

• Data can be efficiently structured and managed.
• Simple data retrieval and manipulation using queries.

Data Protection Act of 1998 Principles

The Data Protection Act of 1998 outlines principles to ensure data is processed lawfully and fairly, is accurate, is kept secure, and is not transferred to countries without adequate protection.

Database Keys

• Primary key: A unique identifier for each record in a database table.
• Candidate key: Any column or set of columns that can uniquely identify rows in a table, one of which can become the primary key.
• Natural key: A primary key that is formed of attributes that already exist in the real world.
• Surrogate key: An artificial key that is created specifically to serve as the primary key.
• Foreign key: A field in one table that uniquely identifies a row of another table or the same table.

Database Administrator Duties

The duties of a database administrator include managing the database's performance, integrity, and security, ensuring data recovery, and enforcing policies.

Compiler vs. Interpreter

A compiler translates the entire source code to machine code before execution, whereas an interpreter translates each high-level instruction to machine code and executes it line by line.