AFAS_Built

AFAS_Built - me CustomerPho ne AnnualInco me CreditRati ng...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ISYS201 DB Build Assignment Duc Ho Sect.5 CreditRating CreditID CreditDescript ion MinFICO MaxFICO Comments 1 Extremely Poor 300.00 499.00Cannot extend credit 2 Very Poor 500.00 580.00Owner approval required to extend credit 3 Poor 580.00 619.00Credit extended at very high interest rates 4 Fair 620.00 679.00Credit extended at high interest rates 5 Good 680.00 699.00Credit extended at normal interest rates 6 Very Good 700.00 850.00Credit extended at low interest rates 7 Unknown Did not look into financing options SalesPerson SalesID SalesFirstNam e SalesLastNam e SalesHireDay Sales Salary 1 Lewis Peoples 2/13/1989 $140,000.00 2 Richard Martin 5/2/1989 $82,000.00 3 Juan Rodriguez 5/2/1989 $93,000.00 4 Rachel Scholes 4/27/1996 $56,000.00 5 Jesse Lukes 5/15/1996 $67,000.00 6 Maggy Adelman 6/1/2001 $75,000.00 7 Dale Jones 11/9/2004 $71,000.00 8 Jungpil Lee 4/26/2006 $62,000.00 Encouter EncID SalesPersonID CustomerID EncDate Purchase 1 2 2 7/1/2007 Yes 2 2 3 7/1/2007 No 3 5 1 7/1/2007 No 4 2 3 7/1/2007 Yes Customer CustomerID CustomerFirstNa me CustomerLastNa
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: me CustomerPho ne AnnualInco me CreditRati ng 1 Clark Adams (801) 768-6043 $64,250.003 2 Jessica Johnson (801) 763-$35,599.002 CreditRating CreditID CreditDescript ion MinFICO MaxFICO Comments 1 Extremely Poor 300.00 499.00Cannot extend credit 2 Very Poor 500.00 580.00Owner approval required to extend credit 3 Poor 580.00 619.00Credit extended at very high interest rates 4 Fair 620.00 679.00Credit extended at high interest rates 5 Good 680.00 699.00Credit extended at normal interest rates 6 Very Good 700.00 850.00Credit extended at low interest rates 9955 3 Kristi Fisher (801) 356-5919 $103,250.006 4 George Campbell (801) 768-3830 $80,250.005 5 Stephen Brett (801) 763-9137 $56,875.006 7 Dmitri Chekov (801) 374-1703 $67,500.005 8 Mitchell Hunt (801) 766-8236 $21,625.001 9 Trevor Neilson (801) 785-4829 7...
View Full Document

This document was uploaded on 11/01/2011 for the course I SYS 201 at BYU.

Page1 / 2

AFAS_Built - me CustomerPho ne AnnualInco me CreditRati ng...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online