RelationalDBDesign RelationalDBDesign


Database Design   «Prev  Next»

Relational Database Structure Exercise

Identify Parts of a Relational Database Table

Objective: Identify the key parts of a relational database table (table subject, columns, rows, and primary key).

Exercise scoring

This exercise is worth two points. It is auto-scored. After you complete the prompt below, click Submit to record completion and open the results page.

Overview

This exercise reinforces the lesson on relational table structure by having you interpret a different sample table and describe what each part represents.

Instructions

Review the sample table below, then answer each question in your own words:
  1. What does Reports represent?
  2. What do the columns Editor and DeptName represent?
  3. What does the highlighted row represent?
  4. What does the column ReportID represent?

Hints:

  • Think “subject” for the table name.
  • Think “attributes” for columns.
  • Think “one instance/record” for a row.
  • Think “unique identifier” for the primary key.

Reports table with columns ReportID, Editor, DeptName 

| ReportID | Editor   | DeptName  |
| -------: | -------- | --------- |
|      043 | Flores   | Marketing |
|      044 | Martin   | Sales     |
|      045 | Davidson | Sales     |
Reports table with columns ReportID, Editor, DeptName

Submitting your exercise

Type your responses in the text area below (aim for one short paragraph or bullet per question), then click Submit.