Database Design and Development Flashcards (39 cards)

All cards

1Question

Which applications do database systems support in organisations?

Answer

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

2Question

What role do database systems commonly serve?

Answer

Back-end systems.

3Question

How does relational database design represent structured data?

Answer

In tables.

4Question

Which key types does relational database design specify?

Answer

Primary and foreign keys.

5Question

To what normal form does relational database design normalize data?

Answer

Third normal form.

6Question

How many interrelated tables should a substantial database design contain at minimum?

Answer

Four.

7Question

Which requirements should a substantial database design clearly state?

Answer

User and system requirements.

8Question

What does database implementation map the logical data model to?

Answer

A physical data model.

9Question

What does database implementation link to data sets?

Answer

Code.

10Question

What security considerations apply to databases?

Answer

Permissions, access rights, network vulnerabilities, physical data location, multi-tenancy, data separation, and encryption.

11Question

What can database query tools combine to extract management information?

Answer

Data from multiple tables, manipulated with functions and formulae.

12Question

What does system testing identify before tests are run?

Answer

The components to test.

13Question

What must system testing select for its tests?

Answer

Suitable test data.

14Question

What must system testing document?

Answer

Test procedures and results.

15Question

What does technical documentation describe about a system?

Answer

Its structure and operation.

16Question

What does user documentation explain about a system?

Answer

System use, outputs, menu operations, and other functions.

17Question

Which database model is the practical focus of the unit?

Answer

Relational databases.

18Question

What must database design determine before designing a solution?

Answer

User and system requirements.

19Question

Which designs should a comprehensive database design include?

Answer

Interface and output designs.

20Question

Which data quality processes should a comprehensive database design include?

Answer

Data validation and normalization.

21Question

What should database design security address?

Answer

Security and controls.

22Question

What should database development select?

Answer

Appropriate database, platform, and software options.

23Question

Which external storage may database development use?

Answer

Cloud storage.

24Question

What can database input masks validate?

Answer

Data entered into the database.

25Question

Which concerns should database interfaces address?

Answer

Functionality, reliability, consistency, performance, and accessibility for different users.

26Question

Which legal issues must database development consider?

Answer

GDPR, cross-border data transfers, and other nations’ data-protection regulations.

27Question

Which operations are included in database maintenance and manipulation?

Answer

Inserts, updates, amendments, deletions, backup, and recovery.

28Question

Which tools can produce system reports?

Answer

Report-writing tools, report generators, and dashboards.

29Question

What does structural testing examine?

Answer

The system structure.

30Question

What does functional testing check against expected requirements?

Answer

System functionality.

31Question

Which behaviours and features does testing cover?

Answer

Functional and system behaviour, robustness, help menus, pop-ups, hot-spots, and data-validation checks.

32Question

What must assessment test the system against?

Answer

User and system requirements.

33Question

What must assessment explain when judging test effectiveness?

Answer

The choice of test data.

34Question

What documentation must be delivered for a database system?

Answer

Technical and user documentation.

35Question

What does pass-level relational-system design require for tables and requirements?

Answer

Appropriate tools and techniques for at least four interrelated tables, with clear user and system requirements.

36Question

What must merit-level database implementation include beyond a functional system?

Answer

System security and database maintenance.

37Question

What must distinction-level evaluation assess about a design and solution?

Answer

Their effectiveness against user and system requirements.

38Question

What must distinction-level evaluation suggest about the design and solution?

Answer

Suggested improvements.

39Question

What must distinction-level evaluation identify for continued system effectiveness?

Answer

Improvements needed for continued system effectiveness.

Test yourself with the quiz

Answer 15 questions on Database Design and Development.

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?

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?

Take the quiz →

Read the study guide

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

Read the study guide →

Related classes

Make your own flashcards

Upload your class notes and Revizly writes your flashcards in about a minute.

Flashcard maker