Webster Industries

Webster Industries - Webster Industries Inc Structured...

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

View Full Document Right Arrow Icon
Webster Industries, Inc. Structured Query Language Database – a collection of integrated data, consisting of some persistent data that is used by the application systems of a given
Background image of page 1

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

View Full DocumentRight Arrow Icon
enterprise Entity Relationship Diagram (ERD) – a tool to design a well structured database Components: Entities – important ‘stuff’ for storage Attributes – characteristics of the Entities Relationships – association between Entities ERD Example Relational Data Base Management System (RDBMS) – the repository for a collection of computerized data files containing the pertinent information about the Entities and their Attributes; minimizes data duplication Structured Query Language – SQL Webster Industries, Inc. Entity Relationship Diagram e s t a b l i s h e s i m a g e a s s i g n m e n t e x t e n d s q u e r i e s e x t e n d s BATC HSHIPMEN T BATCH_ UID SHIPMENT_ID PART_KEY SHIPMEN T SHIPMENT_ID PART_KEY STATUS FORMAT_ID DOC _NONDOC_FLAG CUST_LOOKU P_FLAG COMPLETION _DATE TIME_STAMP KEYER CKEARANCE_LOC _CD CLEARAN CE_COUNTR Y_CD TRACKING_NBR FORM_ID ORIG_C D DEST_CD SHIP_DATE SEP_TRACK_ID SHIPMENT_CU STOMS_VAU LE CURREN CY_CODE BATCH_HEADER_NBR BATCH_DATE STATION _ID SCAN NER_N BR BATCH_NBR CONVERTED_CUSTOMS_VALUE IMAGE PATH PART_KEY SHIPMENT_ID DOC_TYPE_CD I_SEQUENCE I_STATUS ADDRESS SHIPMENT_ID PART_KEY SHPR_NAME SHPR_PHONE_NBR SHPR_COMPAN Y SHPR_ADDR_DESC SHPR_ADDL_ADDR_DESC SHPR_CITY SHPR_STATE_CD SHPR_COUNTRY_CD SHPR_POSTAL_CD RCPT_NAME RCPT_PHONE_NBR RCPT_COMPAN Y RCPT_ADDRESS_DESC RCPT_ADL_ADDRESS_DESC RCPT_CITY RCPT_STATE_CD RCPT_COUNTRY_CD RCPT_POSTAL_CD S TATUS STATUS DESCRIPTION LAS T_ UPDATE D_BY TIMESTA MP CONTRACT SHIPMENT_ID PART_KEY ROUTE ROUTE_DATE SHPR_ACCOUNT_NBR SHPR_REFERENCE_NOTE RCPT_ CUSTOMS_ID DELI VERY_CD SHIPMENT_PIECE_ QTY SHIPMENT_WEIGHT SHIPMENT_WEIGHT_UOM SHIPMENT_CARRI AGE_VAL BROKER_NAME BROKER_CITY BROKER_COUNTRY_CD BROKER_POSTAL_ CD BROKER_PHONE CARGO_AIRCRAFT_FLAG DRY_ICE_FLAG BILL_ TO_CD BILL_ TO_ACCT_NBR CREDIT_CARD_NBR CREDIT_CARD_EXPCREDIT_CARD_AUTH FRT_CHARGE_AMT RCPT_ ACCOUNT_NBR CUSTOMS _AUTH_XTN_CONF_CD CREDIT_CARD_EXP Key Entity w/items Action Relationships One Many E n t i t y I t e m 1 I t e m 2 A c t i o n
Background image of page 2
What is Structured Query Language? Structured Query Language is a database programming language that defines the structure and processing of a relational database. SQL is the data access language used by many commercial Relational Database Management Systems, such as Oracle, Microsoft SQL Server, dBase, Sybase and Microsoft Access. History of SQL
Background image of page 3

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

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

Page1 / 10

Webster Industries - Webster Industries Inc Structured...

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

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