Lester's Fine jewelry

1
Lester's Fine jewelry

• Database Presentation
• Group 11

2
Background Information

• Lester's Fine Jewelry and Company
• Internally Managed by Lester Thompson (Company
  Owner)?
• Andrew Thompson (Accounting and Sales)?

3
Background Information

• Buy and sell
• Jewelry (new and used)?
• Watches
• Gold scraps
• Other fine gifts
• Repair
• Jewelry
• Watches
• Polish other metals and gifts

4
Information Systems

• File based system
• Not up to date
• Incomplete
• Risky for insurance purposes
• Inconvenient for customers
• Payroll
• Kept on Quick books
• Accounting
• Done through Excel Spreadsheets

5
Information SystemsProposition

• Database approach
• Unifies previous information systems
• Expansion

6
Expansion

• Audits
• Insurance
• Training and employee transitions
• Centrally Managed
• Low relative Cost

7
Project Scope

• Revolves around Product
• Customers
• Jewelry
• Repairs
• Cash Flow

8
System Design
9
Forms and Reports
10
Forms and Reports
11
Forms and Reports
12
Forms and Reports
13
Forms and Reports
14
Forms and Reports
15
Forms and Reports
16
Forms and Reports
17
Forms and Reports
18
Forms and Reports
19
Forms and Reports
20
Forms and Reports
21
Forms and Reports
22
Forms and Reports
23
Problems Solved

• Increase in efficiency
• Unification of Information Systems
• Easier data backup for speedy recovery
• Centrally Managed Company

24
Now is the time!

• Why will the database save money?
• Speedier Employee Transition
• Speedier Recovery from the unexpected
• Cheaper data backup
• Speedier data backup
• Less paper piles and associated costs

25
Questions ?
26
Thank you!