COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
. A relational database consists of a collection of
|
Tables
|
|
Fields
|
|
Records
|
|
Keys
|
Explanation:
Detailed explanation-1: -A relational database management system (RDBMS) stores and retrieves data that is represented in tables. A relational database consists of a collection of tables that store interrelated data.
Detailed explanation-2: -To support a one-to-many relationship, we need to design two tables: a table Classes to store information about the classes with classID as the primary key; and a table Teachers to store information about teachers with teacherID as the primary key.
Detailed explanation-3: -A table has records (rows) and fields (columns).
There is 1 question to complete.