1 Answers
1. The Table is the basic data storage unit in a Relational database.
2. The table consists of columns and rows.
3. A database consists of one or more tables according to which data is stored in a table.
4. The database designer decides the name of the table and the titles of columns.
5. A record is composed of fields and contains all the data about one particular person, company, or item in a database.
6. Record is also called a Tuple,
7. A column or a combination of columns that can be used to identify one or more rows (tuples) in a table is called a Key of the table.
8. The group of one or more columns used to uniquely identify each row of a relation is called its Primary Key.
9. Foreign Key is a field (or collection of fields) in one table that refers to the Primary Key in another table.