To understand this concept you should have knowledge of the E-R Model and Relational Model. if you don't have an idea please go through volume-2 and volume-3
E-R model:
Let us consider the bank database contains four entities Account, Branch, Customer, and loan. for each entity, there are different attributes. These entities are connected with a relationship set. to know more about relationship set go through volume-4
E-R model of Bank Data Base
Relational Model: It is the tabular representation of the E-R Model. the relational model represents the Database as the collection of relation.when a relation taught as a table of values each row in the table representing the collection of related data values.
Conversion:
Domain: A domain is defined as the set of all unique values permitted for an attribute. (The value of a particular relation.)
Tupple: A single row of a table, which contains a single record for that relation is called a tuple. (The value of the Row.)
Relation: The term relation schema refers to a heading paired with a set of constraints defined in terms of that heading. (The value of the Table.)
The four relations are shown below
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments