Database Management Systems The organization of fields and records enable a data

Question

Database Management Systems
The organization of fields and records enable a database management system (DBMS) to organize and transform pieces of data into usable information. Describe how a database application is used at your place of work, somewhere you have worked, or an organization with which you are familiar. Database Management Systems
The organization of fields and records enable a database management system (DBMS) to organize and transform pieces of data into usable information. Describe how a database application is used at your place of work, somewhere you have worked, or an organization with which you are familiar. Database Management Systems
The organization of fields and records enable a database management system (DBMS) to organize and transform pieces of data into usable information. Describe how a database application is used at your place of work, somewhere you have worked, or an organization with which you are familiar.

Explanation / Answer

Let us discuss how a database application can be used in context of an e-commerce company selling products online, like Amazon, Ebay, or Flipkart:

The database will consist of the following tables -

1) Product (Product ID, Type, Cost, Quantity available, Description, Manufacturer, Vendors etc.)

2) Customer (Customer ID, Address, Phone number, Nationality, E-mail ID, Age, Gender etc.)

3) Purchases (Product ID, Customer ID, Quantity brought, Date of purchase, Time of purchase, Vendor, Total cost etc.)

4) Reviews (Product ID, Customer ID, Date, Time, Review, Upvotes, Downvotes etc.)

We can use a relational database schema to represent the above entities. The database management system allows us to retrieve results for a number of different types of queries like-

1) Query for all products sold on a given day

2) Query for all products listed by a particular vendor

3) Query for all products brought by a certain customer

4) Query for total amount spent by a certain customer

This database can also be used to enforce conditions like restricting the sale of a product to customers of a certain country or stop showing the product on the website if the vendor is out of stock.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.