Database Design and Development Practice Quiz (15 questions)

All questions and answers

1. An organisation uses one database to record daily business transactions, support online purchases, and supply data for analytical mining. Which role best describes this database system within the organisation?

A development platform for designing and testing database systems
A back-end supporting operations, e-commerce, and data mining
An analytics tool focused on data mining rather than operations
A user interface supporting operations, e-commerce, and data mining

A back-end supporting operations, e-commerce, and data mining

Explanation

Database systems commonly serve as back ends and support day-to-day operations, e-commerce, and data-mining applications. Treating the system as a user interface confuses its role, while the other choices wrongly narrow its functions or replace them with development tasks.

2. A team is about to design a database solution for a new service, but it has not yet established what users need or what the system must do. What should the team determine first?

Testing procedures for the completed system
Technical and user documentation formats
Database platform and implementation tools
User and system requirements

User and system requirements

Explanation

Database design should establish user and system requirements before a solution is designed, so those needs can guide the design. Choosing tools, testing the completed system, or preparing documentation does not replace first determining the requirements.

3. A designer is preparing a logical model for a relational database. Which set of elements should the design specify?

Tables, data elements and types, indexes, and reports without key relationships
Tables, storage platforms, deployment settings, and user-interface layouts
Tables, data elements and types, indexes, keys, relationships, and referential integrity
Data elements and types, reports, validations, and security controls

Tables, data elements and types, indexes, keys, relationships, and referential integrity

Explanation

A relational design represents structured data in tables and specifies data elements, data types, indexes, primary and foreign keys, entity relationships, and referential integrity. Storage and deployment choices concern implementation, while reports and controls do not substitute for the specified relational structures.

4. A project team is designing a database for a substantial business problem. Which proposal meets the stated design expectation for tables and requirements?

At least four interrelated tables with clear user and system requirements
Three interrelated tables with clear user and system requirements
At least four interrelated tables with user requirements but no system requirements
At least four independent tables with clear user and system requirements

At least four interrelated tables with clear user and system requirements

Explanation

A design for a substantial problem should include at least four interrelated tables and clearly state both user and system requirements. Independent tables fail the interrelationship criterion, while the other alternatives fall short on table count or omit a type of requirement.

5. A designer has completed the initial relational schema and is checking whether the planned design includes the specified level of data normalisation. Which target should the designer use?

Third normal form
Referential integrity
Fourth normal form
First normal form

Third normal form

Explanation

Relational database design includes normalising data to third normal form. First normal form is a lower target, fourth normal form is not the stated design requirement, and referential integrity is a separate design concern.

6. A team has completed a logical database design and is preparing the working system. Which implementation task directly connects that design to the running application?

Map the physical model back to a logical model and link code to user roles
Select a database platform without connecting application code to data
Add input masks and dropdown lists without mapping the data model
Map the logical model to a physical model and link code to data sets

Map the logical model to a physical model and link code to data sets

Explanation

Implementation turns the logical data model into a physical model and links code to data sets. Mapping physical design back to logical design reverses the relationship; input controls address validation; platform selection is a separate development decision.

7. A company is evaluating a cloud-hosted database used by several customer organizations. Which review best addresses database security concerns relevant to this arrangement?

Review permissions and access rights, treating network exposure and encryption as operational matters
Review the provider’s physical data location, treating permissions and network risks as application features
Review permissions, access rights, network vulnerabilities, data location, multi-tenancy, data separation, and encryption
Review data separation and encryption, treating multi-tenancy as a backup concern

Review permissions, access rights, network vulnerabilities, data location, multi-tenancy, data separation, and encryption

Explanation

Database security includes permissions and access rights as well as network vulnerabilities, physical data location, multi-tenancy, data separation, and encryption. Focusing on permissions alone omits technical risks; treating separation as encryption confuses distinct controls; checking location alone overlooks access and network concerns.

8. A manager needs a summary combining customer records from one table with purchase records from another, including a calculated total. Which approach best meets this need?

Use a query across both tables with a function or formula
Use a single-table query and calculate the total from customer fields
Use a dashboard to join the tables and calculate the total without a query
Use update and insert operations to combine the records

Use a query across both tables with a function or formula

Explanation

Query tools can work across multiple tables and use functions or formulae to extract management information. A single-table query omits purchase data; inserts and updates modify records rather than answer the query; dashboards present information but are not a substitute for the described query operation.

9. A database team needs to present system information in a structured report or visual overview. Which set of tools is intended for producing these outputs?

Report-writing tools, report generators, and dashboards
Backup and recovery tools
Insert, update, and deletion tools
Cross-table query functions and formulae

