Question

For this discussion, give examples of database applications.

The example in our textbook is FedEx. When a package is sent, FedEx must store the sender’s first and last name, sender’s street address, sender’s city, sender’s state, sender’s zip code, recipient’s first and last name, recipient’s street address, recipient’s city, recipient’s state, recipient’s zip code, date sent, package weight, and type of service. Using a database management system, individuals, small groups, and organizations can build various applications to allow organizations to do things like track orders and deliveries, manage retail sales and inventory, maintain employee payroll records, update patient data, and track student progress.

For this discussion, give examples of database applications either you know of or that you've researched, I look forward to reading your posts. Please don't forget to reply to at least two of your peers' entries in order to get full credit.

Answer 1

Here are some examples.

1.) consider a case of Amazon e-commerce website. When a customer orders something which needs to be fulfilled by one of the vendors (eg Fedex), the vendor need's some basic customer details like name, address, zip, city etc. where the shipment needs to happen.
When a customer buys something from Amazon, the order details are stored in one of the tables with the tracking number generated by the vendor.

First NAme

LastName

Address

City

State

Country

Zip

Date

Weight

Status

Tracking number

Recipient NAme

Recipient Address

Recipient City

John

Marshal

#123 , brooklyn Street

LA

USA

02/28/2019

10kg

Ordered

463843VDYE

Andrew

#773 Downtown

LA

Now this information is shared with the vendor, and when there are any updates, the status is changed and the customer can actually see the changed in status through the tracking number

2. ) the second example is very good. Consider a managed Print business of a company called Canon. Consider a case when an enterprise customer orders for 100s of toners for his fleet of printers. That order is stored in the application database. Now, an automatic job will be running in the backend which will pick up that order and sends to one of the vendors for fulfillment, based on various factors like location etc.  
Now that vendor will send a tracking number which will be stored in the database and shared with the customer. When the order is fulfilled, the tracking number will be marked as closed .