K notkshitij
1 Followers · 10 Following
  • Earth

  • Human

  • Joined on 2023-09-24
Repositories
5
 Projects Packages Public Activity Starred Repositories
6
notkshitij created repository notkshitij/scripts 2024-11-18 23:58:23 +05:30
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-11 23:54:06 +05:30
7c7d251ced Added comment for input in p_roll
8ffbbcf06b Minor change to P2, added input for book in quotes and fixed Status datatype.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 22:47:27 +05:30
aea7ec864a Added queries for M6 (mongo).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 22:34:32 +05:30
c7a40d7ed0 Added P8 trigger (PLSQL)
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 22:10:24 +05:30
778cf6f892 Added p.s. and changed function name to match p.s.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 21:53:33 +05:30
b5cd49389b Added queries for P6 as per p.s., no roll in Stud_Marks table but in Result makes it quite dumb.
3309645905 Removed .obisidian folder from SQL, might be accidentally pushed by Afan. Shoulda taught him .gitignore 🙄
59d480fceb Fixed problem statement line break.
9318f3069b Appended block in filename for P1 so it doesn't feel lonely.
Compare 4 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 19:33:13 +05:30
42363aa8eb Fixed others exception
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 19:31:37 +05:30
4d878d51ca Made changed to data inserted in table. Added another exception and changed outputs to be more polite.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 19:07:58 +05:30
ceabc021bd Added plsql code blocks for P1, P2, P3 (sqlplus).
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 16:02:57 +05:30
110255f6d1 Added C1 mongo connectivity.
2d3a9ff598 added comments for update and delete opn and added new line char in python3 execution command to automatically execute on copying. lastly changed pip to python3-pip
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 15:45:12 +05:30
3692f8819d Changed C1 to C2 since it's C2
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 15:44:29 +05:30
bc04babb8d Added mysql connectivity.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 12:52:00 +05:30
51a7f8cb49 Added queries for M5 (MongoDB).
7261620545 Added indexing in filename and title in file since it also contains indexing!
a716d17799 updated macho's phone number
Compare 3 commits »
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 12:17:10 +05:30
61af64c72e Simplified query 6.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 12:12:29 +05:30
0e41344f45 Updated output for query 6 after running on new machine.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 12:10:30 +05:30
5476813944 Appended 2 to database name to avoid conflit with crud operations.
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 12:09:15 +05:30
964f534b16 Added queries for M4 (MongoDB).
151fab47d8 Appended 1 to database name to avoid conflict with aggregation p.s.
Compare 2 commits »
notkshitij pushed to main at sppu-te-comp-content/ComputerNetworksAndSecurity 2024-11-10 11:20:43 +05:30
7d9458c3e2 Added answers for important viva questions. Thanks to Bhakti for her contribution!
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-10 00:57:26 +05:30
3175ea83b5 Fixed query 7, didn't realize count was already there, wayyyyyyyyyy too sleeeppyyyyyy to see that 😫
notkshitij pushed to main at sppu-te-comp-content/DatabaseManagementSystems 2024-11-09 23:59:20 +05:30
02e284ad48 Moved s9 to SQL folder, forgot about that, i'm sleepppppyyyyyyyyyyy