Data Base

• keeps a record of all the system information in
• a SQL server system.

• information of a data that is to be
• stored

• schedules alerts and jobs by other features such
• as database mail.

• is a global resource that holds temporary user
• objects and internal objects and is available to anyone connected to the SQL server.

is a history of actions carried out by the database management system to ensure ACID properties over hardware failures and crashes.

is code that is performed in response to certain events within a particular table.

is a way of showing information in the database. It holds the results of a query.

It is a set of statements that is stored in compiled form so it can be used by other programs.

allows definition for data types the construct the behaviour in an application.

• [<role>_]
• <attribute>_
• <property>

it has one name in the entire schema.

• no repeating groups
• data is independent

• 1 nf
• each column dependant only on the whole key
• using artificial keys will insure you are in 2nf

• 2nf
• no column can be dependent on any other non-key column
• you cannot have calculated data

• speed
• security
• application modularization

data file

log file

<= 30% fragmented

>30% fragmented