-
Database. Modeling Base Structure
| Nr. | Chapter | Page. |
| INTRODUCTION | 3 | |
| 1. | STRUCTURE OF DATABASE | 4 |
| 1.1. | Relationship and table descriptions | 4 |
| 1.2. | Table field information | 6 |
| 1.2.1. | Studenti | 6 |
| 1.2.2. | Sekmes | 6 |
| 1.2.3. | Prieksmets | 6 |
| 1.2.4. | Dzivesvieta | 6 |
| 1.2.5. | Pasniedzejs | 7 |
| 1.2.6. | Stipendijas | 7 |
| 1.3. | Queries field information | 7 |
| 1.3.1. | studentuDzivesvieta | 7 |
| 1.3.2. | transpKompensacija | 8 |
| 1.3.3. | videjasAtzimes | 8 |
| 1.3.4. | kopejaStipendija | 9 |
| 2. | USED PROPERTIES | 9 |
| CONCLUSIONS | 11 |
CONCLUSIONS
Designing and constructing simple database is a task that anyone could do. All depends on how we chose to do it. To maintain simple database you don’t need a higher degree or inconceivable knowledge, but as the database gets more complex you are required to either get help or start studying.
While doing this project I understood that you can easily have one table of contents instead of 5 or more. In my case I have 6 and I have come to conclusion that I can combine at least 3 of them. One of the combinable tables is Studenti and Dzivesvieta. But I left them separate because I understood this too late. Also I could have combined tables Prieksmets and Pasniedzejs, but I chose not to, basically, because in real life there are possible table fields added, such as lector’s salary or lector’s lecture list and so on.
Creating databases gives you opportunity to understand simple panning skills which is quite useful if you take it seriously. Database as its own is very worthwhile because if you understand what you are doing you can create and maintain quite big database that obtains some serious information on chosen subject.
…
Databases are commonly used as a simple file that contains specific information about the keeper. Database can and are used in almost every corporation or business, no matter how small or bit it is. It is quite simple to create a database that contains some information like students name and surname and some grades, but it gets harder when we add some specific information like who inserted some specific grade in some specific subject. This is the point when a smart student or paid employee comes in and handles it. Databases most likely obtain queries with specific information. Queries can be created in two different ways. Design view which is basically used by ordinary people and SQL view. SQL queries are made with a unique programming language. The language is not very difficult, but ordinary people usually don’t use it
