Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.





During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good.

During the weekend we had been trying to do trips ,

I had been two times in Wien ,once of them I was with the Refi , and other one I was only with Blanca and although I had been in Wien before I think it is marvellous an d I have plan to return to Wien In February with my family before the new semester start.



We went yet to Prague , Salzburg , Hallstag , Cracow , Munich and we went two weeks ago to doing Ski It was impressionist!!



In conclusion , it was an incredible semester , furthermore i think I am going to pass all my subject ,but I hope the next one will be better , although It is difficult.

I hope all the people who reads my bloc enjoy and have a nice time.

Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.





During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good.


During the weekend we had been trying to do trips ,

I had been two times in Wien ,once of them I was with the Refi , yhe other one i was only with Blanca and altough I had been in Wien before I think it is marvellous an d I have plan to return to Wien In Fevrary with my family before the new semester start.

Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.





During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good .

Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.





During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good .
We went yet to Prague , Salzburg , Hallstag , Cracow , Munich and we went two weeks ago to doing Ski It was impresionant!! In conclusion , it was an incredible semester , furthemore i think I am going to pass all my subject ,but I hope the next one will be better , although It is difficult. I hope all the people who reads my bloc enjoy and have a nice time.

Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.





During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good .
We went yet to Prague , Salzburg , Hallstag , Cracow , Munich and we went two weeks ago to doing Ski It was impresionant!! In conclusion , it was an incredible semester , furthemore i think I am going to pass all my subject ,but I hope the next one will be better , although It is difficult. I hope all the people who reads my bloc enjoy and have a nice time.

Well the semester is going to finished and with these , these course. For me these course had been very interesting an funny because, it was the first time that I had listened classes in German and although I can not understand lots of thing, it was interesting.
So I want to tell so thing about my semester.
For me it was wonderful , when I arrived to Linz , I was afraid because , it was the first time that I was going to live alone (without my parents) and all in the country was new for me, but since the first time that I arrived , all was perfect.
I had living all the time in the raab heim , and I had had the same room with my friend Blanca ( the other girl which came class everyday with me) it is very funny . The residence had been incredible , there had been living lots of Erasmus , and now I had lots of friend.During the week , we have lots of party and dinner very funny.



During these four moths I had had time to do lots of things , during the week I went to my class I think I am going to pass all the course that I did , in fact I had passed two of there ,and for the other one I have not my marks but I hope to pass.
All the Thursday night I went to the mensa ( for me it was the best from Linz ) , there are subrrealistic , in fact al the people used to go very dunker at the Mensa , but if it is only for a day it isn´t so bad , furthemore , the place and the music for these kind of party is very good .
We went yet to Prague , Salzburg , Hallstag , Cracow , Munich and we went two weeks ago to doing Ski It was impresionant!! In conclusion , it was an incredible semester , furthemore i think I am going to pass all my subject ,but I hope the next one will be better , although It is difficult. I hope all the people who reads my bloc enjoy and have a nice time.

At the beginnig of the class we was talking about the date for the exam and some questions about that , after that we started the class with:

3.3.2.Relationale Bank.

3.3.2.1.Daten modelling.

If a relational database to be built, it is first of all a conceptual model that the users of application programs or data required describes developed.

One commonly used method of data modelling is the entity-relationship - model. Through entity relations relationship map, the object classes by rechecked, the relationships between the property by diamond type attribute necessary by the oval. Primary keys are underlined. In dependence of them, as many - to - many - relationships. Relationships can also attribute to have.

3.3.2.2. The business model.

The diagram is a simple business model an instructive book a commercial basis. The "customers" issue repeatedly "sluggish" to the teaching buch handel. Each "contract" can have several "books", each in any quantity ordered. Several "publishers" embarrassed "books" with a "book" with a certain number and title only of a "publishing house" can come as a certain "order" exactly one "customer" is assigned.

3.3.2.3. ER elements.

