Database Management Process

Database Management Process

 Jupyter notebook data pushing process requires the setting up of the database using MySQL and ODBC. Tables must be linked, and the model established so that information can get to the back-end through a predefined API. All the queries processed then work as traditional ones, with the critical difference being the avenue of executing them. Jupyter does not provide any extra advantages apart from allowing easy integration of the SQL queries into the code under implementation. For instance, if one has to push a button through a graphical user interface, it becomes easier to implement such operations. The python code helps in minimizing the command prompt interaction between databases and the user. Overall, it offers ease of access and integration into real-life activities.

Setting the Databases

The database setup relies on three primary tools to ensure smooth operations and easy visualization of the data. MySQL server offers the foundation for database creation, management, and control. It holds all the data and allows various systems to access, store, and manipulate the information as needed.  MySQL Workbench is another crucial aspect of database management and control. It plays an immense role in the overall development, visualization, and control of the databases. For instance, if there is a need to create relationships between tables, it makes the tasks more manageable and efficient. One can operate without the involvement of workbench, but it will make tasks twice as tricky. PHP My admin is the last tool, and it helps in the actual testing of various tables and the way they operate when in use.

Executing the queries

The below queries are the tests to be pushed via the jupyter notebook interface to validate the operation of the database. Every one of the SQL commands will yield a result that will either be a success or a failure. The next section will analyze all the outputs and what went wrong in cases where the execution returns an error.

INSERT INTO employee VALUES

(‘Daniel’,’E’,’Borg’,’888665555′,’20-MARCH-10′,’450 Stone, Houston, TX’,’M’,167000, 333445555′,7);

Insert Into EMPLOYEE Values

(‘Jeff’,’H’,’Chase’,’333333301′,’07-JAN-1970′,’145 Bradbury, Sacramento, CA’,’M’,44000,’333333300′,7);

Insert Into EMPLOYEE Values

(‘Bonnie’,’S’,’Bays’,’444444401′,’19-JUN-1956′,’111 Hollow, Milwaukee, WI’,’F’,70000,’444444400′,7);

INSERT INTO department VALUES (‘Hardware’,7,’444444400′,’10-MARCH-2020′);

INSERT INTO project VALUES (‘ProductY’,2, Houston,7);

INSERT INTO dept_locations VALUES (7, Houston);

INSERT INTO dependent VALUES (‘333445555′,’FORTUNATUS’,’M’,’25-OCT-16′,’Son’);

INSERT INTO dependent VALUES (‘333445555′,’JANET’,’F’,’05-MAY-87′,’Spouse’);

INSERT INTO works_on VALUES (‘176456799’,1, 72.5);

UPDATE employee SET salary =25000+(25000*0.15) WHERE ssn = ‘ 987654321’;

Delete from employee where ssn=’987654321′

INSERT INTO employee VALUES

(Gracie,’S’,’Wallaby’,’187657321′,’20-MARCH-10′,’291 Berry, Bellaire, TX’,’F’,49000,’888665555′,7);

The results

INSERT INTO employee VALUES

(‘Daniel’,’E’,’Borg’,’888665555′,’20-MARCH-10′,’450 Stone, Houston, TX’,’M’,167000, 333445555′,7);

Insert Into EMPLOYEE Values

(‘Jeff’,’H’,’Chase’,’333333301′,’07-JAN-1970′,’145 Bradbury, Sacramento, CA’,’M’,44000,’333333300′,7);

Insert Into EMPLOYEE Values

(‘Bonnie’,’S’,’Bays’,’444444401′,’19-JUN-1956′,’111 Hollow, Milwaukee, WI’,’F’,70000,’444444400′,7);

INSERT INTO department VALUES (‘Hardware’,7,’444444400′,’10-MARCH-2020′);

INSERT INTO project VALUES (‘ProductY’,2, Houston,7);

INSERT INTO dept_locations VALUES (7, Houston);

INSERT INTO dependent VALUES (‘333445555′,’FORTUNATUS’,’M’,’25-OCT-16′,’Son’);

INSERT INTO dependent VALUES (‘333445555′,’JANET’,’F’,’05-MAY-87′,’Spouse’);

INSERT INTO works_on VALUES (‘176456799’,1, 72.5);

UPDATE employee SET salary =25000+(25000*0.15) WHERE ssn = ‘ 987654321’;

Delete from employee where ssn=’987654321′

INSERT INTO employee VALUES

(Gracie,’S’,’Wallaby’,’187657321′,’20-MARCH-10′,’291 Berry, Bellaire, TX’,’F’,49000,’888665555′,7);

Overall, the integration between various tools helps in indicating the use of interfaces to help in access of the databases and communicating with various programs that may need the avenues to help in the successful implementation of real-world systems. With such integration, it becomes easier to facilitate the proper interaction of programs and even multi-platform access and success in system implementation.