/Database-Management-Systems

Coursework for Database Management Systems@IISERB-Fall'22

Primary LanguageJupyter Notebook

DSE 310: Database Management Systems (Fall Semester-2022)

Course Instructor: Jasabanta Patro

Coursework: Assignments


Assignment Question

need to write a python program that can

(a) Do data definition operations (Create, Drop and Modify schemas/tables)

(b) Do data manipulation operations (Insert, Update, Select, )

(c) Add integrity constraints (Declare 'NotNull', Primary keys, Foreign keys). It should show errors if an integrity constraint can not be added.

(d) Add/remove users and their privileges. It should show errors in case a privilege can not be given or removed.