-
Database Planing Project Description
Образец документа18 Компьютеры, программирование, электроника
Nr. | Название главы | Стр. |
INTRODUCTION | 3 | |
1. | STRUCTURE OF DATABASE | 4 |
1.1. | Database description | 4 |
1.2. | Relationship descriptions | 5 |
1.3. | Bonding explanation | 6 |
1.4. | Table explanation | 7 |
1.5. | Queries description | 8 |
1.5.1. | Creating tables | 8 |
1.5.2. | Creating views | 10 |
2. | USED PROPERTIES | 15 |
2.1. | Table field description | 15 |
2.1.1. | Godalga | 15 |
2.1.2. | Apdrosinasana | 15 |
2.1.3. | Pilseta | 15 |
2.1.4. | Krasa | 15 |
2.1.5. | Firma | 15 |
2.1.6. | Auto_godalgas_index | 15 |
2.1.7. | Modelis | 15 |
2.1.8. | Tehniska_ap skate | 16 |
2.1.9. | Klubs | 16 |
2.1.10. | Auto | 16 |
2.1.11. | Persona | 16 |
2.2. | Table field constrains | 17 |
New knowledge | 19 | |
CONCLUSIONS | 20 | |
REFERENCES | 21 |
CONCLUSIONS
Designing and constructing simple database is a task that anyone could do. All depends on how we choose 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.
In this project I made database to consume specific information about Retro cars. Database has10 tables. Some of them could have been divided into separate tables.
Project is made as an example for real life database. It holds only false information.
…
Databases are commonly used as a simple file that contains specific information about the keeper. A database can and are used in almost every corporation or business, no matter how small or big it is. It is quite simple to create a database that contains information like students name, surname and some grades, but it gets more complex when we add some specific information like who inserted some specific grade in some specific subject, it even gets harder when we start creating functions and adding indexes. This is the point when a smart student or paid employee comes in and handles it. Creating functions and adding indexes or even creating a table using PostgreSQL is not that simple. To login into PostgreSQL, the user has to create a database in cmd folder, then open sqlShell and login into the database using login and password.
