untitled

Size: px

Start display at page:

Download "untitled"

呆鲁
9 years ago
Views:

4 1.1.1 Data ( , 601,, 1, , 01) (,,,,,) 4

5 1.1.1 Database DB 5

6 1.1.1 (DBMS) DDL ( Create, Drop, Alter) DML( Select, Delete, Insert, Update) 6

7 1.1.1 (DBS) (DB) DBMS( ) (DBA) 7

9 1.1.2 (50) (50 60) (60) 9

10 1.1.2 ( ) main{ int a b c fopen( ); } select * from S insert delete OS DBMS 10

13 % 100% 13

32 1.1.3 ( ) 32

42 1.2.2 (Entity) (Attribute) (Key) & (Domain) 42

43 1.2.2 ( ) (Entity Type) (Entity Set) (Relationship) 43

44 1.2.2 (1:1) (1:N) A BN (N>=0) B A (M:N) 44

45 1.2.2 ( ) 1:1 1:N M:N 45

46 -(E-R) 1:1 Provinces Cities 46

47 -(E-R) 1:N Classes Students

48 -(E-R) M:N Students Courses CS180 CS182 CD145 48

49 1.2.2 A A A 1 1 M 1 N N B B B 1:1 1:N M:N 49

50 M 1 1 N N CPU

51 1.2.2 E-R(-) Peter Chen, 1976: Entity-Relationship Model E-R Model, E-R Diagram, E-R Approach E-R 51

52 1.2.2 E-R (1:1, 1:N, M:N 52

53 -(E-R) 53

54 -(E-R) E-R 54

55 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

56 1.2.2 E-R example: M N P 56

57 M M N P P N 57

58 1.2.2 E-R example: Manufacturers, Products, Parts N M P A 1 A CPU Intel P4 2 B 1 58

59 1.2.2 E-R example: Manufacturers, Products, Parts M M N N N M 59

60 1.2.2 (Design Principles)? 60

61 1.2.2? 61

62 1.2.2 N 1? 62

63 1.2.2 Right: N 1 63

64 1.2.2 (Sno)(Sdept) (Mname)(Cname) (Grade) Student U {Sno Sdept Mname Cname Grade} k K 64

65 1.2.2 S (sno, sdept) SG (sno, cname, grade) DEPT (sdept, mname) 65

66 1.2.2 E-R ( ) ( ) () ( ) ( ) 66

67 1.2.2, 67

68 n n m p m n 1 n 68

69 1.2.3 (Hierarchical Model) (Network Model) (Relational Model) (Object Oriented Model) 69

70 1.2.4 IBM: IMS (1968) R2 R1 R3 R4 R5 R1 R2 R3 R2 R4 R5 70

71 : N 71

72 1.2.4 D02 N1-436 R01 R02 R03 S0012 S0020 S0199 G1 G2 G3 E1101 E3721 E1234 E

73 1.2.4 S C S-C S C C S 73

77 (I D U Q) (I D U)

78 1.2.5 (I D U Q) 1 : N 78

79 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

80 1.2.5 DBTG 1969 CODASYC Conference On Data System LanguageDBTG Data Base Task Group IDMS DMS1100 IDS/2 IMAGE 80

81 1.2.6 E.F.Codd: 1970 IBM Oracle DB2 Sybase Informix SQL Server (I D U Q) 81

82 1.2.6 (key) (domain) 1150 ( ) (1 2 n) 82

83 1.2.6 S01 21 D01 S02 22 D01 S03 19 D02 ( ) 83

87 1.3.1 class person{ public: string name; string address; }; person TOM; person( ) TOMTOM 87

88 1.3.1 (Type)(Value) 88

89 1.3.1 (Instance) 89

90 1.3.2 CODASYL Conference On Data System Language, 90

92 1.3.2 (Schema) 92

93 1.3.2 (Sub-Schema/External Schema) 93

95 1.3.2 (Storage Schema/Internal Schema) 95

99 1.3.3 / 99

100 1.3.3 XH XM CSRQ XB Select xh as, xm as, xb as, datediff(year,csrq,getdate()) as From student NO XM XB CSRQ Select No as, xm as, xb as, datediff(year,csrq,getdate()) as From student 100

101 1.3.3 / 101

102

103

104 1.4 Oracle,Db2, Sybase, SQL Server, Informix DBMS PB,VB,VC DELPHI 104

105

106 1.4 DBA 106

107

108

109

110 110

111

112

113 113

114 114

115 + + PDA

116

117

118 1.6 E-R DBA 118

119 1973.Charles W. Bachman Edgar Frank Codd James Gray 119

120 120

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘

學科 100% ( 為單複選題, 每題 2.5 分, 共 100 分 ) 1. 請參閱附圖作答 : (A) 選項 A (B) 選項 B (C) 選項 C (D) 選項 D Ans:D 2. 下列對於資料庫正規化 (Normalization) 的敘 ITE 資訊專業人員鑑定資料庫系統開發與設計實務試卷編號 :IDS101 注意事項一本測驗為單面印刷試題, 共計十三頁第二至十三頁為四十道學科試題, 測驗時間 90 分鐘 : 每題 2.5 分, 總測驗時間為 90 分鐘二執行 CSF 測驗系統 -Client