Page 87 - DCAP508_DATABASE_ADMINISTRATION

Unit 5: SQL Server Databases

In planning the database, regardless of its size and complexity, use the following basic Notes
steps:

Gather information
Identify the objects
Model the objects
Identify the types of information for each object

Identify the relationships between objects.
To create a database determine the name of the database, its owner (the user who creates
the database), its size, and the files and file groups used to store it.

Three types of files are used to store a database: Primary files, Secondary Files and
Transaction Log.
To create a database in SQL server you use either of the following tools:

Transact-SQL
Enterprise Manager
SQL-DMO
Tables are database objects that contain all the data in a database. A table definition is a
collection of columns. In tables, data is organized in a row-and-column format similar to
a spreadsheet. Each row represents a unique record, and each column represents a field
within the record.
Constraints define rules regarding the values allowed in columns and are the standard
mechanism for enforcing integrity.

The Database Designer is a visual tool that allows you to design and visualize a database
to which you are connected.

A view is a virtual table whose contents are defined by a query. Like a real table, a view
consists of a set of named columns and rows of data.
When you use Transact-SQL programs, two methods are available for storing and executing
the programs. You can store the programs locally and create applications that send the
commands to SQL Server and process the results, or you can store the programs as stored
procedures in SQL Server and create applications that execute the stored procedures and
process the results.

5.12 Keywords

Categorical Columns: These columns classify or group the data and store a limited selection of
data such as true/false, married/single, and VP/Director/Group Manager.
Check Constraint: A CHECK constraint specifies a Boolean (evaluates to TRUE, FALSE, or
unknown) search condition that is applied to all values that are entered for the column.
Constraints: Constraints define rules regarding the values allowed in columns and are the
standard mechanism for enforcing integrity.

Databases: A database in SQL Server is made up of a collection of tables.
FOREIGN KEY constraints: FOREIGN KEY constraints identify and enforce the relationships
between tables.

LOVELY PROFESSIONAL UNIVERSITY 81