Lecture Post: Databases

My entrepreneurial idea was to create an importing business of international products that create a relationship between the manufacturers of a country to a local non-profit organization unique to that country. That way the developed countries can help the developing countries build their business to benefit a larger whole, economically.

Databases will be of frequent use in order to successfully manage this business. All manufactured products, sales, locations, prices, clients will be recorded in databases. As the business grows, we will have a vast amount of information that needs to be accessible to employees with  one click, or to operations managers or to business analysts, so that the progression is easily observable. This will not only help us stay organized but it will make every process of our business run smoothly. A business which primarily run over the internet, or broad communication spheres, a place where all the business information is accessible is crucial.

Databases can help us answer questions and be valid in our case points since we will have written records of every transaction. Within a database there will be other folders which will help us separate information so that we can view what we need to view and not confuse every data piece altogether. After doing the Access lab, I realized that from the database we can create quick imagery of a report that we would like with specific constraints. Often times we want to see a certain kind of progression in only a certain sector of the business, such as only products that are made with fabric. Through the databases of our business we can quickly create a report for all products made of fabric and not go through every single product individually.

In matters of constant product manufacturing and sales, which happens with online stores rather than physical stores, we won't have a control of when the store is open, when consumers are active around the world or when a product goes out of stock. Therefore, a database will help us stay calm in the midst of this very active business. There might be errors but at least we will have an account for every action being taken in the business. There are also security measures that can taken with databases which can control user access and that is very important because then we can divide each sector of the business with access to only certain information; not to hide something, but to keep everything straight and give specific management roles to employee teams.