Friday, March 16, 2012

Database Proccessing

Database / key / Relations
  • Credit Cards(Account Number)
  • Reward Zone Program(Member #)
  • Sales (Order Number)
  • Payroll (employee ID)
  • etc.
Primary Key
Digit member id

Forms
  • Credit Card Application
  • Rewards enrollment form

Queries
  • Check all order of a customer
  • Show job positions available in state of New Jersey
Reports

Thursday, March 15, 2012

Enterprise Systems

Customer Relationship Management (CRM)




  • CCM - Each customers information will be stored here when they sign up to be a Rewards Zone Member, sign up for a branded payment, or use and type of Geek Squad Services. 
    • ties together 3 different systems: Customer Service, Marketing, and Sales.
    • with CCM, you are able to access anything dealing with our customers such as:
      •  member ID number
      • personal information
      • purchases from and Best Buy in store or online
      • returns / exchanges made
  • RSS - Tracks all product inventory.  Let's us know the availability, how many, and current price. 
    • constantly being updated
    • allows you to see what any other stores have available



  • OMS - Allows are customer to still get their product even if the current store that they are in does not have it available. 
    • Fulfills the customers needs
    • Put product(s) on reserve at other store - allows for easy and quick pick-up
    • Track orders to see when it will be in
  • Software
    • Niku 6
      • Niku Corporation is the leading provider of Services Relationship Management (SRM) software.
      • Best Buy has chosen Niku 6’s features and functionality to upgrade its information systems (IS) infrastructure. 
      • Niku 6’s ability to integrate to Oracle Financials, better project forecasting capabilities, increased finance tracking capability, and ability to manage external staffing.
To learn more about Best Buy's decision with NIKU... 


by Kurt Peters

 
  • Hardware
    • IBM   Provides Best Buy with its registers and scanners