{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

ch03 - 3 l 3 E E x Y XY x 3 3 0(DB(Data Language(User(DBMS...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
3. 3. ° ± l * àæ ë ²²² ² à ´Ö ° ±
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
2 3 ³ º E² àæ È ö @ ìE @ À ´ » ª xY ´ 3 ° À (DB) X * (Data Language) 3 (User) ƒ 0 (DBMS) ° F (DBA) ° F (Database Computer)
Background image of page 2
3 3 3 ± ºª*à ` ² ·º 3 3 ± ºª º [† ƒ (View) : 3 , , 3 H H ² 3 ° ( H · 1 , 3 ) ° 3 ° F » ¡ º 1 (external schema) H 1 (conceptual schema) 1 (internal schema)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4 ° ± l ± ± ² ( ¹ * (external schema) (external schema) t ƒ + ƒ C 3 subschema C (conceptual schema) (conceptual schema) - t ƒ + Ç ƒ ² @ schema HN 1 (internal schema) (internal schema) B . ƒ C ‡#
Background image of page 4
5 3 3 ¦ ST Sn INT Name CHAR(10) Grade INT Dept CHAR(5) STUDENT Snumber INTEGER Name CAHR(10) Year SMALLINT Grade SMALLINT Dept CHAR(5) Address CHAR(44 ) STUDENT Sno PIC 9(4) Sname PIC X(10) Year PIC 9(2) Addr PIC X(44) E 1 2 ( ) STORED-STUDENT LENGTH = 71 prefix BYTE(4) OFFSET = 0 Sno BYTE(4) OFFSET = 4 INDEX = STINDX Sname BYTE(4) OFFSET = 8 Syear BYTE(4) OFFSET = 18 Sgrade BYTE(4)
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}