Question

create a table for the information given below by choosing appreciate data types. specify proper primary key for the table
1. movie 2. actor
1. movie (Registration_ no , movie _ name, realease_ date )
2. Actor ( actor_ id, actor_ name, birth_ date)​

Answer 1

Answer:

For table creation is we will use the create query ,

create is a DDL , data definition language

The format of writing create query is

Create table Tablename(

attributes with their proper data types]

for 1. we need write the query like above making registration_no is primary key with data type int, movie name varchar, release date as date

for 2 . we need write the query like above making actor_id is primary key with data type int, actor name varchar, birth date as date