N5CS: Database Design and Development Test (SCHOLAR)

N5CS: Database Design and Development Test (SCHOLAR)

10th Grade

28 Qs

quiz-placeholder

Similar activities

Year 9 Database vs Spreadsheet

Year 9 Database vs Spreadsheet

9th - 12th Grade

24 Qs

Module 2-4:: Part 1 of 2

Module 2-4:: Part 1 of 2

9th - 12th Grade

25 Qs

J277 The use of records to store data

J277 The use of records to store data

9th - 12th Grade

25 Qs

Database Management 1(DBMS1): Summative Assessment

Database Management 1(DBMS1): Summative Assessment

9th - 12th Grade

25 Qs

Introduction to Databases

Introduction to Databases

10th - 11th Grade

24 Qs

Access

Access

KG - University

30 Qs

Database Concepts Quiz

Database Concepts Quiz

9th Grade - University

23 Qs

Intro to IT Ch 7 Quiz Review

Intro to IT Ch 7 Quiz Review

9th - 12th Grade

25 Qs

N5CS: Database Design and Development Test (SCHOLAR)

N5CS: Database Design and Development Test (SCHOLAR)

Assessment

Quiz

Computers

10th Grade

Medium

Created by

Calum Gordon

Used 2+ times

FREE Resource

28 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Nadheera runs a food take-away service. A company called "Let's Just Eat" signs her up to be a supplier on their mobile app that allows people to order food and have it delivered to their homes.

Who is the end user of the mobile app?

People ordering food using the app.

Nadheera and her take-away service.

The "Lets Just Eat" company.

The driver that delivers the food.

Answer explanation

The end user of the mobile app is the people ordering food using the app, as they are the ones utilizing the service to order and receive food.

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does the term functional requirements mean when creating a database system?

A list of the hardware a system should run on.

Performance requirements for the system.

A definition of exactly what the system should do.

A specific instruction for the structure of the database.

Answer explanation

Functional requirements in creating a database system refer to a definition of exactly what the system should do, outlining its specific functionalities.

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an entity in a relational database model?

How two things are related to each other.

A form used with a database.

A person, object or thing we store data about.

A definition of the attributes of a database.

Answer explanation

An entity in a relational database model refers to a person, object, or thing we store data about, making it the correct choice.

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Live Core operate a search engine for web sites. They store the IP address of each user, the words they used in a search, and any link the user clicked on in the search results. These are stored as columns ipaddress, keyword and openedlink in a database.

What do we call ipaddress, keyword and openedlink in the database?

Entities.

Attributes.

Relationships.

Calculated values.

Answer explanation

Attributes are the correct term for ipaddress, keyword, and openedlink in the database as they describe the characteristics of the entities being stored.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

An attribute in a database holds values that are either true or false. What data type should be used for this attribute?

Text.

Number.

Boolean.

Date/Time.

Answer explanation

Boolean data type should be used for an attribute in a database that holds values that are either true or false.

6.

CLASSIFICATION QUESTION

3 mins • 1 pt

Media Image

What is the most appropriate data type for each of the attributes in this entity?

Groups:

(a) Text

,

(b) Number

telephonenumber

appointmentid

visitorname

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

A presence check in a database system:

ensures that a user is present to operate the system.

requires that a value is entered for an attribute.

checks that there are two entities associated with a relationship.

checks that the values entered for an attribute are only those allowed.

Answer explanation

A presence check in a database system requires that a value is entered for an attribute, ensuring data integrity and completeness.

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?