Commit Graph

Select branches

Hide Pull Requests

main

Mono Color

• 6b9217bcd6
  
  Fixed blurry pdf due to extreme compression. main Kshitij 2024-11-25 00:43:00 +0530
• b53f57cd14
  
  Locally referenced all the links in readme. Also, added link for unit 6 notes. Kshitij 2024-11-22 22:18:10 +0530
• 8a2203c219
  
  Added unit 6 ppt. Not sure if this is the one shared by ma'am, although the format looks similar so ig yes? Kshitij 2024-11-22 22:15:59 +0530
• 05221a5d38
  
  Added 2023 (may-june + november+december) and 2024 (may-june) question papers for dbms. Thanks to Prathamesh for sharing them! Kshitij 2024-11-22 22:10:01 +0530
• e91e06c7e1
  
  Added november-december to solved 2023 question paper to be more specific. Kshitij 2024-11-22 22:04:20 +0530
• 7c7d251ced
  
  Added comment for input in p_roll Kshitij 2024-11-11 23:52:41 +0530
• 8ffbbcf06b
  
  Minor change to P2, added input for book in quotes and fixed Status datatype. Kshitij 2024-11-11 23:51:21 +0530
• aea7ec864a
  
  Added queries for M6 (mongo). Kshitij 2024-11-10 22:46:59 +0530
• c7a40d7ed0
  
  Added P8 trigger (PLSQL) Kshitij 2024-11-10 22:34:09 +0530
• 778cf6f892
  
  Added p.s. and changed function name to match p.s. Kshitij 2024-11-10 22:10:04 +0530
• b5cd49389b
  
  Added queries for P6 as per p.s., no roll in Stud_Marks table but in Result makes it quite dumb. Kshitij 2024-11-10 21:52:07 +0530
• 3309645905
  
  Removed .obisidian folder from SQL, might be accidentally pushed by Afan. Shoulda taught him .gitignore 🙄 Kshitij 2024-11-10 21:51:32 +0530
• 59d480fceb
  
  Fixed problem statement line break. Kshitij 2024-11-10 21:45:31 +0530
• 9318f3069b
  
  Appended block in filename for P1 so it doesn't feel lonely. Kshitij 2024-11-10 19:35:37 +0530
• ad930d8a5a updated readme.md Afan Shaikh 2024-11-10 21:31:52 +0530
• a299cbc9b3 Fixed Deletion of records in SQL S3.4 Afan Shaikh 2024-11-10 21:25:06 +0530
• 42363aa8eb
  
  Fixed others exception Kshitij 2024-11-10 19:33:00 +0530
• 4d878d51ca
  
  Made changed to data inserted in table. Added another exception and changed outputs to be more polite. Kshitij 2024-11-10 19:31:16 +0530
• ceabc021bd
  
  Added plsql code blocks for P1, P2, P3 (sqlplus). Kshitij 2024-11-10 19:07:37 +0530
• 110255f6d1
  
  Added C1 mongo connectivity. Kshitij 2024-11-10 16:02:27 +0530
• 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 Kshitij 2024-11-10 15:52:25 +0530
• 3692f8819d
  
  Changed C1 to C2 since it's C2 Kshitij 2024-11-10 15:44:59 +0530
• bc04babb8d
  
  Added mysql connectivity. Kshitij 2024-11-10 15:44:08 +0530
• 51a7f8cb49
  
  Added queries for M5 (MongoDB). Kshitij 2024-11-10 12:51:21 +0530
• 7261620545
  
  Added indexing in filename and title in file since it also contains indexing! Kshitij 2024-11-10 12:50:32 +0530
• a716d17799
  
  updated macho's phone number Kshitij 2024-11-10 12:19:21 +0530
• 61af64c72e
  
  Simplified query 6. Kshitij 2024-11-10 12:16:58 +0530
• 0e41344f45
  
  Updated output for query 6 after running on new machine. Kshitij 2024-11-10 12:12:19 +0530
• 5476813944
  
  Appended 2 to database name to avoid conflit with crud operations. Kshitij 2024-11-10 12:10:20 +0530
• 964f534b16
  
  Added queries for M4 (MongoDB). Kshitij 2024-11-10 12:08:48 +0530
• 151fab47d8
  
  Appended 1 to database name to avoid conflict with aggregation p.s. Kshitij 2024-11-10 11:29:54 +0530
• 3175ea83b5
  
  Fixed query 7, didn't realize count was already there, wayyyyyyyyyy too sleeeppyyyyyy to see that 😫 Kshitij 2024-11-10 00:56:55 +0530
• 02e284ad48
  
  Moved s9 to SQL folder, forgot about that, i'm sleepppppyyyyyyyyyyy Kshitij 2024-11-09 23:59:11 +0530
