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,'geo@ghjf.com'),(1002,'Jeorge Fd',34666789,'jf@ghjf.com'),(1003,'Smith',34567889,'sm@ghjf.com'),(1004,'Rebecca S',3666669,'rb@ghjf.com'),(1005,'Goel RB',34566669,'grb@ghjf.com'),(1006,'Nick Nine',67788889,'nnn@ghjf.com');Insert into MusicTitle (TitleID,TitleName,CreatedDate,ArtistID)values(2001,'Fire','2018-10-10',1001),(2002,'Thrill Nine','2018-11-12',1002),
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document