DATA BASE

I have done my data base and my tables in group with Ismael Leal and Paolo de Miguel.
Firstly we did the tables for our bussiness with LibreOfiice. We made diffrent tables: one for suppliers, one for clients, one for products, one for countries and another for transactions.
This is the table of suppliers:
 In this table we have 61 dates.

This is the table of transactions:
In this table we have 103 dates.

This is the table of clients:
 In this table we have 62 clients.

This is the table of countries:

 This is the table of products:
In this table we have 81 dates.

When I finished all the tables we created the data base with LibreOfffice Base creating tables with the same information and copying from the previous ones.
Here is an example of the table of the clients:

When I made this tables I had to gave a number for the space of each date and I created a primary kley for every table with the option of editting the tables. When I finished the tables I created the relations between different information of different tables. Here you have the relations:
Once I had the relations I started with the queries. I had made five different queries:

The first was about how many clients do I have from Spain.
To make this queries I used this procedures:

The second query was about how many clients do I have in a population over twelve million.

To make this query I used this procedures:

The third query was about who bought the product in which the IDPROD is PR008:

To make this query I used this information:

The fourth query was about how much money do spend the clients of every country:

To prepare this query I used this information:

The fifth query was about how many suppliers are from US:

To the information to prepare this query is:


Comentarios

Publicar un comentario

Entradas populares de este blog

PSEINT

Imagen
On this term I have worked with the program called PSeint, that is used to learn programation and to resolve algorithms. I have made three different projects with this technological tool: The first project consists on giving a list of all the prime numbers less than one given. This are the codes that gives the instruction for the function. This is the result of the function and it gives you all the prime numbers less than 36. The second project consists on writing different numbers and the function order to return them organized.  This are the codes used to make the correct function. This is the result of the function that organize the numbers given from the minors to the majors. The third project consits on giving one number and the function orders to give you all the numbers that are lesser than it and appear on the Fibonacci list. This are the codes used in order to prepare all the Fibonacci numbers that are lesser than the one given. 
Leer más
Imagen
PACMAN I have done the shape of this pacman modifing the shape of the circle with the nodes and the same with the eyes. I have done a radial degraded of the colour and also for the shadow. MODIFIED PACMAN This is the same pacman but I have modified it doing a hat modifing the nodes of a circle shape. COMIC CHARACTER   I  have done this character tracing with lines a simillar image and applying the colour inside the figures. PERSONAL CHARACTER I have done this person drawing it with lines, applying colours inside the figure and making one radial degraded to the colour of the T-shirt. LANDSCAPE I have done this landscape tracing a simillar image with the funcyion of making lines and in the colour of the sea and clouds I have added a degrade of the colour to make the shadows in the sky and in the sea. LA HABITACIONDE ARLES  I have done it tracing this famous painting of Vince
Leer más