FORM AND DATABASE

DESIGN

Mert Yüksel Levent Bilen

What is database?

Database

Manage information

Retrieving information

Strore information

Why Do We Use

Database?

Why Do We Use Database

SINGLE USER Faster update

See informaion

Easily.

MULTI USER More complex Take report Easily Share Data Decrease data again

Advantages Of Database

Common Use To Save Space Easy To Update Easy To Access

Security

DataBase Design-Design Process

It is the process of producing a detailed data

This logical data model contains all the needed logical and physical design.

Database design can be used to describe many different parts of the design.

Determine and stored in the database

Determine relationships between the different data elements

To impose a logical structure over the data on the basis of these relationships.

Database Table

It include of coloums and rows.

Coloumns contains a different type of attribute.

Each row have to a single record.

Features

PRIMARY KEY:

Special keys Unique identifier İt is not null One primay key in

the table

EXAMPLE

FIELD P.K TYPE DESCRIPTION

TC_No * TC Kimlik No of the employee

Name Char

Surname Char

SSN Char

Birth_Date Date

Sex Char M of F

Marital_Status Char Married, Divorced, Single, Widowed

Ed_Type Char

Picture Char Path to the picture of the employee on the server

Status Char

NORMALIZATION:

İt is a technique for designing relational database table

It is the process of database schema

FIRST NORMAL FORM

SECOND NORMAL FORM

FIRST STAGE

SECOND STAGE

THIRD NORMAL FORM

FIRST STAGE

SECOND STAGE

AN

INTRODUCTION TO

FORMS

User have to know when the form will finish

FORM

Form designer have to make help information and warning

Provide a clear confirmation message

Provide a clear confirmation message

Make good user interface