☞ Following are the basic terms related to Relational database.
1. Entity / Relation 2. Attributes 3. Tuple 4. Cardinality 5. Degree 6. Domain 7. Body of the Relation
☞ It is something that exists and about which we can store some information.
☞ It is the name of the table
☞ Example : Student entity, employee entity
☞ Each column in a table is known as attribute.
☞ Each row in a table is known as tuple.
☞ It is the number of records.
☞ It is the number of attributes.
☞ It is the set of all possible values that an attribute may contain.
☞ It consists of an unordered set of 0 or more records/tuples.