Question

using sqlite3, create a db on movies, directors and publishing companies. they need to be relational. please add 5 movies.

Answer 1

Answer:
$sqlite3 MovieIndustry.db    //create database

sqlite> ATTACH DATABASE 'MovieIndustry.db' as 'movies';  //attach database statement

create table movie(
   mov_id INT PRIMARY KEY    NOT NULL,
   mov_Name       char(30)    NOT NULL,
   mov_time          INT     NOT NULL,
   mov_language      CHAR(10) NOT NULL,
);

create table director(
   dir_id INT PRIMARY KEY    NOT NULL,
   dir_Name       char(30)    NOT NULL,
   mov_id         INT     NOT NULL,
   constraint fk_movie
    FOREIGN KEY (mov_id)
    REFERENCES movie(mov_id)
);

create table publish_company(

com_id INT PRIMARY KEY NOT NULL,

com_name char(30) NOT NULL,

mov_id INT NOT NULL,

dir_id INT NOT NULL,

constraint fk_movie FOREIGN KEY (mov_id) REFERENCES movie(mov_id),

constraint fk_director FOREIGN KEY (dir_id) REFERENCES director(dir_id)

);

// inserting values into movie table

insert into movie values(901, 'vertigo', 128, 'English');

insert into movie values(902, 'the innocents', 100, 'English');

insert into movie values(903, 'lawrence of arabia', 216, 'English');

insert into movie values(904, 'Amadeus', 183, 'English');

insert into movie values(905, 'Blade Runner', 160, 'English');

// inserting values into director  table

insert into director values(201, 'Alfred', 903);

insert into director values(202, 'Jack', 901);

insert into director values(203, 'David', 902);

insert into director values(204, 'Michael', 905);

insert into director values(205, 'Ridley', 904);

// inserting values into publish_company table

insert into director values(101, 'Warner Bros',902,201 );

insert into director values(102, 'Walt Disney studios',901,203 );

insert into director values(103, 'universal pictures',904,202 );

insert into director values(104, 'lionsgate films',903,204 );

insert into director values(105, 'Paramount pictures',905,205 );