Database use : an idea

First : what is a database ?

According to Wikipedia : "A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.
The database management system (DBMS) is the software that interacts with end users, applications, and the database itself to capture and analyze the data. The DBMS software additionally encompasses the core facilities provided to administer the database. The sum total of the database, the DBMS and the associated applications can be referred to as a "database system". Often the term "database" is also used to loosely refer to any of the DBMS, the database system or an application associated with the database.
Computer scientists may classify database-management systems according to the database models that they support. Relational databases became dominant in the 1980s. These model data as rows and columns in a series of tables, and the vast majority use SQL for writing and querying data. In the 2000s, non-relational databases became popular, referred to as NoSQL because they use different query languages."

For those we really want to learn more about databases, I recommand this really complete video :

FOR A NICE VIDEO click here

The idea

Let's consider we are a big supermarket. By definition we sell very different products from food to cosmetics and home products and so on. So we do not have one particular type of client but many : single man or woman, couples, families...
Databases could be useful for many situations

Situation 1


Imagine we have just received a new toys for children, with databases we can select from our clients only the one who are known for having having children. With our database we really target the very customer we need. Once we have identified these precise customers we can send them mails and alerts even some reductions for our product. This is a way more efficent way for targetting customers and of course improve our sales

Situation 2


Let's consider we have just receivede a a new collection of pets products. We want to advertise about these products but we need to target our customers efficiently. With a database we can for example make a query to sort out all the customers who have already buy something from the pet department. Once we have all the id of these customers we can send them an advertising email because we can legitimaly think that they have a pet or at least that they know someone with pets.

Situation 3

Let's suppose we want to improve our sales whatever the products bought are. We just want to make people come to our store and make them buy something. We can use our database, we can extract the names of the people that didn't purchase anything in our store for 2 or 3 weeks for example. Once we have extract these names from our database we can send them emails to let them know of our latest offers.