Computer Science Only!! Access Database

1.) I have created the relationship table, but I need help filling in the tables and coming up with a client. Also I will need a paragraph summarizing my client’s problem with the current system for capturing, storing processing and manipulating data generated from the business process under study. 

 

2.) write a paragraph describing usefulness of determining alternative solutions to the client’s problem with the current system for capturing, storing, processing and manipulating data generated from the business process under study.

    

ID

Address

1 Monterry Blvd

0

LA

06

USA

Country Dr

LA

USA

USA

5

TX

USA

6

USA

7

USA

8

USA

9

New Orleans LA

USA

10

USA

						Address	City	State	Zip	Country
				1	1			9			7	Baton Rouge				LA	70			8			6										USA
			2	1120 N Street	California	9			10
			3	988			5		New Orleans	70112
		4	16707 Great valley Rd	Houston		TX	77083
9874 Rock oak drive	San Antonio	78201
1345 River Jordan Blvd	Baltimore	MD	21201
4322 Pablo Honda Rd	Tulsa	OK	74101
6100 Richingberg Street	Newark	NJ	07101
3498 main Street Rd	70114
2299 Summerdale blvd	New York	NY	10003

1

1

2

2

3

4

4

8

5

10

6

9

7

3

8

6

9

5

10

7

	CustomerID	FirstName	LastName	AddressID	PhoneNumber
Jermain	Cole	225-764-5456
Christopher	Bridges	213-693-8874
Clifford	Harris	713-504-9978
Nasir	Jones	862-432-3312
Cosmas	William	832-812-4477
Emmanuel	Ugo	504-345-2107
Paul	Odom	212-767-0953
Emeka	Uzoma	443-451-6999
Arinze	Onuoha	210-567-9923
Aubrey	Drake	918-410-3120

	OrderID		UnitPrice	Quantity		ProductID

OrderID

CustomerID

1

OrderDate	Amount	ShipDate	Carrier	TrackingNumber

ProductID

UnitPrice

1

2

3

ProductName		SupplierID
Movie CDs	¤ 5.00
Clothing	¤ 7.00
Hats	¤ 4.00

SupplierID

SupplierName	SupplierPhone