First Normal Form
In the first normal forms, each field in a table contains different information or data

Task ID # Task Description Employee ID Due Date Last Name
1 Management meeting 02 02/17/2008 Gauss
2 Create Budget 02 01/01/2008 Gauss
3 Employee reviews 01 02/1/2008 Coulomb
4 Employee reviews 02 02/1/2008 Gauss



The first normal form shows all the entities that would be included in the database. All these fields are needed so that the 2nd and 3rd normal form can take place.


Second Formal Normal
In second normal form, each field in a table that is not a determiner of the contents of another field must itself be a function of the other fields in the tables. Here we have two tables, Task (Task_ID, Task_Description, Due_Date) and also Employee (Employee_Id, Last_Name)

Task_ID Task_Description Due_Date
1 Management meeting 02/17/2008
2 Creating Budget 01/01/2008
3 Employee Review 02/01/2008
4 Employee Review 02/01/2008



Employee_ID Last_Name
02 Gauss
01 Coulomb










The diagram above is showing you that one or more employee as one or more task to do.
The TASK is DEPENDENT UPON THE EMPLOYEE
TASK EMPLOYEE

Third Normal Formal

No Duplicate information is permitted. All transitive dependencies are removed. A transitive dependency is when a relation contains data that are not part of the entity.
Task ID Employee ID Date
1 02 02/17/2008
2 02 01/01/2008
3 01 02/01/2008
4 02 02/01/2008



In the third normal form the Task is DEPENDENT UPON the Employee and the Task_date is DEPENDENT TASK.


 
Conclusion

The process of Normalization is removing redundancy in any given table so that the table is easier to modify. A number of normal forms have been developed to remove redundancies that may be found. A normal form is a rule about allowable dependencies. Each normal form removes certain kinds of redundancies.
Normalization create data that are stored only once on a file. It provides ideal data storage for database systems.

What is database management system?
Database management system is a set of computer programs that controls the creation, maintenance, and the use of database with computer as a platform or of an organization-wide database development in the hands of database administrators and other specialists. DBMS is a system software package that helps the use of integrated collection of data records and files known as databases.

What is the primary role of data in business?
A business can be defined as an organization that provides goods and services to others who wants or need them. The primary role of data in a business is to keep record of persons and their information. Data is information that is needed to access and to look at persons records.
How do primary processes relate to data collection activities?
In any organization, data is collected in numerous ways for an ever-increasing number reasons. Data may be abstracted from primary source and collected for unique reporting requirement. When faced with a new application of data, the following factors should be considered. Accountability.
How do primary processes relates to an organization core business?
A business process or business method is a collection of related, structured activities or tasks that produce a specific service or product. A business process begins with a customer need and ends with a customer need fulfillment
Why would you not organize data in a DBMS
Well, if you are not a database personnel who don’t know that you are doing in a business, you will not organize the data. But for the record, data should be organized in a database systems
What is data repository?
Data repository simply means a facility where things can be deposited for storage of safekeeping. It is a data storage unit where the physical data files are kept and is the central storage location for the data content.
What is data dictionary?
There are 2 aspects to the concept of data. The structure of the data consists of the field name, field sizes and data types. The next aspect to it is the actual data values which are stored in the fields. The first part relates to the structure and is stored separately from the database values as the data dictionary or data catalog. Therefore, data dictionary contains data element structures and the relationships among data elements.
What is data access?
This includes the fundamental operations that can be applied to data. Every database management system provides the data some basic access operations. The four basic functions which are provided are READ- data contained in the database, ADD-data in the database, UPDATE-individual parts of the data in the database and DELETE-portions of data in the database.
What is a transaction?
A transaction in SQL (structured query language) is a larger unit of database processing that contains one or more database access operations like insertion ,deletion, retrieval and modification operations.
It is a series of statements or commands that execute as a group. All statements must either run successfully or all must be rolled back. This compensates for errors that might occur during transaction execution. When a transaction is initiated it should complete all the tasks and leave the data in the database in a consistent state. There are two types of transactions: explicit and implicit .This is a Database Terminology.

What is data Abstraction?
Data abstraction helps one to look at data that breaks down into its basic components, giving the us we different ways of looking at the data. In other words it hides the complexities of data design at the levels where they are not required.

What is a cluster index?
A clustered index determines the physical order of data in a table. A clustered index is analogous to a telephone directory, which arranges data by last name. Because the clusted index dictates the physical storage order of the data in the table, a table can contain only one clusted index.

What is a query processor?
A relational database consists of many parts, but at its heart are two major components, the storage engine and the query processor. The query processor accepts SQL syntax, selects a plan for executing the syntax and then executes the chosen plan. It isolates the user from the details of execution

Superkey: a column or combination of columns containing unique values for each row. The combination of every column in a table is always a superkey because rows in a table must be unique.

Referential integrity means that the column values in one table must match column values in a related table.

Candidate key: a minimal superkey. A superkey is minimal if removing any column makes it no longer unique.

Null Value: A special value that represents the absence of an actual value. A null value can mean that the actual value is unknown or does not apply to the given row.

Primary key: a specially designated candidate key. The primary key for a table cannot contain null values.

Foreign key: a column or combination of columns in which the values must match those of the candidate key. A foreign key must have the same data type as its associated candidate key.

Secondary Key: Also known as an alternate key, or in SQL may also be referred to as a key candidate, a secondary key is a data field or location that is used for data searches and retrieval. Also known as an alternate key, or in SQL may also be referred to as a key candidate, a secondary key is a data field or location that is used for data searches and retrieval.

What is Normalization?

Normalization is the process of removing redundancy in a table so that the table is easier to modify. A number of normal forms have been developed to remove redundancies. A normal form is a rule about allowable dependencies. Each normal form removes certain kinds of redundancies.
Normalization create data that are stored only once on a file. It provides ideal data storage for database systems.
There are three steps of data normalization. The first step is to remove all repeating groups and identify the primary key. The second step is to ensure that all nonkey attributes are fully dependent on the primary key. The third step is to remove any transitive dependencies, attributes which are dependent on other nonkey attributes.

First Normal Form (1NF)
First Normal Form prohibits nesting or repeating groups in tables. A table not in 1NF is unnormalized or non normalized. When a table is in the first normal form, all repeating groups are removed. These groups are moved into a new table. The foreign keys are used to link the tables.

Second Normal Form (2NF)
When a table is in Second normal form, all partial dependencies are removed. A partial dependency is when the data are only dependent on a part of a key field. A relation is created for the data that are only dependent on part of the key and another for data that are dependent on both parts.

Third Normal Form (3NF)
All transitive dependencies are removed. A transitive dependency is when a relation contains data that are not part of the entity. The problem with transitive dependencies is updating the data. A single data item may be present on many records.