I need one or more queries on the basis of database of netflix. I can upload the picture of database Create Index Modify Table Schema
I need one or more queries on the basis of database of netflix. I can upload the picture of database
Create Index Modify Table Schema Delete Table Print CREATE TABLE Dates ( [PK] INTEGER PRIMARY KEY AUTOINCREMENT, [Date Added] integer not null, [RealeaseYear] integer not null, [ShowID] INTEGER not null REFERENCES Shows (ShowID)) CREATE TABLE Directors ( [PK] INTEGER PRIMARY KEY AUTOINCREMENT, [DName] Text not null, [ShowID] INTEGER not null REFERENCES Shows (ShowID)) CREATE TABLE Genres ( [GenrelD] Integer not null primary key, [Genre] Text not null) CREATE TABLE Ratings ( [PK] INTEGER PRIMARY KEY AUTOINCREMENT, [Rating] Text not null, [ShowID] INTEGER not null REFERENCES Shows (ShowID)) CREATE TABLE Shows ( [ShowID] Integer not null primary key, [Tittle] Text not null, [GenrelD] Text, [Country] Text, [Description] Text) CREATE TABLE sqlite_sequence (name,seq)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started