β Must-know
Further detail
π Relational databases are the practical focus of the unit, while object-oriented databases receive only a brief overview.
β Must-know
A relational database design represents structured data in tables and specifies data elements, data types, indexes, primary and foreign keys, entity relationships, and referential integrity.
Relational database design includes normalising data to third normal form.
A design for a substantial problem should contain at least four interrelated tables and clearly state user and system requirements.
Further detail
A comprehensive database design includes interface and output designs, data validations, and data normalisation.
Database designs address data integrity, validation, security, controls, user interfaces, and outputs required by users.
β Must-know
Implementation maps the logical data model to a physical data model and links code to data sets.
Database security considerations include:
Further detail
Database development requires selecting appropriate database, platform, and software options, and may use internal storage or external storage such as the cloud.
Database input controls include:
Database interfaces should address functionality, reliability, consistency, performance, and accessibility for different users, and may link to internet-based applications.
π Database development must consider GDPR issues, cross-border data transfers, and other nationsβ data-protection regulations.
β Must-know
Further detail
Database maintenance and manipulation include:
Reporting tools include:
β Must-know
Further detail
π Structural testing examines system structure, whereas functional testing checks system functionality against expected requirements.
Robustness testing can include:
Assessment requires testing the system against user and system requirements and explaining the choice of test data when assessing test effectiveness.
β Must-know
π Technical documentation describes system structure and operation, including diagrams of data movement and flowcharts of how the system works, whereas user documentation explains system use, outputs, menu operations, and other functions.
Further detail
Pass-level design requires appropriate tools and techniques for a relational system with at least four interrelated tables and clear user and system requirements.
Merit-level implementation requires a fully functional database system that includes system security and database maintenance.
Distinction-level evaluation addresses design and solution effectiveness against user and system requirements, suggested improvements, and improvements needed for continued system effectiveness.
Take a 15-question practice quiz on Database Design and Development, with every answer explained.
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?
Memorize the key concepts of Database Design and Development with 39 flashcards.
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.
Upload your class notes and Revizly writes a study guide, a quiz and flashcards in about a minute.
Study guide maker