Chapter
Download
1 / 33

資料庫原理與應用 - PowerPoint PPT Presentation


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

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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


Chapter12

12-1

12-2

12-3


(bit)

(character)

(field)

(record) (primary key) (key field)

(file)(data file) (program file)

12-1

P.12-2


(database)

(DBMS)

P.12-3


P.12-4


:

P.12-4


    • (data mining)

    • Web (Web mining)Web

    • (DSS)

<>

P.12-5


  • (file processing system)

    • :

    • :

  • (DBMS)

    • :

    • :

<>V.S.

P.12-6~12-7


12-2-1

  • (heirarchical)

12-2

P.12-8


12-2-2

  • (network)

P.12-9


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

12-2-3

P.12-10


12-2-4

(object-oriented) OQL SQL

12-2-5

(multidimentional) SQL

P.12-11


12-3-1Microsoft Access

12-3

P.12-12


(Table)

Access

P.12-13


(Query)

P.12-13


(Form)

P.12-14


(Report)

P.12-14


(Marco)VBA

P.12-15


(Module)

P.12-15


12-3-2

P.12-16


P.12-17

2.

1.


3.

P.12-18~12-19

5.

4.


P.12-19~12-20

1.

2.


1. 2.

P.12-20~12-21


3. 4.

P.12-21~12-22


5.6.

7.

P.12-22~12-23


P.12-23~12-24

1.

2.

4.

3.


P.12-25


P.12-26


P.12-27

  • (DBMS)

  • (file processing system)

  • (DBMS)


P.12-27

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

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


P.12-28

1.

A. B.

C. D.

3. DBMS

A. Excel B. Lotus

C. PageMaker D. Oracle

5.

A.

B.

C.

D.


P.12-28~29

7.

A. B. Web

C. D.

9.

A. B.

C. D.

11.

A. SQL B. OQL

C. RQL D. MQL


ad
  • Login