Question: You need to submit the MySQL code to create the tables. Choose accordingly the data types, the parameters of the data types (UNSIGNED, AUTO_INCREMENT, NOT
You need to submit the MySQL code to create the tables. Choose accordingly the data types, the parameters of the data types (UNSIGNED, AUTO_INCREMENT, NOT NULL, and so on...)
A company nearby has asked for your help. They are working on a blockchain-based AI, with access to a database containing the video output of 900 cameras.
The database should contain these information in one table, meant to contain video data:
- ID of the camera
- Timestamp
- Video content
- Thumbnail of the video (one-frame image)
- Hash of the video content (using SHA-256 stored in binary, that is, each hash is always 32 bytes)
And these in another table, meant to contain images taken from such videos:
- Hash of the video content (using SHA-256 stored in binary, that is, each hash is always 32 bytes)
- Timestamp
- Image content
- Timestamp of the image taken from the video
Add a description of the data types selected, that is, why you think it is the best choice
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