For graphical representation of the model he has presented ungs following elements:
A lot entiltäts than rectangle. In the book action there is the example entitäts volume customer. On contract. Paper and publishing. As entität be distinct objects from the world. These can be tangible or abstract nature.

An attribute is used as ellipse or district represents. In the book action - as the example has to contribute to attribute No, no release date customers.
Attributes (properties) risieren a entität characters or a relationship (see the relationship between the contribution and to book the amount of property. Order is made, how many exemplares a Paper in a contract to be ordered)

A key or primary key is in red.
Key used for sorting, searching and finding in databases. If an entity not appropriate key, can be added to artificial keys, such as a number. A primary key allows for the identification of any entity. It must be unique. So some may not two different customers the same customer number.

Relations between entities as diamonds drawn. In the diamond, the name of the relationship. To secure it, the reality derived from concepts to choose. A relationship volume is a collection of links to the same kind of linkage entity levels.
1:1 - Relationship: There can be only one element of an entity with one element from another entity connected.
1: n Relationship: An item from an entity with several other elements of a combined entity, but not vice versa.
N: m relationships: Any number of elements of an entity can use any number of other elements of a combined entity.
Special cases:
Part of relationship. In cases of aggregation. Should such collective works in a database abgbildet, so, for example, part of volumes.
Is-a relationship press a specialization or generalization. Example can entity quantities themselves in a lot merged entity. For example, "French textbooks" specialization of the entity quantity "language books."

3.3.2.4. Defining the relations (tables)

The presentation of the need in a facility Let ER diagram, with their relationships and attributes does not lead directly to the tables of a relational database. To deduce the corresponding tables are building for the tables to be observed, particularly in the so-called. Normal forms are combined.
A table is a collection of data on a given topic. If you have a theme for each separate table, avoiding duplicate data. The backup will be more efficient, and error in the input will be reduced.
In tables are data in columns (fields), and rows (records). Each field in the table seben book contains the information for each book.
There are 4 conditions on a table:
-- A table must be unique. This means that at no time two identical records in the table must exist. It contains only one record.
-- A table must atomic attributes and domains.
-- The records are at all times as unsorted.
-- The attribute sequence is never firmly defined.

The following operations are possible with tables:
-- A (blank) Data Set
-- A data (rate) search
-- Data fields
-- Delete a record
-- (Attributes add / delete)


3.3.2.5. Normalizing the tables

With the transfer of the object classes in these tables are then to examine whether they dependencies of the fields themselves. Normalizes, by progressively reviewed whether the tables formed in conditions of normal forms. During this normalization process comes to a reduction of redundancy, but also in parallel to an increase in the number of tables. Whenever discover redundancies will lead to the formation of new tables, through the key fields combined. The adaptation of the tables, on the key fields combined. The adaptation of the tables to the normal forms is the basis of SQL.

1. Normal Form: Remove Repetition group

Each field in the data set may be unique. There are several areas of the same type, they must own them in a relationship be saved.
The transfer of the object class "contract" in a table (relation), the verbal description of the business model accordingly "Each job may contain a number of books, each in any quantity ordered."
As a rule of order in several different books in different amounts, the fields: "Postionsnummer" and "quantity" several times before, was 1 Normal form objects.
The consequence is therefore outsourcing of repeat gruop in a separate table “Auftragspos" and the combination of the tables on the key fields.
The field "no" on the table "mandate" is key field of the table "contract" and is therefore compatible with the box “Auftragspos”. Order number". The names of the two fields differ, but the content is in both cases ident Here is an inevitable redundancy un relational databases, which are also controlled by redundancy and redundancy of not talking.
For the fulfillment of the business model described tasks sin detailed data about the books required.


And the end of the was the time to do question about the subject: we did three questuion, the first one was about the Function because we didn´t undestadb good the meaning of a logical fuction.The second one was the the cookie , because altough we had done a work about these , we can´t understan very well it , and the third one was about the handgloves, now we haven´t any problem about these things!!!!