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

数据库原理与实践 ( ACCESS 版) PowerPoint PPT Presentation


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

数据库原理与实践 ( ACCESS 版). 数据库基础及应用. 李锐 [email protected] About………. 教材 《 数据库基础与应用( Access 版) 》 清华大学出版社 作者:董卫军、邢为民、索琦 成绩 30% 70% 期末大作业. 数据库基础理论篇. 第 1 章 数据库基础. 1.1 数据库基本概念. 1.1.1 数据与数据处理. 数据 : 事物特性的反映和描述,是符号的集合。 信息是和数据 : 数据是信息的符号表示(或称为载体),信息则是数据的内涵,是对数据语义的解释。.

Download Presentation

数据库原理与实践 ( ACCESS 版)

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


Access

ACCESS


Access

[email protected]


About

About.

    • Access

    • 30%70%


Access


Access

1


Access

1.1

1.1.1

:

:

:


Access

1.1.2

:

  • 1

  • 2

  • 3

  • 4


Access


Access

1.1.3

OS

  • 1

  • 2

  • 3

  • 4


Access

DBA

DBMS

OS

1.1.4

4


Access

1.2

1.2.1

2050


Access

1.2.2

205060


Access

1.2.3

  • DBMS


Access

1.2.4


Access

1.2.5

2090OO


Access

MDBS


Access

ADBMS

ADBS = DBS + EB + EM

  • DBS

  • EBECAECA

  • EMEB


Access

OLAPDM


Access

1.4

1.4.1


Access

1.4.2


Access

3


Access


Access

DBMS E-R


Access

1.4.3


Access

1.5

DBMS

DBMS

1.5.1


Access

1.5.2


Access

1.5.3


Access


Access

1.6

/

/


Access

1.7


Access


Access

1.8

1.8.1


Access

1.8.2

SSNOSNAMESGESEXSDEPT

CCNOCNANECDEPTTNAME

SCSNOCNOSCORE


Access


Access

100


Access

1.8.3


Access

1.8.4

RSRSRSRS

tRS

RSRSRSR-S

tRS


Access

RSRSRSRS

tRS

RSrsRSRS(rs)rRsSRS


Access

( )

()

1

2

4

4

3d

a 1 c

1

b 2 a

3

d 4f

3

4 f

:

:

:


Access

RABC

a 1 c

b 2 f

S (A BB)

aa 11

bb 22

a 1 c aa 11

a 1 c bb 22

b 2 f aa 11

b 2 f bb 22

R.A, B C S.A BB

RS:


Access

RSrsr>s>0RSr-sRSRStSu<tu>R


Access

  • SSNO SNAME STATUS CITY

  • S1 Smith 20 London

  • S2 Jones 10 Paris

  • S3 Blake 30 Paris

  • S4 Clark 20 London

  • S5 Adams 30 Athens

  • SNO SNAME STATUS CITY

    • S3 Blake 30 Paris

    • S5 Adams 30 Athens

RFF(R)

status 20S=


Access

  • SNO SNAME

  • S1 Smith

  • S2 Jones

  • S3 Blake

  • S4 Clark

  • S5 Adams

SNOSNAME(S)=

status > 10)SNO < S6S

CITY

)

CITY

=

London

Paris

Athens

R()A,AR


Access

-R S

  • R1A1A2

  • a1 1

  • a2 2

  • a3 1

  • a4 2

  • R2B1A2

  • b1 1

  • b2 1

  • b3 2

  • b4 3

A1R1.A2B1R2.A2

=

R1 R2

R1.A2 R2.A2

  • a2 2 b1 1

  • a2 2 b2 1

  • a4 2 b1 1

  • a4 2 b2 1


Access

  • SB C

    • 1 b1

    • 1 b2

    • 2 b2

  • RA B

    • a1 1

    • a2 1

    • a2 2

    • a3 1

AB C

=

  • a1 1 b1

  • a1 1 b2

  • a2 1 b1

  • a2 1 b2

  • a2 2 b2

  • a3 1 b1

  • a3 1 b2

R S


Access

-

  • SSNO SNAME STATUS CITY

  • S1 Smith 20 London

  • S2 Jones 10 Paris

  • S3 Blake 30 Paris

  • S4 Clark 20 London

  • S5 Adams 30 Athens

  • SPSNO PNO QTY

  • S1 P1 300

  • S1 P4 200

  • S1 P5 100

  • S2 P1 300

  • S2 P2 400

  • S3 P2 200


  • Access

    SNO =S1S SP

    SNOSNAME STATUS CITY PNOQTY

    =

    S1 Smith 20 London P1 300

    S1 Smith 20 London P4 200

    S1 Smith 20 London P5 100


    Access

    2


    Access


    Access

    2.1


    Access


    Access


    Access

    2. 2

    DBMS


    Access

    2. 3

    7


    Access

    2.3.1


    Access

    2.3.2


    Access


    Access

    2.3.3

    DBMS


    Access

    E-R

    DBMSE-R


    Access

    2.3.4


    Access

    E-R


    Access

    11

    1NN1

    MN


    Access


    Access

    2.3.5


    Access


    Access

    2.3.6


    Access

    DDL


    Access

    2.3.7


    Access

    2. 4


    Access

    2.4.1

    R(U)XYUXYrRrtst[X]=s[X]t[Y]=s[Y]XYXYYXXYX


    Access

    R(S#SNAMEC#GRADECNAMETNAMETAGE)

    S#SNAMEC#CNAME

    (S#C#)GRADE

    C#(CNAMETNAMETAGE)

    TNAMETAGE


    Access

    URXUXURXRXURXX1X1UXR

    RSRXXRSXXSXR


    Access

    Rr

    1NF

    WAXWXAWAAWWA

    2NF

    R1NF

    2.4.2


    Access

    1NF2NF

    RUWRXZZX WWZR

    R1XZX

    R2YY = U - ZWX

    R1R2R

    R1R22NF2NF


    Access

    XYYZYXZYXZZX

    3NF

    R2NFRR3NF


    Access

    2NF3NF

    RU2NFWRXZZZXXWZ

    R

    R1XZX

    R2YY=U-ZWX

    R1R2R

    R1R23NF3NF


    Access

    2.4.3

    RFRFDR={R1R2Rk},RFrr = R1(r) R2(r) Rk(r)F

    R(U)UR1R2RkUR1R2Rk = UR1R2Rk= {R1R2Rk}RR


    Access


    Access

    3


    Access

    3. 1

    3.1.1


    Access

    3.1.2


    Access

    3. 2


    Access


    Access

    3. 3

    3.3.1

    • OS

    • DBMS

    • DBMS


    Access

    3.3.2


    Access

    3.3.3


    Access


    Access


    Access


    Access


    Access

    3.3.4


    Access


  • Login