N5CS: Database Design and Development Test (SCHOLAR)

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.

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.

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.

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.

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.

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

Groups:

(a) Text

,

(b) Number

• telephonenumber

• appointmentid

• visitorname

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.

A text field allows the user to enter a single text character with this validation rule: > A AND <= D.

Give an example of a letter that would be accepted as valid input?

Restricting a username to more than six characters and less than twelve is an example of:

• field length validation.

• data entry security.

• restricted choice validation.

• a range check.

Answer explanation

Restricting a username to more than six characters and less than twelve is an example of field length validation, as it enforces specific length criteria for the input data.

The two entities staff and carservice exist for a database system. Part of the data dictionary for this system is: Entity name: carservice.

What would be the best type of validation for the attribute servicedby?

• Restricted choice

• Presence check

• No validation required

• Range check 55-57

Answer explanation

Restricted choice validation would be the best type for the attribute 'servicedby' to limit the selection to specific options, ensuring data integrity.