lesson 02/06/2020 Databases

Question 1

What are the characteristics of a serial file

Answer 1

• Store data in the order it was entered
• No order to the data is maintained
• useful for storing transnational data and initialisation files

Question 2

What are the characteristics of a sequential file

Answer 2

• stores data in order of a key field
• the order is maintained when new records are added
• useful for storing master files

Question 3

What are the characteristics of a indexed sequential file

Answer 3

-maintain an index to allow groups of records to be accessed quickly

Question 4

What does a database management system provide

Answer 4

• a manipulation language to access and change the data
• additional security
• program/data independence

Question 5

what are database components made of

Answer 5

-tables that store data in rows and columns