Mr.WarawutMr.Warawut KhangkhanKhangkhanMr.WarawutMr.Warawut KhangkhanKhangkhanFacebookFacebook: : http://www.facebook.com/AjWarawuthttp://www.facebook.com/AjWarawut

Twitter: Twitter: http://twitter.com/awarawuthttp://twitter.com/awarawutEE--Mail: Mail: awarawut@hotmail.comawarawut@hotmail.com

Mobile: Mobile: 089089--461461--95919591

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 2

Database DesignDatabase Design

DeZign for databases

Mr.Warawut Khangkhan 3Chapter 7 phpMyAdmin

Data DictionaryData Dictionary

Attribute Datatype Length Required Unique

departmentCode (PK) CHAR 2 Y N

Table: tbl_department

departmentItem VARCHAR 80 Y Y

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 4

Data DictionaryData Dictionary

Attribute Datatype Length Required Unique

studentCode(PK) CHAR 11 Y N

Table: tbl_student

prefix VARCHAR 10 Y N

student_firstname VARCHAR 50 Y N

student_lastname VARCHAR 50 Y N

departmentCode (FK) CHAR 2 Y N

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 5

After create table complete to general database/script

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 6

Create DatabaseCreate Database

1

utf8_general_ci2

3

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 7

Import Script SQLImport Script SQL

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 8

Import Script SQLImport Script SQL

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 9

Import Script SQLImport Script SQL

1

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 10

2

Import Script SQLImport Script SQL

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 11

Insert Table Insert Table tbl_departmenttbl_department

2

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 12

1

Insert Table Insert Table tbl_departmenttbl_department

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 13

• ���ก���

• �ก�� ��������

Insert Table Insert Table tbl_departmenttbl_department

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 14

• ���ก���

• �ก�� ��������

Insert Table Insert Table tbl_departmenttbl_department

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 15

View Table View Table tbl_departmenttbl_department

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 16

SQL CommandSQL Command 1

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 17

select *from tbl_department;

2

3

Delete & EditDelete & Edit

Mr.Warawut Khangkhan Chapter 7 phpMyAdmin 18