Report-writing tools, report generators, and dashboards

Explanation

System reports can be produced with report-writing tools, report generators, and dashboards. Inserts and deletions modify data, backup and recovery protect or restore it, and query functions and formulae extract or manipulate information rather than serve as the listed reporting tools.

10. A team is preparing tests for a newly built database system. Which plan best follows a complete system-testing process?

Select representative data, test user requirements, and leave procedures undocumented
Identify components, select suitable data, match tests to requirements, and document procedures and results
Record test results after checking functionality, without identifying components or test data
Inspect system structure, select sample data, and document only failed tests

Identify components, select suitable data, match tests to requirements, and document procedures and results

Explanation

System testing identifies components, selects suitable test data, matches tests to user and system requirements, and documents both procedures and results. Focusing on structure, omitting documentation, or skipping test planning leaves out parts of that process.

11. A tester examines whether a database's internal design follows its intended structure, then checks whether its outputs meet specified user requirements. Which classification fits these two checks, respectively?

Structural testing, then functional testing
Functional testing, then structural testing
Functional testing, then functional testing
Structural testing, then structural testing

Structural testing, then functional testing

Explanation

Structural testing examines how the system is structured, while functional testing checks its behavior against expected requirements. Reversing the labels confuses the two purposes; using one label for both overlooks their distinction.

12. A database project needs two documents: one for developers tracing data movement and system operation, and another for users learning outputs and menu operations. Which document assignment is appropriate?

User documentation for data movement and operation; technical documentation for outputs and menus
Technical documentation for both data movement and operation and outputs and menus
User documentation for both data movement and operation and outputs and menus
Technical documentation for data movement and operation; user documentation for outputs and menus

Technical documentation for data movement and operation; user documentation for outputs and menus

Explanation

Technical documentation describes system structure and operation, including data-flow diagrams, whereas user documentation explains use, outputs, menus, and functions. Reversing the assignments confuses their audiences, and assigning both roles to one document type misses the distinction.

13. Which pair of documents is required as a deliverable for the database system?

A database schema and a user interface prototype
Technical documentation and user documentation
A test plan and testing results
Technical documentation and a test plan

Technical documentation and user documentation

Explanation

The database system requires both technical and user documentation as deliverables. A test plan, results, schema, or prototype may support the project, but they do not replace the required documentation pair.

14. A team is designing a relational database for a substantial problem and is preparing a submission at pass level. Which design deliverable meets the stated standard?

A design using appropriate tools and techniques, at least four interrelated tables, and clear user and system requirements
A design using appropriate tools and techniques, three interrelated tables, and clear user and system requirements
A design using appropriate tools and techniques, at least four interrelated tables, and unclear user and system requirements
A functioning database with security and maintenance, but no documented relational design

A design using appropriate tools and techniques, at least four interrelated tables, and clear user and system requirements

Explanation

Pass-level design requires appropriate tools and techniques, at least four interrelated tables, and clear user and system requirements. Three tables falls short of the table requirement, unclear requirements omit a stated element, and security and maintenance concern implementation.

15. A database solution has been built and evaluated for a distinction-level submission. Which evaluation provides the required coverage?

Evaluates design effectiveness against user and system requirements and identifies improvements needed for continued effectiveness, without evaluating the solution
Evaluates solution effectiveness against user and system requirements and suggests improvements, without identifying changes needed for continued effectiveness
Evaluates design and solution effectiveness against user and system requirements, suggests improvements, and identifies improvements needed for continued effectiveness
Suggests improvements to the solution and identifies maintenance tasks, without assessing effectiveness against user and system requirements

Evaluates design and solution effectiveness against user and system requirements, suggests improvements, and identifies improvements needed for continued effectiveness

Explanation

Distinction-level evaluation covers the design and solution in relation to user and system requirements, recommends improvements, and identifies improvements needed to maintain effectiveness over time. Evaluating only the design omits the solution; recommendations without assessing effectiveness omit the evaluative comparison; current recommendations alone omit continued effectiveness.

Study with flashcards

Lock in the answers with 39 flashcards on Database Design and Development.

Which applications do database systems support in organisations?

Day-to-day operations, e-commerce, and data mining.

What role do database systems commonly serve?

Back-end systems.

How does relational database design represent structured data?

In tables.

See the flashcards →

Read the study guide

Go over the full study guide for Database Design and Development.

Read the study guide →

Related classes

Make your own practice quizzes

Upload your class notes and Revizly writes a practice quiz with explained answers in about a minute.

Quiz maker