140 likes | 262 Views
Tri-Main Center Proposal. Project By: Jason Hamel Kevin Kim Demetri Land Matthew Szczerbiak Juliana Turner. Information. Dynamic Business Community 2495 Main Street Buffalo, NY 650,000 square feet 6 floors tall 85 businesses. Old System. Paper/Pencil filing
E N D
Tri-Main CenterProposal Project By: Jason Hamel Kevin Kim Demetri LandMatthew Szczerbiak Juliana Turner
Information • Dynamic Business Community • 2495 Main Street Buffalo, NY • 650,000 square feet • 6 floors tall • 85 businesses
Old System • Paper/Pencil filing • Excel based operations • Poorly organized • Accessibility
Proposed System • Database • Organized • Shared information • Quick • Efficient
Database Content • Tenants • Statements • Suites • Payment history • Utility Invoices
ERD Stores the data in the database and are analogous to the foundation of the database.
Tables Store the data in the database and are analogous to the foundation of the database. • Payments history • Statement • Suite • Tenants • Utility Invoice *Forms are directly made from these tables
Queries Enable the user to extract data from the database tables and allow us to answer questions about the data. Unpaid • Paid
Reports Use data from a table or query and format the output in a professional-looking manner. • Mailing Labels • Payment Information • Suite Information • Tenant Information • Utility Information