Databases

Show me how to construct a database in mySQL through the MySQL SHELL containing the tables shown subsequently. When creating the tables, your definitions must support key constraints and referential integrity constraints. You need to infer primary and foreign keys from the schema.

Important: You are not allowed to use any GUI tools (e,g., MySQL Workbench) to do this project. You are required to do it using native SQL in command line

Here is the schema

2780828472-123 8: 3 7 9 7 8 7 4 9 7 U 6 56 8 6 91424394444233446341464 131 23112 1 33 2 3 11 2 RE ON 2 2 2 2 2 2 3 3 222223333555555 y d ti i y nie SE N or- o N17523 T S N-1249 S3 1 2 2 1411623 21111432