Database. Modeling Base Structure
|1.||STRUCTURE OF DATABASE||4|
|1.1.||Relationship and table descriptions||4|
|1.2.||Table field information||6|
|1.3.||Queries field information||7|
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.