5970_Midterm_Presentation

5970_Midterm_Presentation - Webster Industries, Inc. SQL...

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: Webster Industries, Inc. SQL Presented by: A Quick Review Other groups have already discussed: The ERD - Entity Relationship Diagram The RDBMS Relational Data Base Model System We will discuss SQL and its benefits Review: What is a Database? A DATABASE consists of some collection of persistent data that is used by the application systems of a given enterprise A collection of integrated records Review: The ERD Entity Relationship Diagram A tool to design a well structured database Components: Entities important stuff for storage Attributes characteristics of the Entities Relationships association between Entities Questions: What data is important? How will the data be represented? Where will the data be stored? ERD for Webster Industries, Inc. W e b ste r In du strie s , In c . En tity R e la tio ns h ip D ia gr am e stab lish es im a g e a ssig n me n t ex te n d s q u e ries ex ten d s B A TC H S H I P M E N T B A TC H _ U I D S H I P M E N T_ ID P A R T_ K E Y S H I PM EN T SH IP M EN T_I D PA R T_ KE Y STA TU S FOR M A T_ ID D OC _N ON D OC _ FLAG C U S T_ L OOKU P _ FLAG C OM P LE TION _ D ATE TIM E _S TAM P KE Y ER C K EA R A N C E_LOC _ C D C LE AR AN C E_ C OU N TR Y_C D TR A C KI N G_N B R FOR M _ I D OR I G_C D D E ST_ C D SH IP_ D ATE SE P _TR A C K_ ID SH IP M EN T_C U STOM S _V AU LE C U R R EN C Y_ C OD E BA TC H _ H E AD E R_ N B R BA TC H _ D A TE STA TION _I D SC AN N ER_ N BR BA TC H _ N B R C ON V E R TED _ C U S TOM S_ VA LU E I M A G E P A TH P A R T_ K E Y S H I P M E N T _ I D D O C _ TY P E _ C D I _ S E Q U E N C E I _ S T A TU S A D D R E SS S H IP M EN T_I D P AR T_ KE Y S H PR _ N AM E S H PR _ PH ON E _N BR S H PR _ C OMP AN Y S H PR _ AD D R _ D ES C S H PR _ AD D L _AD D R_ D E SC S H PR _ C ITY S H PR _ STATE _ C D S H PR _ C OU N TR Y_ C D S H PR _ POS TAL _ C D R C PT_ N AM E R C PT_ PH ON E_ N BR R C PT_ C OMP AN Y R C PT_ AD D R E SS_ D ES C R C PT_ AD L _AD D R ES S_ D E SC R C PT_ C ITY R C PT_ STATE _C D R C PT_ C OU N TR Y_C D R C PT_ POS TAL _ C D S TA T U S S T A T U S D E S C R IP T IO N L A S T_ U P D A TE D _ B Y T IM E S TA M P C ON TR A C T S H IP M E N T _ ID P A R T_ K E Y R OU TE R OU TE _ D A TE S H P R _ A C C OU N T_ N B R S H P R _ R E F E R E N C E _ N OT E R C P T_ C U S TO M S _ ID D E LI V E R Y _ C D S H IP M E N T _ P IE C E _ QT Y S H IP M E N T _ W E IG H T S H IP M E N T _ W E IG H T _ U OM S H IP M E N T _ C A R R I AG E _ V A L B R OK E R _ N A M E...
View Full Document

Page1 / 34

5970_Midterm_Presentation - Webster Industries, Inc. SQL...

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