Mgs 351 project
This presentation is the property of its rightful owner.
Sponsored Links
1 / 12

MGS 351 Project PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

MGS 351 Project. Carlos Gamboa Jacob Pomilio Krystal Brown Leong Mei Si Nataliya Savka. Background. Company: Animal Humane Society Animal shelter designed to shelter stray animals until an owner is found. Due to the company being non-profit, almost nothing is computerized.

Download Presentation

MGS 351 Project

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Mgs 351 project

MGS 351 Project

Carlos Gamboa

Jacob Pomilio

Krystal Brown

Leong Mei Si

NataliyaSavka


Background

Background

  • Company: Animal Humane Society

  • Animal shelter designed to shelter stray animals until an owner is found.

  • Due to the company being non-profit, almost nothing is computerized.

  • Lead to tedious and inefficient business system.


Business problem

Business Problem

  • The former system was messy and unorganized.

  • Manual sign in sheets held all the important data.

  • No records of interaction with the dogs.


Business opportunity and value

Business Opportunity and Value

  • We identified an opportunity to improve the company’s former system by implementing a new and effective database.

  • This database organizes all the information necessary thus producing a faster, more efficient operation.

  • Can be easily displayed to national branches of the Humane Society or other interested outside parties.


Database design overview

Database Design Overview

3 main entities

1) People

  • Drop down list

  • Calculated control

    2) Dogs

  • Acquired date

  • Validation rule and text

  • <=Date()

    3) Attendance

  • AutoNumber

  • Notes


Database design overview1

Database Design Overview

Relationship Table

  • 3 main entities

  • 1 to many relationship between

  • People and attendance

  • Dogs and attendance

  • Attendance is the main entity


Database design overview2

Database Design Overview

Forms

  • 3 main forms

  • 1 sub form

    Reports

  • 5 reports

    Switchboard

  • Main menu

  • Links to forms and reports

    Macros

  • 7 macros

  • AutoExec


User interface design

User Interface Design

Main Menu

  • The switchboard has all the links to the forms and reports including a help and exit button

    Forms

  • 3 main forms

  • Customer, employee and dog records for easy accessibility

  • Attendance records shows the various statuses of each dog.


User interface design1

User Interface Design

Reports

  • 5 reports

  • Organize and classify information

  • Helps managers greatly

  • Creates business value


Project demonstration time

Project Demonstration Time 


Conclusion

Conclusion

  • Database will greatly improve efficiency of business.

  • Saves a lot of time

  • Easier follow up

  • Improve local management decisions

  • Garner more donations

  • Brings value to our cause


Mgs 351 project

Thank You!


  • Login