Documentation Introduction Assignment 2022

Documentation
Introduction:
JSON (JavaScript Object Notation) which is the lightweight format which is used to
interchange data. The JSON format are easy for the human to read, write and understand and
easy for the computer to parse them and extract data. The task of the assignment is to implement
the JSON field into the existing customer table of the classic mode database. Then insert 3 data
values into the customer table and to finally display the customer details which contains data in
the JSON field. The assignment also describes about JSON together with its significant
advantages and disadvantages (Tahaghoghi & Tahaghoghi, 2011).
Task:
Adding JSON Field to Customers Table:
The initial structure of the Customer table is given below:
A JSON field named “customers_contacts” is added to the Customer table using the following
query (Glendon, 2011):
Query:
ALTER TABLE customers ADD COLUMN customers_contacts JSON DEFAULT NULL;
Now the structure of the customer table is modified as shown below:

Inserting data into JSON Field:
The customers table’s “customers_contacts” JSON field is inserted with the following keys data:
 customerNumber
 contactLastName
 contactFirstName
The SQL query used to insert 3 values to the JSON field of the customer table is given below
Query:
update customers set
customers_contacts='{"customerNumber": 103, "contactLastName": "Schmitt",
"contactFirstName": "Carine"}'
where customerNumber=103;
update customers set
customers_contacts='{"customerNumber": 112, "contactLastName": "King",
"contactFirstName": "Jean"}'
where customerNumber=112;
update customers set
customers_contacts='{"customerNumber": 114, "contactLastName": "Ferguson",
"contactFirstName": "Peter"}'
where customerNumber=114;