Relational vs Flat file Databases

All information in a ​ (a)   databse is stored in a ​ (b)   table or file.

• flat file
• relational
• single

All Information in a ​ (a)   dabase is stored in ​ (b)   tables that are ​ (c)   .

• relational
• flat file
• multiple
• connected

_______________(Normal...) is the process of organizing data in order to save space, eliminate data redundancy, and data inconsistencies

​ (a)   is the process of ​ (b)   data in order to ​ (c)   space, eliminate ​ (d)   , and data inconsistencies

• Normalisation
• organizing
• save
• data redundancy

​ (a)   data entries are also called data ​ (b)  

Example: Customer name and address ​ is (c)   for ​ (d)   order.

• Repetitive
• redundancies
• repeated
• every

Data is stored​ (a)   in a relational database and reused through ​ (b)  

Example: Customer information stored once and​ (c)   to ​ (d)   orders

• once
• relationships.
• linked
• multiple

​ (a)   databases: Have a higher chance of data ​ (b)   and errors.

Example: Different ​ (c)   of a customer’s name in various records.

• inconsistency
• spellings
• Flat file

What is a flat file database?

• A flat file database stores data in a single table

• A flat file database is a type of cloud-based database
• A flat file database uses a simple relational structure to store data

• A flat file database can only store numerical data

In a relational database, what is a primary key?

• A primary key is a field that can have duplicate values in a table.
• A primary key is a random value assigned to each record.
• A primary key is a unique identifier for each record in a table.
• A primary key is used to store descriptive information about the records.

Which of the following is a disadvantage of a flat file database?

• Ease of data retrieval
• High cost of implementation
• Inefficiency and difficulty in managing large amounts of data
• Limited data security