Question

Q.4 Create a table for the information
given below by choosing
appropriate data types. Specify
proper primary key for the table
1) Movie 2) Actor
1. Movie (Registeration_no,
movie_name, Realease_Date)
2. Actor ( actor_id, Actor_name,
birth_date )​

Answer 1

Answer:

answer is given in the attachment

Explanation:

Answer 2

The create command for the Movie and Actor table is listed below:

Explanation:

Create command For Movie table:

CREATE TABLE Movie (Registeration_no int NOT NULL PRIMARY KEY,

movie_name $varchar$(30), Realease_Date date); /*Registeration_no is a primary key for the above table*/

Create command For Actor table:

CREATE TABLE Actor (actor_id int NOT NULL PRIMARY KEY,

Actor_name $varchar$(30), birth_date date); /*actor_id is a primary key for the above table*/

Code Explanation:

• The create command is used to create a table in the database, to do this a user needs to first select the database then use the create command.
• The syntax to use create command is:- CREATE TABLE TABLE_NAME ( FIRST_ATTRIBUTES_NAME DATA_TYPE (SIZE), SECOND_ATTRIBUTES_NAME DATA_TYPE (SIZE), ___, LAST_ATTRIBUTES_NAME DATA_TYPE (SIZE) );

Learn More :

• SQL create command : https://brainly.in/question/12454628