Table and it's operations
Table and it's operations Table/Entity To represent this information one can use DBMS modeling. In a DBMS a group of similar information or data which is of interest to an organization is called an Entity. Entity information is stored in an object called Table. For example, a client is considered an entity. Information about the client entity can be stored in a client_master table. A table is really a two dimensional matrix that consists of rows and columns. Attributes/Columns/Fields Each entity can have a number of characteristics. A client can have characteristics like name, address, telephone number, fax number, balance due etc. The characteristics of an entity are called Attributes. The values for these characteristics are called Attribute Values. When entity information is stored in a table, the attributes associates with the entity are stored in the table columns / table fields. The client_master table can have columns like name, addr...