ch6 - 1 2 3 4 5 6 7 Bit 0 1 Byte Field Recod File J101 Y201...

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: 1 2 3 4 5 6 7 Bit 0 1 Byte Field Recod File J101 Y201 ... 10 12 6 160 184 96 W301 J101 0 J101 10 ( ) 160 10101010 ( J ASCII ) 6-1 1 2 3 4 5 6-2 DBMS DBMS Data Definition Language DDL Data Manipulation language DML Data Dictionary DBMS 1 2 3 6-3 DBMS SQL Structured Query Language SQL Select SELECT [ALL | DISTINCT] [TOP nExpr [PERCENT]] [Alias.] Select_Item [AS Column_Name] [, [Alias.] Select_Item [AS Column_Name] ...] FROM [FORCE] [DatabaseName!]Table [[AS] Local_Alias] [[INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER] JOIN DatabaseName!]Table [[AS] Local_Alias] [ON JoinCondition ...] [[INTO Destination] | [TO FILE FileName [ADDITIVE] | TO PRINTER [PROMPT] | TO SCREEN]] [PREFERENCE PreferenceName] [NOCONSOLE][PLAIN][NOWAIT] [WHERE JoinCondition [AND JoinCondition ...] [AND | OR FilterCondition [AND | OR FilterCondition ...]]] [GROUP BY GroupColumn [, GroupColumn ...]] [HAVING FilterCondition] [UNION [ALL] SELECTCommand] [ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]] : : : : 1 2 3 4 - 5 6 7 DBMS - 6-4 "" 1 2 3 1 2 3 4 5 6-5 ( ) 1634 1635 1636 02/02/93 02/12/93 02/13/93 02/22/93 02/29/93 02/01/93 26.25 22.50 70.00 44 32 51 152 137 145 2 3 1 4058 2038 1125 116044 114321 112324 144.50 79.70 24.30 ( ) 137 145 152 1125 2038 4058 6-6 1. E-R * * * * 6-7 " " - 2. E-R "" " " # # A20-01 A40-31 R4-801 PY-090 A20-01 WH-5W TH-Y3 R-T-W 40W/S SWH-5 1990.12.23 54.30 1989.02.13 34.40 1995.02.23 153.00 1998.10.13 78.20 1993.11.06 234.20 RABCDE "" RABCDE """" R A B B A A B " """"" R B A B A B A B A # # R A B C AB BC C A # R R R1NF R1NF R2NF R2NF R3NF 1FN 2FN 3FN R 1. R # # # 2. # # # # # # # 1 Partitioned database CPU CPU (a) 6-10 2 Duplicate database CPU CPU CPU (a) 6-10 3 Central index distributed database CPU CPU CPU CPU CPU (c) 6-10 4 "" " Ask-the-network"distributed database CPU CPU CPU (d)" " 6-10 DBMS 6-11 ...
View Full Document

Ask a homework question - tutors are online