• 2327418cdf
  
  Added queries for S9 (MySQL). Kshitij 2024-11-09 23:58:23 +0530
• 883422bf08
  
  Added link for problem statements in readme. Kshitij 2024-11-09 23:27:27 +0530
• d7a0bb4823
  
  Added pdf for all problem statements (november 2024) for practical exam. Kshitij 2024-11-09 23:24:27 +0530
• dcadee52ce
  
  Fixed union query since union combines results from two queries, but the number of columns and their data types must match. Kshitij 2024-11-09 23:10:17 +0530
• 3dc24979ba
  
  Added queries for S8 (MySQL). Kshitij 2024-11-09 23:04:43 +0530
• 0babf2b3ee
  
  Appended 1 to database name to avoid conflits with other store databases. Kshitij 2024-11-09 22:29:36 +0530
• 4a934c1bbd updated query 3 of s5 since we're supposed to update city column of employee table and not company Tanmay 2024-11-09 20:38:30 +0530
• 9a7978235b
  
  Merge remote-tracking branch 'refs/remotes/origin/main' Kshitij 2024-11-09 18:12:15 +0530
• b36213a58d
  
  Fixed query 2 Kshitij 2024-11-09 17:25:42 +0530
• 371bf261b9 fixed s7 problem statement Tanmay 2024-11-09 16:41:54 +0530
• ddb2505d9f
  
  Fixed unique index query (query 5). Kshitij 2024-11-09 16:13:12 +0530
• 1ca836f6a1
  
  Added queries for S7 (MySQL). Kshitij 2024-11-09 16:09:38 +0530
• 3dc3d1e78c
  
  Added select statement to view changes after firing query 1. Kshitij 2024-11-09 15:26:58 +0530
• 0178c80bf5
  
  Added queries for S6 (MySQL). Kshitij 2024-11-09 15:24:21 +0530
• 8936f48ab7
  
  Appended 1 in database name to avoid conflict with S6. Kshitij 2024-11-09 15:07:32 +0530
• 005b7e3a40
  
  Added describe table line in 5th query to view changes. Kshitij 2024-11-09 13:13:24 +0530
• c672bfb5f9
  
  Added select line in 3rd query to view changes. Kshitij 2024-11-09 13:11:34 +0530
• 802e2107cd
  
  Added queries for S5 (MySQL). Kshitij 2024-11-09 13:09:12 +0530
• 3a80156268
  
  Added P10 trigger (plsql). Engineered by Macho. Kshitij 2024-11-09 12:14:26 +0530
• 997137287e
  
  Added out params for function as per req. p.s. Thanks to Macho for providing the patch. Kshitij 2024-11-09 12:05:14 +0530
• 06c90bf376
  
  Deleting one instead of many in 5th query. Kshitij 2024-11-09 11:51:58 +0530
• ff283c93df
  
  Fixed 3rd query, added or thingy. Kshitij 2024-11-09 11:50:08 +0530
• 86ba61f9c3
  
  Added queries for P5. Thanks to Macho, again. Kshitij 2024-11-09 02:11:29 +0530
• 9a7400d5d8
  
  Moved p.s. up to p.s. heading. Also, thanks to Macho for these queries! Kshitij 2024-11-09 02:05:09 +0530
• d2e3e5037c
  
  Added P4 queries (PL/SQL). Engineered by Tanmay Macho. Kshitij 2024-11-09 02:04:15 +0530
• ba84cdf1cc
  
  Added queries for S4 (MySQL). Kshitij 2024-11-09 01:54:49 +0530
• 9bbf098f55
  
  Added horizontal line at end. Kshitij 2024-11-09 01:07:32 +0530
• f793a97dd5
  
  Added links for all currently existing folders and contributors. Kshitij 2024-11-09 01:03:28 +0530
• bbbf3cbebc
  
  Added queries for S3 (MySQL). Kshitij 2024-11-09 01:00:17 +0530
• ea43287640
  
  Added line break in outputs Kshitij 2024-11-09 00:49:29 +0530
• 395f3a985c
  
  Added trigger (P9), PL-SQL. Kshitij 2024-11-09 00:47:18 +0530
• 0314d38f20
  
  Added missing semicolon in example. Thanks to Narinder for pointing it out 🙇 Kshitij 2024-11-09 00:33:04 +0530
• f3eb6f536c
  
  Added age_calc function (P7). Kshitij 2024-11-08 23:10:40 +0530
• cd930f1bc6
  
  Added queries for S2 (MySQL). Kshitij 2024-11-08 22:58:34 +0530
