FORM AND DATABASE DESIGN Mert Y

1
FORM AND DATABASE DESIGN Mert Yüksel
Levent Bilen
2
What is database?

• Database
• Manage information
• Retrieving information
• Strore information

3
Why Do We Use Database?
4
Why Do We Use Database

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

• SINGLE USER
• Faster update
• See informaion
• Easily.

5
Advantages Of Database

• Common Use
• To Save Space
• Easy To Update
• Easy To Access
• Security

6
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.

7
Database Table
Features

• It include of coloums and rows.
• Coloumns contains a different type of attribute.
• Each row have to a single record.

8
PRIMARY KEY

• Special keys
• Unique identifier
• It is not null
• One primay key in the table

9
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
10
NORMALIZATION

• It is a technique for designing relational
  database table
• It is the process of database schema

11
FIRST NORMAL FORM
12
SECOND NORMAL FORM
13
FIRST STAGE
14
SECOND STAGE
15
THIRD NORMAL FORM
16
FIRST STAGE
17
SECOND STAGE
18

• AN
• INTRODUCTION TO
• FORMS

19
FORM

• User have to know when the form will finish

20
Form designer have to make help information and
warning
21
Provide a clear confirmation message
22
Provide a clear confirmation message
23
Make good user interface