Write node code to insert data to all the tables


Assignment: MySQL Database

o Create a MYSQL Database.

o Create two/three Tables under the database; ensure there is one-to-many or many-to-many relationship in between tables.

o Write node code to insert data to all the tables. Create a generic function which will take the table name, query as parameter to insert data into the tables.

o Write node code to get data from the tables. Create least 5 different queries to find data from database (the find queries must have combination of and/or/gt/ls/like commands available to retrieve data). Use table joins when you retrieving the data.

o Write node code to update data into the table.

o Write node code to delete data from table. When you delete data ensure that related data in the other table also get deleted.

Format your assignment according to the following formatting requirements:

o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.

o The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.

o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write node code to insert data to all the tables
Reference No:- TGS03121370

Expected delivery within 24 Hours