The picture shown above is the database of the most and least sold breads in the Bakery.

Sort

1. Most/Least sold bread

 

Here, it shows the type of bread to be sold the most among the customers and the least sold bread as well.

The most bread is the choco lanay, while the most least is the pandesal.

2. Customer who bought….

 

Here, it shows the customers who purchased the most and least purchased breads in the bakery.

The customer who bought the most is Kyla, while the customer who bought the least is John.

Filter

3. Most frequently bought

Now, the most frequently bought bread is still the choco lanay.

4. Least frequently bought

 

And the least frequently bought bread is still the pandesal.

5. Searching kind of bread.

 Full list of breads being sold in the bakery.

Reflection

Filtering and sorting is one of the most important factor when you are making a database. It is very useful for the user to sort and filter so the user would easily find out which is the most and least among the list on a certain created database. When talking about Filtering, it means to censor or restrict something to a computer according to the dictionary. While with sorting, you can list down the most to least or the least to most in a certain classification. Just the same as what we did for the database of the bakery. In relating to the sales of the different kinds of breads. But not only this is useful in creating a database, but it can also be applied in many different types of activities. Even those activities that doesn’t provide the use of technology but also in making outputs manually. It doesn’t only make it easier for the user, but it also makes it organize the order and making it easier to read and see for for anyone who would want to view it. With filtering, it can search certain records and datas faster without consuming a lot of time. It is convenient and at the same time, it is not difficult to do.