SmartFurniture Access 2000 Database

1
SmartFurniture Access 2000 Database

• IS 257 Professor Larson
• Kirsten Swearingen
• November 30, 2000

2
What is SmartFurniture?

• A one-person company and e-commerce website that
  sells modular furniture.

3
Current System
Problems of scalability, accuracy, integrity
4
Database Priorities

• Keep things simple
• Enable SmartFurniture to expand
• Volume of sales
• Number of employees
• Variety of products

5
System Overview

• Activities
• Processing orders
• Communicating with customers/ prospects
• Tracking inventory

• Main Entities
• Customers
• Orders
• Inventory of Components
• Suppliers

6
Features

• Simplifies and improves data entry
• Offers flexible views of contact and order
  information
  
• Switchboards
• Searching
• Forms (at-a-glance contact, order, payment, and
  shipping info.)
  
• Reports
• Facilitates and helps track communication

7
Demonstration
8
Future challenges

• Customers order combinations of components, not
  Products
  
• Components not intuitively named
• Database could do more to assist