| In large-scale offshore software development | | | | each intersecting point (known as a cell) holds |
| processes, it is seldom required to design the | | | | record and each row (also known as tuple) holds |
| database dynamically so that any extension of | | | | a complete set of records. Every row or tuple is |
| the database does not affect the existing data | | | | further classified using a Primary Key (a field value |
| model. To do so, most of the modern databases | | | | that uniquely describes a set of records). Also, a |
| use database objects to store or reference data. | | | | table can be related to another by using suitable |
| Database objects serve all basic operations like | | | | foreign keys. |
| data addition, deletion, searching and retrieval | | | | Clusters |
| processes in database. Database objects can be | | | | Clusters are physical locations where data is |
| searched for either by primary key or by a | | | | stored for a database. A cluster contains data |
| combination of field-values (related by foreign | | | | from one or more tables with one or more |
| keys). In software product development involving | | | | common columns. All modern relational databases |
| databases, the relationship between various | | | | used in application software and development |
| Database Objects are often described using a | | | | processes create a collection all the rows from all |
| Schema. | | | | the tables which share the same cluster key. |
| The most common database objects are: | | | | Views |
| Tables | | | | A View is a database object that provides a |
| The table is main storage object in a database. A | | | | subset of filtered, sorted and grouped data |
| table is a collection of rows and columns where | | | | retrieved from the database in a predefined way. |