Sql Join Columns of Two Tables on Unique Key

Added on - 13 Sep 2019

  • 10

    Pages

  • 981

    Words

  • 341

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 10 pages
[Type the documenttitle]Student Name:Student ID:Course Name:Course ID:Faculty Name:University Name:
1ContentsTaskT1: EERD.................................................................................................................................2TaskT2: Rationale & Assumption...................................................................................................2TaskT3: Data Dictionary.................................................................................................................2TaskT4: SQL Tables........................................................................................................................2
2TaskT1: EERDTaskT2: Rationale & AssumptionTaskT3: Data DictionaryTable: EVENTColumn NameDataTypeConstraintseventIDINTPRIMARY KEYeventTypeENUM('RACE','WALK')NOT NULLstartDateTimeTIMESTAMPNOT NULLendDateTimeTIMESTAMPNOT NULLstartLocationVARCHAR(60)NOT NULLendLocationVARCHAR(60)NOT NULLrouteInformationVARCHAR(100)NOT NULLexpectedCostDOUBLENOT NULLactualCostDOUBLENOT NULL
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document