The first picture below is the relationship model of the platform we would like to create which is a live-streaming platform. The second and third picture shows what are the data within these tables. Currently trying to figure out what code Creation of Tables and Insertion of Data is needed for order and matching design junction table. The code should show me how to insert the data and the tables itself and would be referred to the tables shown in the picture. I need to know 1. the code used to create the table, 2. the code used to insert the data, and 3. a screenshot of the table itself for both the order and the matching junction table. I'm struggling to figure out what are the codes need to create the table and insert the data. I've provided examples for customer service below. Please help!!!!

 

Relationship model:

 

Information needed to insert into matching junction table:

 

Information needed to insert into order

 

Examples from the above relationship model are below:

code for creation of table:

CUSTOMER_SERVICE table—

CREATE TABLE `abc_vc`.`CUSTOMER_SERVICE` (

  `SERVICE_ORDER_ID` INT NOT NULL,

  `DESCRIPTION` VARCHAR(1000) NOT NULL,

  `STATUS` VARCHAR(45) NOT NULL,

  `MANAGER_ID` INT NOT NULL,

  PRIMARY KEY (`SERVICE_ORDER_ID`),

  FOREIGN KEY (MANAGER_ID) REFERENCES MANAGERS (MANAGER_ID)

  UNIQUE INDEX `SERVICE_ORDER_ID_UNIQUE` (`SERVICE_ORDER_ID` ASC));

 

code for insertion of table:

CUSTOMER_SERVICE table—

INSERT INTO `abc_vc`.`CUSTOMER_SERVICE` (`SERVICE_ORDER_ID`, `DESCRIPTION`, `STATUS`, `MANAGER_ID`) VALUES 

('200010001', 'Refund', 'FINISHED', '10001'), 

('200010002', 'Complaint', 'WORKING', '10004'),

('200010003', 'Product Return', 'WORKING', '10001'), 

('200010004', 'Product Return', 'WORKING', '10005'), 

('200010005', 'Complaint', 'FINISHED', '10003'), 

('200010006', 'Refund', 'FINISHED', '10004'), 

('200010007', 'Refund', 'WORKING', '10002'), 

('200010008', 'Complaint', 'FINISHED', '10002');

 

Information needed to insert into customer service table

 

 

Examples from another relationship model (examples, not information used for the above question):

 

  
 
 
 
 
 
 

Customer Service Service Order_ID Description Status Mangager_ID Customer Service User Junction Table User ServiceOrder_ID PK,FK1 User ID PK, FK2 Order_detail Product ID User ID User detail User address PK Order Order_ID Product ID Product_quantity FK Description User ID PK PK FK1 FK2 Managers Manager_ID Name Age Improvement Ideas Managerial Decisions Live-Streaming Employees Account ID LS_Employee_ID LS_Employee_Details Manager_ID LS_Employee_Title Contact_Junction Table Vendor_ID Account ID Contact Information Vendor Vendor ID Vendor Type Vendor_Name Vendor-Location Vendor-Experience PK Products Product ID Product Category Price Description Vendor_ID PK, FK1 PK, FK2 PK PK FK PK FK TH Operation Teams Operation Employee_ID Manager_ID Operation Teams_Title Advertisement Advertisement_ID PK Operation Employee_ID FK Advertisement_Name Advertisement Amount Advertisement_Time PK FK Matching Design Junction Table Product ID Advertisement_ID Advertisment_Design_For Each_Product PK, FK1 PK, FK2