Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
db
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table employee ( lname varchar(20) not null, fname varchar(20) not null, ssn varchar(9), superssn varchar(9), bdate date, dno varchar(1), primary key (ssn) , --foreign key (superssn) references employee(ssn) --foreing key (dno) references department(dnumber) ); create table department ( deptname varchar(20) not null, pno varchar(1), dnumber decimal(4), primary key (dnumber) , --foreing key (pno) references projects(pnumber) );
run
|
edit
|
history
|
help
0
aa
h
SQL HW 1 Appline
text
テスト2
QLCB_CSDL
/Users/svetlanakanevskaa/Downloads/ACDB_LIGHT_MS.sql
The relational division
2021.02.25 Lab 4
Loan table