DBVS 2 laboratorinis darbas: programavimo projektų idėjų dalinimosi svetainės duomenų bazė
Autorius: Vytautas Strimaitis, 2k, 5 gr., Programų sistemos, MIF VU 2016
Pirmoji dalis
ER diagrama
Duomenų bazės reliacinė schema
Antroji dalis
Duomenų bazės kūrimo rezultatas
| Id | Name |
|---|---|
| 1 | C |
| 2 | C++ |
| 3 | Python |
| 4 | C# |
| 5 | JAVA |
| 6 | Javascript |
| 7 | Ruby |
| 8 | PHP |
| Id | Username | First_Name | Last_Name | Password | DOB | |
|---|---|---|---|---|---|---|
| 1 | john.doe@gmail.com | johnnyboy | John | Doe | 5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8 | 1970-01-13 |
| 2 | fake@gmail.com | vstrimaitis | Vytautas | Strimaitis | 5bf6c973b85757fda1cac3f47ec85ae7158dd00a3d1de34203e2860078a3d89e | 1997-02-21 |
| 3 | lord123@yahoo.com | mastahOfCode | 24145fd494db7255954cb75ee69065bceb92ea99d5da9f9185b976778cfe3a88 | |||
| 4 | default@email.com | user4 | Default | User | 5e884898da28047151d0e56f8dc6292773603d0d6aabbdd62a11ef721d1542d8 | 1996-01-01 |
| User_Id | Programming_Language_Id | Proficiency |
|---|---|---|
| 1 | 1 | 0 |
| 3 | 1 | 3 |
| 3 | 2 | 1 |
| 3 | 4 | 2 |
| 3 | 5 | 0 |
| 2 | 1 | 4 |
| 2 | 2 | 5 |
| 2 | 3 | 2 |
| 2 | 4 | 4 |
| 2 | 5 | 1 |
| 2 | 6 | 2 |
| 2 | 8 | 1 |
| Id | User_Id | Publish_Date |
|---|---|---|
| 1 | 1 | 2016-11-15 |
| 2 | 2 | 2016-11-14 |
| 3 | 3 | 2016-11-16 |
| 4 | 3 | 2016-10-05 |
| 5 | 1 | 2016-11-15 |
| 6 | 2 | 2016-11-16 |
| 7 | 2 | 2016-11-15 |
| 8 | 3 | 2016-11-15 |
| 9 | 1 | 2016-11-14 |
| 10 | 2 | 2016-11-10 |
| 11 | 3 | 2016-10-05 |
| 12 | 1 | 2016-11-16 |
| Entity_Id | User_Id | Rating |
|---|---|---|
| 1 | 2 | 1 |
| 1 | 3 | -1 |
| 2 | 1 | -1 |
| 3 | 1 | 1 |
| 3 | 2 | 1 |
| 4 | 1 | -1 |
| 4 | 2 | -1 |
| 5 | 2 | 1 |
| 5 | 3 | 1 |
| 8 | 1 | -1 |
| 9 | 2 | 1 |
| 10 | 1 | -1 |
| 10 | 2 | -1 |
| 11 | 1 | 1 |
| 11 | 3 | -1 |
| 12 | 3 | -1 |
| Id | Title | Content |
|---|---|---|
| 1 | My first post | Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nullam viverra laoreet justo, eget porttitor lorem. Nunc luctus sem eu auctor placerat. In elit nisi, gravida vel semper in, rhoncus et nisl. Praesent rutrum dui ac faucibus facilisis. Ut hendrerit faucibus lorem sed viverra. In interdum, mauris eget luctus tempor, arcu mauris placerat risus, sit amet sagittis mauris nibh vel mi. Curabitur rhoncus scelerisque commodo. Quisque id eros leo. |
| 2 | How to post | content content content... |
| 3 | Third time's the charm say scientists?! | Not really, this was just clickbait xD |
| 4 | *Insert clickbait title here* | Useles info... |
| Post_Id | User_Id |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 4 | 2 |
| Id | Post_Id | Content |
|---|---|---|
| 5 | 1 | LOL :D |
| 6 | 1 | xDDDD |
| 7 | 1 | Great first post :) |
| 8 | 2 | one does not simply comment well... |
| 9 | 2 | another post, another comment |
| 10 | 4 | this is clickbait >:( |
| 11 | 4 | this is not clickbaity at all, y u so engri :( |
| 12 | 3 | silly title |