Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Create Table:. create table Artist(. ArtistID int prima

Added on - 25 Sep 2019

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 1 of 2 pages
Create Table:create table Artist(ArtistID int primary key,ArtistName varchar(20),ArtistContactNo int,ArtisEmail varchar(25));create table MusicTitle(TitleID int primary key,TitleName varchar(20),CreatedDate Date,ArtistID int,FOREIGN KEY (ArtistID) REFERENCES Artist(ArtistID));Data populated in tableInsert into Artist (ArtistID,ArtistName ,ArtistContactNo,ArtisEmail)values(1001,'George',3456789,''),(1002,'Jeorge Fd',34666789,''),(1003,'Smith',34567889,''),(1004,'Rebecca S',3666669,''),(1005,'Goel RB',34566669,''),(1006,'Nick Nine',67788889,'');Insert into MusicTitle (TitleID,TitleName,CreatedDate,ArtistID)values(2001,'Fire','2018-10-10',1001),(2002,'Thrill Nine','2018-11-12',1002),
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document