Ask a question to Desklib · AI bot

Ask NowBETA

Sql Join Columns of Two Tables on Unique Key

Added on -2019-09-13

| 10 pages
| 981 words
| 431 views

Trusted by 2+ million users,
1000+ happy students everyday

[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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Students who viewed this