Limited-time discount for students! | Solutions starting at $6 each

STUDENT NAME:. 12 November, 2016. DATABASE ASSIGNMENT.

Added on - 18 Sep 2019

  • 9

    Pages

  • 494

    Words

  • 202

    Views

  • 0

    Downloads

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 9 pages
STUDENT NAME:12 November, 2016DATABASE ASSIGNMENT
ContentsDATA DICTIONARY.................................................................................................................................2DATABASE DIAGRAM.............................................................................................................................4DATABASE TEST.....................................................................................................................................4
DATA DICTIONARYTABLECOLUMNDATATYPESBUILDINGBUILDING_KEYINTBUILDING_NAMENvarchar(50)BUILDING_ADDRESSNvarchar(50)BUILDING_CITYNvarchar(50)BUILDING_STATENvarchar(50)BUILDING_ZIPNvarchar(10)BUILDINGMANAGERPHONENvarchar(10)APARTMENTAPARTMENTKEYVARCHAR(10)APARTMENTROOMINTBUILDINGKEYINTTENANTTENANTKEYVARCHAR(10)TENANTFIRSTNAMEVARCHAR(30)TENANTLASTNAMEVARCHAR(30)TENANTPHONEVARCHAR(10)LEASELEASEKEYVARCHAR(10)LEASEMONTHLYRENTNUMERIC(10,2)LEASEDEPOSITNUMERIC(10,2)LEASESTARTDATEDATELEASEENDDATEDATEAPARTMENTKEYVARCHAR(10)
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