Databases

Question 1

What is the definition of a database

Answer 1

A structured collection of data

Question 2

What is data inconsistency

Answer 2

A scenario that happens when the departments of a company store there own data separately. The company might have two copies of one client on two databases, only one might get updated when the data for the client needs changing so only one database has the new info and the other is outdated

Question 3

What is a relational database

Answer 3

A database with several different tables, in the tables may be the same field. These tables are linked so if that field is changed in one table, the data in it will change in the other tables

Question 4

Definition of a table

Answer 4

A collection of data about a specific entity

Question 5

What is a primary key and what is it for

Answer 5

It is a unique identifier for a field in a table that can be used to Link it to the foreign key of another table