Sql Join Columns of Two Tables on Unique Key

Added on - 13 Sep 2019

10
pages
981
words
109
views
0
downloads

Share
Share on Facebook Share on Twitter Share on LinkedIn Share on Whatsapp Share on Mail Copy Link
Report
Report
Issue
Duplicate Content
Copyright Issue
Irrelevant Content
Misinformation
Incomplete
Illicit Content
Personal Information
Others
Comment (Optional)
Thank you for your feedback.

Showing pages 3 of 10

[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