मराठी
महाराष्ट्र राज्य शिक्षण मंडळएचएससी विज्ञान (सामान्य) इयत्ता ११ वी

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

Advertisements
Advertisements

प्रश्न

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 )
एका वाक्यात उत्तर

उत्तर

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
);
shaalaa.com
Data Definition Language (DDL) Commands
  या प्रश्नात किंवा उत्तरात काही त्रुटी आहे का?
पाठ 2: Introduction to DBMS - Exercise [पृष्ठ २८]

APPEARS IN

बालभारती Information Technology (IT) [English] 11 Standard Maharashtra State Board
पाठ 2 Introduction to DBMS
Exercise | Q 4 | पृष्ठ २८
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×