Transcript FORM AND DATABASE DESIGN

FORM AND
DATABASE DESIGN
A GENERAL
INTRODUCTION TO FORM
AND DATABASE DESIGN
What is database?
Database features

Storing information

Managing information

Retrieving information
WHAT IS DATABASE DESIGN?



It is the process of producing a
detailed data model of a database.
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.
DESIGN PROCESS



Determine the data to be stored in
the database
Determine the relationships
between the different data elements
Superimpose a logical structure
upon the data on the basis of these
relationships.
DATABASE TABLES:



It consists of coloums and rows.
Coloumns contains a different type
of attribute.
Each row corresponds to a single
record.
DATABASE QUERIES:

It is the primary mechanism.

It consists questions.
WHAT IS DATABASE FORM?

It facilitate database data entry.

It has retrieval operations.
PRIMARY KEY:

It is a unique identifier.
NORMALIZATION:

It is the process of structuring
database schema.
FIRST NORMAL FORM
FIRST NORMAL FORM MODEL
ORDER#
CUSTOMER
CONTACT
PERSON
TOTAL
1
Acme
Widgets
Jhon Doe
$134.23
2
ABC
Corporation
Fred
Flinstone
$521.24
3
Acme
Widgets
Jhon Doe
$1042.42
4
Acme
Widgets
Jhon Doe
$928.53
SECOND NORMAL FORM
This relation is 1NF but not 2NF:
ORDER#
CUSTOMER
CONTACT
PERSON
TOTAL
1
Acme
Widgets
Jhon Doe
$134.23
2
ABC
Corporation
Fred
Flinstone
$521.24
3
Acme
Widgets
Jhon Doe
$1042.42
4
Acme
Widgets
Jhon Doe
$928.53
FIRST STAGE
CUSTOMER
CONTACT PERSON
Acme Widgets
Jhon Doe
ABC Corporation
Fred Flinstone
Acme Widgets
Jhon Doe
Acme Widgets
Jhon Doe
SECOND STAGE
ORDER#
CUSTOMER
TOTAL
1
Acme Widgets
$134.23
2
ABC Corporation
$521.24
3
Acme Widgets
$1042.42
4
Acme Widgets
$928.53
THIRD NORMAL FORM
THIS TABLE IS NOT IN THIRD FORM!
COMPANY
CITY
STATE
ZIP
Acme
Widgets
New York
NY
10169
ABC
Corporatio
n
Miami
FL
33196
XYZ, Inc.
Columbia
MD
21046
FIRST STAGE
COMPANY
ZIP
Acme Widgets
10169
ABC Corporation
33196
XYZ, Inc.
21046
SECOND STAGE
CITY
STATE
ZIP
New York
NY
10169
Miami
FL
33196
Columbia
MD
21046
AN
INTRODUCTION TO
FORMS
WHAT CAN A FORM
DESIGNER DO?

user have to know whether how
much time will it take to fill the
form:

Get the point.

Add help information.

Use tables for alignment.


Provide a clear confirmation
message
Layout of form elements