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

Found this document preview useful?

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

Premium

$45

Q&A Library Access

Chat support

12

Document Unlocks

4

Answer Unlocks

Students who viewed this