• 0ad540721e
  
  Appended 1 to database name to avoid conflits with other p.s. using same structure. Kshitij 2024-11-08 22:40:27 +0530
• 4f2c23b85c
  
  Fixed query 1 and added missing query 2. Kshitij 2024-11-08 22:32:59 +0530
• 278126d752
  
  Added queries for S1 (MySQL). Kshitij 2024-11-08 22:28:19 +0530
• 453b265a8a
  
  Changed M2 to M3 in heading since it's M3! Kshitij 2024-11-08 17:17:36 +0530
• ba4b4629ce
  
  Added queries for M3 (crud operations) Kshitij 2024-11-08 17:15:46 +0530
• 24924e124c
  
  Capitalized contacts and address fields in M1 + M2. Kshitij 2024-11-08 17:11:32 +0530
• 56dc7b5ea1
  
  Moved M1 and M2 to MongoDB folder. Kshitij 2024-11-08 16:44:59 +0530
• 6eae704642
  
  Added queries for M2 (crud operations) Kshitij 2024-11-08 16:42:30 +0530
• 08d1bbd33c
  
  fixed one line since the ps was copied from pdf. Kshitij 2024-11-08 16:26:38 +0530
• 607730bcfb
  
  Added link for practical exam folder in main readme. Kshitij 2024-11-08 16:24:40 +0530
• 4225fcccf7
  
  Added readme and m1 queries. Kshitij 2024-11-08 16:22:47 +0530
• c5b8f8223e
  
  Simplified and improved queries for A6. - Separate sections for creating tables and inserting data - Fixed IF control block in procedure - Refined procedure and calling block Kshitij 2024-11-02 20:35:43 +0530
• 25e9652392
  
  Added queries to calculate the area of circle. Kshitij 2024-11-02 01:31:46 +0530
• 25e849ccd0
  
  Improved queries for A4. - Changed column names for better understanding - Changed dates in inserted data to show all fine cases - Added comments in procdure and changed variable names Kshitij 2024-11-02 01:14:37 +0530
• ebe898535f
  
  Added updated database_a2 file. Kshitij 2024-11-01 02:25:10 +0530
• 0c887415b3
  
  Simplified queries for A2: - Creating tables on multiple lines for better understanding - Changed names of columns to match names in assignment handout - Updated some values so that each query in implementation gives valid output - Lastly, simplified some queries and changed column names Kshitij 2024-11-01 02:22:03 +0530
• fa91c4f08f
  
  Merge remote-tracking branch 'refs/remotes/origin/main' Kshitij 2024-10-28 13:46:26 +0530
• f854578401
  
  Moved Queries-A7 to Queries-A8 since A8 is the library/trigger one. Again, thanks to Shivani for pointing it out. Kshitij 2024-10-28 13:41:22 +0530
• cd04378e95
  
  Moved old Queries-A6 to Queries-A7 since it's the cursor assignment. Kshitij 2024-10-28 13:40:40 +0530
• 82db5216cb
  
  Moved Queries-A5 to Queries-A6 since it's student marks procedure which is Assignment A6. Thanks to Shivani for pointing it out. Kshitij 2024-10-28 13:38:55 +0530
• 7649d531ba
  
  Added title for queries-a4. Kshitij 2024-10-28 13:34:55 +0530
• 11ec5cadb3
  
  Added title in queries-a3 file. Kshitij 2024-10-28 13:31:32 +0530
• db10885c0e fixed query 2 Tanmay 2024-10-23 10:41:46 +0530
• bbc5a7e385
  
  added connectivity content Kshitij 2024-10-21 23:14:03 +0530
• 1c02a1a0f7
  
  Added handout for A9+B4+C1 (Mini Project) Kshitij 2024-10-21 22:07:23 +0530
• c8c1bce56e
  
  Added dbms 2023 solved previous year question paper (for end sem) Kshitij 2024-10-19 22:46:19 +0530
• 1cb7322a0d
  
  Added queries and softcopy for B3. Kshitij 2024-10-17 20:45:34 +0530
• e0d47201ee
  
  Fixed some questions to match the queries. Kshitij 2024-10-17 20:27:09 +0530
• 37fc21421d
  
  Added softcopy for B2. Kshitij 2024-10-17 20:18:31 +0530
• 34a507522a
  
  Made minor changes to queries to show output. Kshitij 2024-10-17 20:18:19 +0530
• fed7e0adb1
  
  Added new line in each code block to automatically execute on copy. Kshitij 2024-10-17 19:49:03 +0530
• acc16d556c
  
  Added softcopy for B1. Kshitij 2024-10-17 19:44:40 +0530
• 0ccd263ce0
  
  Made changes to query 9 to show some output. Kshitij 2024-10-17 19:43:48 +0530