Information Systems Quiz

What is the main purpose of information systems?

• Sorting data alphabetically

• Providing end users with access to information

• Creating data redundancy

• Slowing down data retrieval

Which tool is used to organise data in an information system?

• Data analysis

• Data dictionaries

• Data redundancy

• Data manipulation

What type of system collects, stores, modifies, and retrieves daily transactions of an organisation?

• Decision support system (DSS)

• Expert system

• Transaction processing system (TPS)

• Relational database system

How do information systems help decision making?

• By slowing down the decision-making process

• By providing irrelevant information

• By assisting with information, models, and analysis tools

• By creating data redundancy

What is the purpose of a primary key field in a relational database?

• To store data redundantly

• To provide access to external communication

• To uniquely identify each record

• To organise data into a single table

What is the main aim of normalisation of data in a database?

• To increase data redundancy

• To make the database structure less efficient

• To reduce data redundancy

• To complicate data retrieval

What do data dictionaries contain information about?

• Data redundancy

• Data relationships

• Data attributes and descriptions

• Data confusion

What is the purpose of a schema in a database?

• To confuse users with complex terminology

• To standardise data entry

• To provide documentation for the database

• To eliminate the need for data normalisation

Which type of database organises data using related tables?

• Flat-file database

• Relational database

• Hierarchical database

• Network database

What is the role of a foreign key in a database?

• It is the primary key of another table

• It is used for data redundancy

• It slows down data retrieval

• It organises data into information