Question

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

Create table movie (
Registration_no smallint primary key,
movie_name varchar (20),
Release_Date date
);
Create table actor (
actor_id smallint primary key,
Actor_name varchar (20),
birth_date date
);