K notkshitij
  • Earth
  • Human

  • Joined on 2023-09-24
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 23:58:43 +05:30
2327418cdf Added queries for S9 (MySQL).
883422bf08 Added link for problem statements in readme.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 23:26:23 +05:30
d7a0bb4823 Added pdf for all problem statements (november 2024) for practical exam.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 23:10:26 +05:30
dcadee52ce Fixed union query since union combines results from two queries, but the number of columns and their data types must match.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 23:05:00 +05:30
3dc24979ba Added queries for S8 (MySQL).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 22:30:03 +05:30
0babf2b3ee Appended 1 to database name to avoid conflits with other store databases.
notkshitij pushed to main at sppu-te-comp-content/ComputerNetworksAndSecurity 2024-11-09 22:00:57 +05:30
3e5b5e8b10 Removed header and copying restrictions.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 18:12:42 +05:30
9a7978235b Merge remote-tracking branch 'refs/remotes/origin/main'
b36213a58d Fixed query 2
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 16:13:22 +05:30
ddb2505d9f Fixed unique index query (query 5).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 16:10:09 +05:30
1ca836f6a1 Added queries for S7 (MySQL).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 15:27:11 +05:30
3dc3d1e78c Added select statement to view changes after firing query 1.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 15:24:40 +05:30
0178c80bf5 Added queries for S6 (MySQL).
8936f48ab7 Appended 1 in database name to avoid conflict with S6.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 13:13:32 +05:30
005b7e3a40 Added describe table line in 5th query to view changes.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 13:11:43 +05:30
c672bfb5f9 Added select line in 3rd query to view changes.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 13:09:32 +05:30
802e2107cd Added queries for S5 (MySQL).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 12:14:42 +05:30
3a80156268 Added P10 trigger (plsql). Engineered by Macho.
997137287e Added out params for function as per req. p.s. Thanks to Macho for providing the patch.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 11:52:06 +05:30
06c90bf376 Deleting one instead of many in 5th query.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 11:50:35 +05:30
ff283c93df Fixed 3rd query, added or thingy.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 02:11:37 +05:30
86ba61f9c3 Added queries for P5. Thanks to Macho, again.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 02:06:02 +05:30
9a7400d5d8 Moved p.s. up to p.s. heading. Also, thanks to Macho for these queries!
d2e3e5037c Added P4 queries (PL/SQL). Engineered by Tanmay Macho.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 01:55:14 +05:30
ba84cdf1cc Added queries for S4 (MySQL).
9bbf098f55 Added horizontal line at end.
Compare 2 commits »