1 / 14

Tri-Main Center Proposal

The Tri-Main Center project, spearheaded by Jason Hamel, Kevin Kim, Demetri Land, Matthew Szczerbiak, and Juliana Turner, aims to transform the operations of a dynamic business community in Buffalo, NY. Spanning 650,000 square feet across six floors, the center currently relies on outdated paper and Excel systems. To enhance organization and accessibility, we propose a comprehensive database that will allow tenants to easily access payment histories, utility invoices, and other essential information. This modernization will facilitate quick, efficient operations and foster collaborative communication among 85 businesses.

desma
Télécharger la présentation

Tri-Main Center Proposal

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tri-Main CenterProposal Project By: Jason Hamel Kevin Kim Demetri LandMatthew Szczerbiak Juliana Turner

  2. Information • Dynamic Business Community • 2495 Main Street Buffalo, NY • 650,000 square feet • 6 floors tall • 85 businesses

  3. Old System • Paper/Pencil filing • Excel based operations • Poorly organized • Accessibility

  4. Proposed System • Database • Organized • Shared information • Quick • Efficient

  5. Database Content • Tenants • Statements • Suites • Payment history • Utility Invoices

  6. ERD Stores the data in the database and are analogous to the foundation of the database.

  7. 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

  8. Queries Enable the user to extract data from the database tables and allow us to answer questions about the data. Unpaid • Paid

  9. 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

  10. ReportsMailing Lists

  11. ReportsPayment Information

  12. ReportsSuite Information

  13. ReportsTenant Information

  14. ReportsUtility Information

More Related