Block a user
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.
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
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.
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.
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.
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.