Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
Exam
Create table shop(shopid varchar(10),salary int,primary key (sid)); Create table customers(cid varchar(10),cname varchar(10),caddress varchar(10),ccity varchar(15),primary key (cid)); Create table staff(sid varchar(10),sname varchar(10),email varchar(15),shopid varchar(10),salary int,primary key (sid),foreign key(shopid) references shop(shopid)); Create table order(oid varchar(10),odate DATE,shopid varchar(10),cid varchar(10),primary key (oid),foreign key (shopid) references shop(shopid),foreign key (cid) references customers(cid));
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
TEST 2
Service broker
Stored Procedure
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries samples...
prince46
dbms
Training1
Mywall
Week 6 Data Base IET
manish
Please log in to post a comment.