- 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
| Term | Meaning | Example |
|---|---|---|
| Table (relation) | Data arranged in rows and columns | Student table |
| Field (attribute) | One column: one kind of fact | Name, Class, City |
| Record (tuple) | One row: all facts about one item | One student's full details |
| Primary key | A field whose value is unique for every record | Roll 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.
Key takeaways: rows are records, columns are fields, and the primary key must be unique.
Check your understanding
-
1. In a table, one row holding all the facts about one item is called a
- Record
- Field
- Attribute
- 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. A table has 25 records and 8 fields. How many data cells does it contain?
- 33
- 200
- 17
- 250
Show answer
Answer: B. Cells = records x fields = 25 x 8 = 200.
-
3. Which field is best as the primary key of a student table?
- Name
- City
- Roll number
- Class
Show answer
Answer: C. Roll numbers are unique; names, cities and classes can repeat.
-
4. Which of these is DBMS software?
- Microsoft Word
- Adobe Reader
- VLC media player
- 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. Which is a reason to use a DBMS instead of scattered files?
- Data stays consistent and can be shared safely
- Data is repeated in more places
- Security no longer needs to be controlled
- 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.