The first picture below is the relationship model of the platform we would like to create which
Question:
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):
Statistics Unlocking The Power Of Data
ISBN: 9780470601877
1st Edition
Authors: Robin H. Lock, Patti Frazer Lock, Kari Lock Morgan, Eric F. Lock, Dennis F. Lock