logo

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

2 Pages334 Words415 Views
   

Added on  2019-09-26

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

   Added on 2019-09-26

ShareRelated Documents
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),
Create Table:. create table Artist(. ArtistID int prima_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System: Entity Relationship Diagram, SQL Queries, Legal Issues and Security Techniques
|16
|1912
|240

Database Design in DBMS Tutorial: Learn Data Modeling
|17
|1795
|26

Database Modelling Assignment | Task
|11
|1429
|21

Task 1 CREATE TABLE EMPDB
|7
|1224
|62

Microsoft SQL Server Database Designs
|15
|1734
|98

Employee Database: ER Diagram, Table Commands, Sample Data, SQL Queries
|15
|704
|88