Chapter
This presentation is the property of its rightful owner.
Sponsored Links
1 / 33

資料庫原理與應用 PowerPoint PPT Presentation


  • 44 Views
  • Uploaded on
  • Presentation posted in: General

Chapter 12. 12-1  資料的階層架構 12-2  資料庫模式 12-3  資料庫應用實例. 資料庫原理與應用. 位元 (bit) : 電腦的基本單位。 字元 (character) : 這是能夠使用一個位元組來表示的資料。 欄位 (field) : 這是使用者存取資料的最小單位,由一或多個字元所組成。 記錄 (record) : 記錄是由一或多個欄位所組成可以用來識別所有記錄,該欄位稱為主鍵 (primary key) 或鍵欄位 (key field) 。

Download Presentation

資料庫原理與應用

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


6028941

Chapter12

12-1

12-2

12-3


6028941

(bit)

(character)

(field)

(record) (primary key) (key field)

(file)(data file) (program file)

12-1

P.12-2


6028941

(database)

(DBMS)

P.12-3


6028941

P.12-4


6028941

:

P.12-4


6028941

    • (data mining)

    • Web (Web mining)Web

    • (DSS)

<>

P.12-5


6028941

  • (file processing system)

    • :

    • :

  • (DBMS)

    • :

    • :

<>V.S.

P.12-6~12-7


6028941

12-2-1

  • (heirarchical)

12-2

P.12-8


6028941

12-2-2

  • (network)

P.12-9


12 2 3

(relational)(table)(field)(attribute)(record)(tuple)(relation)

12-2-3

P.12-10


6028941

12-2-4

(object-oriented) OQL SQL

12-2-5

(multidimentional) SQL

P.12-11


6028941

12-3-1Microsoft Access

12-3

P.12-12


6028941

(Table)

Access

P.12-13


6028941

(Query)

P.12-13


6028941

(Form)

P.12-14


6028941

(Report)

P.12-14


6028941

(Marco)VBA

P.12-15


6028941

(Module)

P.12-15


12 3 2

12-3-2

P.12-16


6028941

P.12-17

2.

1.


6028941

3.

P.12-18~12-19

5.

4.


6028941

P.12-19~12-20

1.

2.


6028941

1. 2.

P.12-20~12-21


6028941

3. 4.

P.12-21~12-22


6028941

5.6.

7.

P.12-22~12-23


6028941

P.12-23~12-24

1.

2.

4.

3.


6028941

P.12-25


6028941

P.12-26


6028941

P.12-27

  • (DBMS)

  • (file processing system)

  • (DBMS)


6028941

P.12-27

  • (data warehouse) (data mining)Web (Web mining)(DSS)(data mart)

  • (database model) (heirarchical) (network)(relational) (object-oriented) (multidimentional) (object-relational)


6028941

P.12-28

1.

A. B.

C. D.

3. DBMS

A. Excel B. Lotus

C. PageMaker D. Oracle

5.

A.

B.

C.

D.


6028941

P.12-28~29

7.

A. B. Web

C. D.

9.

A. B.

C. D.

11.

A. SQL B. OQL

C. RQL D. MQL


  • Login