Pr.Pg Next Pg

Understanding Database Terms Tutorials

 

Database

  • Database can store Tables, View, Store Procedures, Triggers, index and many other objects. Primary it is used to store Tables.

 

Tables

  • SQL Server database consists of a collection of tables that store specific sets of structured data. A table (entity) contains a collection of rows (tuples) and columns (attributes).

  • Each column in the table is designed to store a certain type of information (for example, dates, names, dollar amounts, or numbers).

  • In SQL Server, a table is a two dimensional database object that consists of a collection of columns and rows, similar to a spread-sheet and contains all the data in the database.

  • Each row represents a unique record and each column represents a data field within the record.

  • In addition, SQL Server tables also contain other database objects, such as views, indexes, stored procedures and triggers that are used to support activities performed with the data in a relational database.

  • SQL Server tables can also have indexes similar to those in books that allow an application to quickly identify and retrieve data in a particular row or set of rows in a table.

 

Columns

  • A SQL Server table is defined by columns that comprise it. Each column in the table is designed to store a certain type of information and each column in the table has a set of properties that define the column’s characteristics.

  • These include the column name, the data type, and data length that must be defined before you can save a table in your database.

·         The column name must be specific to the table.

·         The data type defines the type of data the rows in the column can hold. SQL Server 2000 has a wide range of system data types that you can define for each column. The more common SQL Server 2000 system data types are listed in following Table. In addition, SQL Server 2000 allows you to create User-defined data types by allowing a user to modify the system data types.

·         The data length defines the length or range of data that the rows in the column are allowed to hold.

 

Comparing Database Terms

Development Style

The List of Common Items

An Item in the List

A Piece of Information in the List

Legacy software

File

Record

Field

Spreadsheet

Spreadsheet/worksheet

Row

Column/Cell

Relational algebra/

logical design

Entity, or relation

Tuple (rhymes with

couple)

Attribute

 

Object Oriented Database (OQL Query)

Object

Object Data

Object Attribute

SQL Server

Table

Row

Column


 

Pr.Pg border                                              Next Pg