7517 Section 10 Fundamentals of Databases

What is the purpose of producing a data model from given data requirements for a simple scenario involving multiple entities?

• To create a visual representation of the data structure

• To write SQL queries

• To design the user interface

• To manage network security

What can underlining be used to identify in entity relationship diagrams?

• The relationships between entities

• The attribute(s) which form the entity identifier

• The data types of attributes

• The foreign keys

Which of the following is NOT a term that needs to be defined when explaining the concept of a relational database?

• Attribute

• Primary key

• Composite primary key

• Data warehouse

What is the purpose of normalising relations to third normal form?

• To reduce data redundancy and improve data integrity

• To increase the speed of data retrieval

• To simplify the database schema

• To enhance user interface design

Why is it important to understand why databases are normalised?

• To ensure efficient data storage and retrieval

• To design complex user interfaces

• To manage network security

• To write complex SQL queries

What is SQL used for in a relational database?

• To retrieve, update, insert, and delete data from multiple tables

• To create user interfaces

• To manage network connections

• To design hardware components

What is one of the capabilities of SQL?

• To define a database table

• To create a web page

• To manage operating systems

• To design software applications

What does a client server database system provide?

• Simultaneous access to the database for multiple clients

• Single-user access to the database

• Access to the database only during specific hours

• Access to the database without any security

How can the problem of concurrent access in a client server database be managed?

• By using record locks, serialisation, timestamp ordering, and commitment ordering

• By using only one client at a time

• By shutting down the database periodically

• By using manual data entry

What is 'Big Data' primarily characterised by?

• Small volume, slow velocity, and limited variety

• Large volume, fast velocity, and high variety

• Small volume, fast velocity, and low variety

• Large volume, slow velocity, and limited variety