Discuss the basic database concept.

1.	Discuss the basic database concept.
Answer» 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.

Answer»

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.

Discussion