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

Added on - 18 Sep 2019

  • 9

    pages

  • 494

    words

  • 94

    views

  • 0

    downloads

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
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Unlock This Document