logo

Sql Join Columns of Two Tables on Unique Key

10 Pages981 Words431 Views
   

Added on  2019-09-13

Sql Join Columns of Two Tables on Unique Key

   Added on 2019-09-13

ShareRelated Documents
[Type the documenttitle]Student Name: Student ID: Course Name: Course ID:Faculty Name: University Name:
Sql Join Columns of Two Tables on Unique Key_1
1ContentsTaskT1: EERD.................................................................................................................................2TaskT2: Rationale & Assumption...................................................................................................2TaskT3: Data Dictionary.................................................................................................................2TaskT4: SQL Tables........................................................................................................................2
Sql Join Columns of Two Tables on Unique Key_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
Sql Join Columns of Two Tables on Unique Key_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Event Management System SQL Tables and Commands
|7
|553
|254

Rationale & Assumption
|11
|1212
|460