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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!