?????PROJECT

1
?????PROJECT
????
49835010 ??? 49835013 ??? 49835027
??? 49835008 ??? 49835047 ???
2
????

• ????
• ????
• ????
• ER-modle
• Table SQL
• FD diagram 3NF??
• ?????

3
?????

• ????????
• ???????? ???
• ER-modle??? ??? ???
• FD?????
• ???????
• ????????
• ???? ???

4
? Motive

• ????????????,??????????????????,????????????,?????
  ????
• ???????????????????,????????????????????????
• ????????,???????????,???????????????????????,?????
  ??,???????????????,???????????

5
? Purpose

• ???????????,?????????,???????
• ???????????????,???????????????
• ????????????????????????????

6
ER-MODEL
7
??
????
ISBN
??
??
??
??
??
????
???
??
??
????
? ? ? ?
??
??
??
??
????
??
????
??
????
??
??
??
??
??
??
??
8
(No Transcript)
9
TABLE SQL
10
??(Member)
??SQL?? CREATE TABLE Member ( name CHAR(150)
NOT NULL, sexuality CHAR(100) NOT NULL, phone
INT(30) NOT NULL, address CHAR(250) NOT NULL,
store CHAR(100) NOT NULL, member id CHAR(100)
NOT NULL, primary key (member id))
11
????(Bookstore)
??(Book)
12
??(employee)
??(Sale)
13
FD diagram 3NF
14
??(Member)
?????1NF(???). 2NF(???????P key-m_no).
3NF(?P key?????????)
15
????(Bookstore)
?????1NF(???). 2NF(???????P key-m_no).
3NF(?P key?????????)
16
??(Book)
?????1NF(???). 2NF(???????P key-m_no).
3NF(?P key?????????)
17
??(employee)
?????1NF(???). 2NF(???????P key-m_no).
3NF(?P key?????????)
18
??(Sale)
?????1NF(???). 2NF(???????P key-m_no).
3NF(?P key?????????)
19
?????
20
?????????
21
????
22
??????
23
????
24
??????
25
???????
26
???????
27
??????
28
????????
29
??????
30
????????
31
????-?????
32
????
33
???????
34
???????
35
??-?????
????????????
36
????
37
???????
38
???????
39
????
40
??

• ??????????????????????????????????
• ??????????????????????,??????,??????????????
• ??????DB project?????,????????????????????????,??
  ???????????,??????????????????????,?????????,?????
  ??????

41
???????????????????????,?????????,?????????????,?
????????????????,???????? ?????DB???,???????????
????,?????PHP?????,?????,??????,??????,???????????
????? ??????????????????????,???????,??????,????
???????????????????,????????,???????
?????????????????,??????????????????????,?????????
????
42
????

• Dreamwaver
• Appserv