Database Design and Development

From the study guide

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

Read the full study guide →

Practice quiz preview

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?

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

Take the quiz (15 questions) →

Flashcard preview

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.

See all 39 flashcards →

Frequently asked questions

What does the Database Design and Development study guide cover?

It covers the core concepts of Database Design and Development, organized by topic with the key definitions, explanations and takeaways, so it's easier to learn and remember.

Read the full study guide →

How many questions are in the Database Design and Development quiz?

The practice quiz has 15 multiple-choice questions, each with an explanation. Use it to check what you know and find your gaps.

Take the quiz (15 questions) →

How do I study Database Design and Development with flashcards?

There are 39 flashcards on Database Design and Development, with a question on the front and the answer on the back. Try to recall each answer before you flip, and let spaced repetition bring back the ones you miss.

See all 39 flashcards →

Related classes

Turn your own class notes into a study guide

Upload a PDF or paste your notes. Revizly writes a study guide, a practice quiz and flashcards in about a minute.