http://idc.hust.edu.cn/~rxli/
1.1 1.2 1.3 1.4 1.5 1.6 2
1.1 1.1.1 1.1.2 1.1.3 3
1.1.1 Data (0005794, 601,, 1, 1948.03.26, 01) (,,,,,) 4
1.1.1 Database DB 5
1.1.1 (DBMS) DDL ( Create, Drop, Alter) DML( Select, Delete, Insert, Update) 6
1.1.1 (DBS) (DB) DBMS( ) (DBA) 7
1.1.1 8
1.1.2 (50) (50 60) (60) 9
1.1.2 ( ) 00101011 11100101 11001001 10101100 11010100 11110000 01010010 10010000 10000000 main{ int a b c fopen( ); } select * from S insert delete OS DBMS 10
1.1.2 11
1.1.2 12
1.1.2 1% 100% 13
1.1.2 14
1.1.2 15
1.1.2 16
1.1.2 17
1.1.2 18
1.1.2 19
1.1.2 20
1.1.2 21
1.1.2 22
1.1.2 23
1.1.2 24
1.1.2 25
1.1.2 26
1.1.2 27
1.1.2 28
1.1.2 29
1.1.2 30
1.1.3 31
1.1.3 ( ) 32
1.1 1.2 1.3 1.4 1.5 1.6 33
1.2 1.2.0 1.2.1 1.2.2 1.2.3 1.2.4 1.2.5 1.2.6 34
1.2.0 35
1.2.0 36
1.2.0 37
1.2.0 38
1.2.0 39
1.2.1 40
1.2.1 41
1.2.2 (Entity) (Attribute) (Key) & (Domain) 42
1.2.2 ( ) (Entity Type) (Entity Set) (Relationship) 43
1.2.2 (1:1) (1:N) A BN (N>=0) B A (M:N) 44
1.2.2 ( ) 1:1 1:N M:N 45
-(E-R) 1:1 Provinces Cities 46
-(E-R) 1:N Classes Students 01 02 02 01 02 03 04 47
-(E-R) M:N Students Courses 01 02 03 04 CS180 CS182 CD145 48
1.2.2 A A A 1 1 M 1 N N B B B 1:1 1:N M:N 49
1.2.2 0401 0401 0402 1 M 1 1 N N CPU 0401 50
1.2.2 E-R(-) Peter Chen, 1976: Entity-Relationship Model E-R Model, E-R Diagram, E-R Approach E-R 51
1.2.2 E-R (1:1, 1:N, M:N 52
-(E-R) 53
-(E-R) E-R 54
1.2.2 E-R example: Students, Courses and Teachers M N N Sally Sally Joe CS180 CS111 CS180 1 CS180 CS145 CS142 CS143 55
1.2.2 E-R example: M N P 56
M M N P P N 57
1.2.2 E-R example: Manufacturers, Products, Parts N M P A 1 A CPU Intel P4 2 B 1 58
1.2.2 E-R example: Manufacturers, Products, Parts M M N N N M 59
1.2.2 (Design Principles)? 60
1.2.2? 61
1.2.2 N 1? 62
1.2.2 Right: N 1 63
1.2.2 (Sno)(Sdept) (Mname)(Cname) (Grade) Student U {Sno Sdept Mname Cname Grade} k K 64
1.2.2 S (sno, sdept) SG (sno, cname, grade) DEPT (sdept, mname) 65
1.2.2 E-R ( ) ( ) () ( ) ( ) 66
1.2.2, 67
1.2.2 1 n n m p m n 1 n 68
1.2.3 (Hierarchical Model) (Network Model) (Relational Model) (Object Oriented Model) 69
1.2.4 IBM: IMS (1968) R2 R1 R3 R4 R5 R1 R2 R3 R2 R4 R5 70
1.2.4 1 : N 71
1.2.4 D02 N1-436 R01 R02 R03 S0012 S0020 S0199 G1 G2 G3 E1101 E3721 E1234 E3721 72
1.2.4 S C S-C S C C S 73
1.2.4 1 74
1.2.4 2-75
1.2.4 76
(I D U Q) (I D U) 1.2.4 77
1.2.5 (I D U Q) 1 : N 78
1.2.5 S1 S1 S1 C1 C2 A A C1 S2 S2 S2 C1 C2 B A- C2 S3 S3 C1 C S-SC C-SC 79
1.2.5 DBTG 1969 CODASYC Conference On Data System LanguageDBTG Data Base Task Group IDMS DMS1100 IDS/2 IMAGE 80
1.2.6 E.F.Codd: 1970 IBM Oracle DB2 Sybase Informix SQL Server (I D U Q) 81
1.2.6 (key) (domain) 1150 ( ) (1 2 n) 82
1.2.6 S01 21 D01 S02 22 D01 S03 19 D02 ( ) 83
1.2.6 84
1.1 1.2 1.3 1.4 1.5 1.6 85
1.3 1.3.1 1.3.2 1.3.3 86
1.3.1 class person{ public: string name; string address; }; person TOM; person( ) TOMTOM 87
1.3.1 (Type)(Value) 88
1.3.1 (Instance) 89
1.3.2 CODASYL Conference On Data System Language, 90
1.3.2 91
1.3.2 (Schema) 92
1.3.2 (Sub-Schema/External Schema) 93
1.3.3 94
1.3.2 (Storage Schema/Internal Schema) 95
1.3.2 96
1.3.2 97
1.3.3 98
1.3.3 / 99
1.3.3 XH XM CSRQ XB 301 85.07.01 302 84.03.07 Select xh as, xm as, xb as, datediff(year,csrq,getdate()) as From student 301 18 302 19 NO XM XB CSRQ 301 85.07.01 302 84.03.07 Select No as, xm as, xb as, datediff(year,csrq,getdate()) as From student 100
1.3.3 / 101
1.3.3 102
1.1 1.2 1.3 1.4 1.5 1.6 103
1.4 Oracle,Db2, Sybase, SQL Server, Informix DBMS PB,VB,VC DELPHI 104
1.4 105
1.4 DBA 106
1.4 107
1.4 108
1.4 109
110
1.1 1.2 1.3 1.4 1.5 1.6 111
1.5 112
113
114
+ + PDA...... 115
...... 116
1.1 1.2 1.3 1.4 1.5 1.6 117
1.6 E-R DBA 118
1973.Charles W. Bachman 1981. Edgar Frank Codd 1998. James Gray 119
120