Intertribal Friendship House Presented by Group 1 Patrick Briaud Milad Odabaei Fernando Siu Jennifer Wu Yang Liu Maria Rodriguez David Uniman John Guo
Background of Intertribal Friendship House Non-profit organization n Founded in 1955 n Located in Oakland n Center for Bay Area’s Native Americans n Conducts various classes open to the public for free n Hosts various community events n
Current Situation of IFH n n Inefficient data management No electronic database Consequences = problems in: 1. 2. 3. n Human resources Cash flow Activity planning Expansion plan
Issues with Human Resources n Failure to database members n Difficulty communicating with members n Lack of formal scheduling system
Issues with Cash Flow n No formal accounting system n Highly variable cash inflows n Organization near bankruptcy
Issues with Activity Planning n Lack of official scheduling systems n Difficulty coordinating among facilities
Project Objectives Provide a useful organization of IFH’s data n Improve the ability to coordinate activities n Improve the ability to manage resources n Increase efficiency in order to allow sustainability and growth n
Database requirements Person Entity: n For every person, we store PID, name, phone numbers, email addresses n Each person can be either an employee, volunteer, customer, participant, donor, or any combination of the above Product entity: n For each product, we keep track of Pr. ID, name, selling price Inventory item entity: n For each inventory item, we keep track of IID, name, expiration date, acquisition price
Activity Entity: n For each activity, we keep track of the AID, name, type, organizer Facility Entity: n For each facility, we keep track of the FID, name, dimension, floor, room number Time Slot Entity: n For each time slot, we keep track of the date, hour blocks
Transaction Entity: n For each transaction, we keep track of date, amount n Each transaction is either a payment or an income n Each payment is either a utility cost, product cost, maintenance cost, employee cost n Incomes from either a rental, donation or sale.
Relationships: n Employees and volunteers can work in zero or multiple time slots. Multiple people can work in a time slot. n Volunteer can be available for zero or multiple time slots, and a time slot can have multiple volunteers available. n A customer can be included in at least one sale. A sale is made by one customer only.
Relationships: n A donor must make more than one donation. A donation is made by a single donor. n A participant must participate in at least one activity. An activity can have multiple participants. n An activity must take place in at least one time slot. A time slot can have up to many activities. n An activity must take place in at least one facility. A facility can hold multiple activities.
Relationships n An employee must be associated with at least one cost. An employee cost is only associated with one employee. n An activity can generate one rental income. A rental must be associated with one activity. n A product can be a component of multiple products. A product can have multiple components. n An inventory item must be one type of product. There can be many inventory items of a product.
Relationships: n A sale must include at least one inventory item. An inventory item can be included in one sale. n An inventory item must cost one product cost. A product cost must have one inventory item.
Project Schedule n n 10/24: Begin revising the EER diagram and Relational Design 10/28: Revisit the center to collect additional data l l n Verify the usefulness and accuracy of proposed database design with board members Ask for query requests from the board members 11/5: Finalize EER diagram and improve on the Relational Design l Develop multiple queries to address the center’s needs
Скачать презентацию Intertribal Friendship House Presented by Group 1 Patrick
4fa9b643d58386a35b2880fdea9d3e03.ppt