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.
Which key types does relational database design specify?
Primary and foreign keys.
To what normal form does relational database design normalize data?
Third normal form.
How many interrelated tables should a substantial database design contain at minimum?
Four.
Which requirements should a substantial database design clearly state?
User and system requirements.
What does database implementation map the logical data model to?
A physical data model.
What does database implementation link to data sets?
Code.
What security considerations apply to databases?
Permissions, access rights, network vulnerabilities, physical data location, multi-tenancy, data separation, and encryption.
What can database query tools combine to extract management information?
Data from multiple tables, manipulated with functions and formulae.
What does system testing identify before tests are run?
The components to test.
What must system testing select for its tests?
Suitable test data.
What must system testing document?
Test procedures and results.
What does technical documentation describe about a system?
Its structure and operation.
What does user documentation explain about a system?
System use, outputs, menu operations, and other functions.
Which database model is the practical focus of the unit?
Relational databases.
What must database design determine before designing a solution?
User and system requirements.
Which designs should a comprehensive database design include?
Interface and output designs.
Which data quality processes should a comprehensive database design include?
Data validation and normalization.
What should database design security address?
Security and controls.
What should database development select?
Appropriate database, platform, and software options.
Which external storage may database development use?
Cloud storage.
What can database input masks validate?
Data entered into the database.
Which concerns should database interfaces address?
Functionality, reliability, consistency, performance, and accessibility for different users.
Which legal issues must database development consider?
GDPR, cross-border data transfers, and other nations’ data-protection regulations.
Which operations are included in database maintenance and manipulation?
Inserts, updates, amendments, deletions, backup, and recovery.
Which tools can produce system reports?
Report-writing tools, report generators, and dashboards.
What does structural testing examine?
The system structure.
What does functional testing check against expected requirements?
System functionality.
Which behaviours and features does testing cover?
Functional and system behaviour, robustness, help menus, pop-ups, hot-spots, and data-validation checks.
What must assessment test the system against?
User and system requirements.
What must assessment explain when judging test effectiveness?
The choice of test data.
What documentation must be delivered for a database system?
Technical and user documentation.
What does pass-level relational-system design require for tables and requirements?
Appropriate tools and techniques for at least four interrelated tables, with clear user and system requirements.
What must merit-level database implementation include beyond a functional system?
System security and database maintenance.
What must distinction-level evaluation assess about a design and solution?
Their effectiveness against user and system requirements.
What must distinction-level evaluation suggest about the design and solution?
Suggested improvements.
What must distinction-level evaluation identify for continued system effectiveness?
Improvements needed for continued system effectiveness.
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?
Go over the full study guide for Database Design and Development.
Read the study guide →Upload your class notes and Revizly writes your flashcards in about a minute.
Flashcard maker