FORM AND DATABASE DESIGN

download report

Transcript FORM AND DATABASE DESIGN

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

Determine and stored in
the database

This logical data model
contains all the needed
logical and physical
design.

Determine relationships
between the different
data elements

To impose a logical
structure over the data
on the basis of these
relationships.

Database design can be
used to describe many
different parts of the
design.
Database Table
Features

It include of coloums and
rows.

Coloumns contains a
different type of attribute.

Each row have to a single
record.
PRIMARY KEY:




Special keys
Unique identifier
İt is not null
One primay key in
the table
EXAMPLE
FIELD
P.K
TC_No
*
TYPE
DESCRIPTION
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
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
FORM

User have to know when the form will
finish
Form designer have to make help information and warning
Provide a clear confirmation
message
Provide a clear confirmation
message
Make good user interface