• Practice
  • About 12 min
  • 5 practice questions

Tables, records, fields and DBMS

Name the parts of a database table and explain what a DBMS does, with exam-style counting questions.

If something looks wrong, please tell us.

A database is an organised collection of related data. A Database Management System (DBMS) is the software used to create, store, search and protect that data. Exam questions begin with the vocabulary of a table.

Parts of a table

Terms in a student table
TermMeaningExample
Table (relation)Data arranged in rows and columnsStudent table
Field (attribute)One column: one kind of factName, Class, City
Record (tuple)One row: all facts about one itemOne student's full details
Primary keyA field whose value is unique for every recordRoll number

Why use a DBMS

  • Less repeated (redundant) data.
  • Data stays consistent.
  • Several users can share the data safely.
  • Security and backup are easier to control.
  • Examples of DBMS software include MySQL, PostgreSQL and Oracle; Microsoft Access is a desktop one.

Worked examples

Example 1. A table has 40 students and 6 columns. How many records and fields? Records = 40 (rows). Fields = 6 (columns). Total data cells = 40 x 6 = 240.

Example 2. Which field is best as a primary key in a student table: Name, City or Roll number? Roll number, because names and cities can repeat while roll numbers are unique.

Row = record. Column = field. Primary key = unique for every record.

— Remember this

Key takeaways: rows are records, columns are fields, and the primary key must be unique.

Check your understanding

  1. 1. In a table, one row holding all the facts about one item is called a

    1. Record
    2. Field
    3. Attribute
    4. Relation
    Show answer

    Answer: A. A row is a record (tuple). A column is a field (attribute) and the table itself is a relation.

  2. 2. A table has 25 records and 8 fields. How many data cells does it contain?

    1. 33
    2. 200
    3. 17
    4. 250
    Show answer

    Answer: B. Cells = records x fields = 25 x 8 = 200.

  3. 3. Which field is best as the primary key of a student table?

    1. Name
    2. City
    3. Roll number
    4. Class
    Show answer

    Answer: C. Roll numbers are unique; names, cities and classes can repeat.

  4. 4. Which of these is DBMS software?

    1. Microsoft Word
    2. Adobe Reader
    3. VLC media player
    4. Oracle
    Show answer

    Answer: D. Oracle is a DBMS, like MySQL, PostgreSQL and Microsoft Access. The others are a word processor, a PDF reader and a media player.

  5. 5. Which is a reason to use a DBMS instead of scattered files?

    1. Data stays consistent and can be shared safely
    2. Data is repeated in more places
    3. Security no longer needs to be controlled
    4. Each user keeps a private copy
    Show answer

    Answer: A. A DBMS reduces redundancy, keeps data consistent, and lets several users share it with controlled security.

Sign in to keep track of the lessons you finish.

Next lesson → Keys and relationships between tables

Privacy · Terms · Refunds · Delivery