ch03 - 3. 3. & ¡ l ”“* àae ë ¢¢ ¢ ¢ à ´Ö...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 3. 3. & ¡ l ”“* àae ë ¢¢ ¢ ¢ à ´Ö & ¡ .¢ 2 3 & º E¡ àae È ö @ ìE @ À – • ¢ » ª xY ´ “ 3 & À (DB) X “* (Data Language) 3 (User) ƒ (DBMS) & F (DBA) & F (Database Computer) 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) 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 … ‡# 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)...
View Full Document

This note was uploaded on 11/03/2009 for the course CS db taught by Professor Prof.kim during the Fall '09 term at 홍익대학교.

Page1 / 22

ch03 - 3. 3. & ¡ l ”“* àae ë ¢¢ ¢ ¢ à ´Ö...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online