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

Added on - Sep 2019

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 are reading a preview
Upload your documents to download or

Become a Desklib member to get access