Advertisement Remove all ads

Create a table for the information given below by choosing appropriate data types. Specify proper primary key for the table 1) Movie 2) Actor - Information Technology

One Line Answer

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 )
Advertisement Remove all ads

Solution

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
);
Concept: Data Definition Language (DDL) Commands
  Is there an error in this question or solution?
Advertisement Remove all ads

APPEARS IN

Balbharati Information Technology (IT) 11th Standard HSC Maharashtra State Board
Chapter 2 Introduction to DBMS
Exercise | Q 4 | Page 28
Advertisement Remove all ads
Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×