Study guide: Database Design and Development

Course Outline

  1. Database Roles and Requirements
  2. Relational Database Design
  3. Database Implementation and Security
  4. Queries, Maintenance, and Reporting
  5. Testing Database Systems
  6. Technical and User Documentation
  7. Assessment Standards and Deliverables

1. Database Roles and Requirements

β˜… Must-know

  • Database systems support day-to-day organisational operations, e-commerce, and data-mining applications, and commonly serve as back-end systems.

Further detail

πŸ“Œ Relational databases are the practical focus of the unit, while object-oriented databases receive only a brief overview.

  • Database design must determine user and system requirements before a solution is designed.

2. Relational Database Design

β˜… 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.

3. Database Implementation and Security

β˜… Must-know

  • Implementation maps the logical data model to a physical data model and links code to data sets.

  • Database security considerations include:

    • permissions
    • access rights
    • network vulnerabilities
    • physical location of data
    • multi-tenancy
    • data separation
    • encryption

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:

    • input masks
    • dropdown lists
    • option buttons
  • 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.

4. Queries, Maintenance, and Reporting

β˜… Must-know

  • Database query tools can query across multiple tables and use functions and formulae to manipulate data and extract management information.

Further detail

  • Database maintenance and manipulation include:

    • inserts
    • updates
    • amendments
    • deletions
    • data backup
    • recovery
  • Reporting tools include:

    • report-writing tools
    • report generators
    • dashboards

5. Testing Database Systems

β˜… Must-know

  • System testing identifies components to test, selects suitable test data, matches tests to user and system requirements, and documents the procedures and results.

Further detail

πŸ“Œ Structural testing examines system structure, whereas functional testing checks system functionality against expected requirements.

  • Robustness testing can include:

    • help menus
    • pop-ups
    • hot-spots
    • data-validation checks
  • Assessment requires testing the system against user and system requirements and explaining the choice of test data when assessing test effectiveness.

6. Technical and User Documentation

β˜… 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

  • Technical and user documentation are required deliverables for the database system.

7. Assessment Standards and Deliverables

Essential Points

  • 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.

Test yourself

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?

Take the quiz β†’

Study with flashcards

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.

See the flashcards β†’

Related classes

Make your own study guides

Upload your class notes and Revizly writes a study guide, a quiz and flashcards in about a minute.

Study guide maker