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

Added on -2019-09-26

| 2 pages| 334 words| 415 views

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),

Found this document preview useful?

You are reading a preview
Upload your documents to download
Become a Desklib member to get accesss



Q&A Library Access

Chat support


Document Unlocks


Answer Unlocks

Students who viewed this