science and technology

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...

What is a database It is a coherent collection of data with some inherent meaning, built and populated with data for a specific purpose. A database stores data that is useful to us. This data is only a part of the entire data available in the world around us. To be able to successfully design and maintain database we have to do the following: Ø   Identify which part of the word’s data is of interest to us. Ø   Identify what specific objects in that part of the word’s data are of interest to us. Ø   Identify a relationship between the objects.   Software houses took up the challenge of designing a system that would help users in managing data in a database. These systems were called Database Management Systems (DBMS). Some of the DBMS developed by software houses were Oracle, Ingress, Sybase, etc. Let us look at Oracle as a Database Management System (DBMS). Introduction to Oracle and Its Tools: The Oracle product is primarily d...