N5CS: Database Design

Which is a type of simple database consisting of a single table?

• Hierarchical database

• Flat-file database

• Cloud database

• NoSQL database

Answer explanation

A flat-file database is a type of simple database consisting of a single table, making it the correct choice in this scenario.

What type of relationship cardinality between entities do you need to be able to use for N5 Computing Science?

• One-to-one

• Many-to-many

• One-to-many

• Many-to-one

Answer explanation

To use for N5 Computing Science, you need a one-to-many relationship cardinality between entities, allowing one entity to be associated with multiple others.

What database design elements should you be able to create and describe for N5 Computing Science?

• Process flow diagrams using three entities

• Entity-relationship diagrams using two entities

• UML diagrams using four entities

• Gantt charts using five entities

Answer explanation

Entity-relationship diagrams using two entities are the design elements that should be created and described for N5 Computing Science.

For N5 Computing science you should be able to design, create, and explain a query making use of which elements?

• Tables, fields, search criteria, and sort order

• Macros, modules, forms, and reports

• Classes, objects, functions, and variables

• Spreadsheets, cells, formulas, and charts

Answer explanation

For N5 Computing science, a query should involve tables, fields, search criteria, and sort order to design, create, and explain the process effectively.

What type of database model is used in National 5 Computing Science?

• Hierarchical database model

• Network database model

• Relational database model

• Object-oriented database model

Answer explanation

The correct database model used in National 5 Computing Science is the Relational database model.

What is a flat-file database particularly useful for?

• Storing data about a single entity

• Storing data about multiple entities

• Storing data with a single attribute

• Storing data with a single record

Answer explanation

A flat-file database is particularly useful for storing data about a single entity, making it the correct choice among the options provided.

Which of the following is NOT one of the three main elements of a relational database mentioned in the text?

• Entities

• Attributes

• Relationships

• Indexes

Answer explanation

Indexes is NOT one of the three main elements of a relational database mentioned in the text.

In a flat-file database, what is used to represent a record?

• A field

• A column

• A row

• A table

Answer explanation

In a flat-file database, a row is used to represent a record.

What is used to represent a field in a flat-file database?

• A record

• A column

• A row

• A table

Answer explanation

A column is used to represent a field in a flat-file database.

What is meant by an entity in the context of databases?

• A collection of attributes

• A naming convention

• A person, object or thing that we want to store information about

• A type of database system

Answer explanation

A person, object or thing that we want to store information about is what is meant by an entity in the context of databases.