CREATE DATABASE KudlerFF;

CREATE TABLE Department
(
dname varchar(100) NOT NULL,
dnumber int NOT NULL, PRIMARY KEY(dnumber)
)
Insert Into Department( 
dname,
dnumber
)

Values
('Research',1001),
('Accounting',1002),
('Manufacturing',1003),
('Human Resources',1004)

CREATE TABLE Employee 
( 
fname varchar(100) NOT NULL,
lname varchar(100) NOT NULL,
ssn int NOT NULL,
salary int NOT NULL,
superssn int NOT NULL,
dno int NOT NULL,
PRIMARY KEY(ssn),
FOREIGN KEY(dno)references Department(dnumber)
);

Insert Into Employee( 
fname,
lname,
ssn,
salary,
superssn,
dno
)

values
('Eileen','MacAdoo',12345987,65000,12345987,1004),
('Nora','Watkins',45123987,35500,12345987,1001),
('Mary Anne','Lazarro',32145878,60000,12345987,1003),
('Clara','Thompson',03412344,53000,12345987,1003),
('Raymond','Thompson',02932455,22200,12345987,1002),
('Ziggy','Gravellese',45698755,35000,12345987,1002),
('Frankie','Thompson',32425444,17500,12345987,1001),
('Jeanne','Dyer',52455666,43000,12345987,1001),
('Tony','Aero',52432455,20000,12345987,1003),
('Jonathon','Gravellese',98765422,52300,12345987,1003)

CREATE TABLE Project 
(
pname varchar(100) NOT NULL,
pnumber int NOT NULL,
dnum int NOT NULL,
UNIQUE(pname),
PRIMARY KEY(pnumber),
FOREIGN KEY(dnum)references Department(dnumber));

Insert Into Project( 
pname,
pnumber,
dnum
)

values
('projectA',222,1001),
('projectB',333,1003),
('projectC',122,1003),
('projectD',232,1002),
('projectE',244,1004),
('projectF',400,1002)

CREATE TABLE Works_On 
(
essn int NOT NULL,
pno int NOT NULL,
PRIMARY KEY(essn,pno),
FOREIGN KEY(essn)references Employee(ssn),
FOREIGN KEY(pno)references Project(pnumber));

Insert Into Works_On( 
essn,
pno
)
values
(45123987,222),
(45123987,333),
(45123987,244),
(03412344,222),
(03412344,122),
(12345987,400),
(12345987,244),
(02932455,222),
(02932455,400),
(32425444,400),
(32425444,333),
(32425444,244),
(98765422,122),
(98765422,244)

quote:

---

I have received the Command(s) completed successfully message without any database grids showing up in the messages screen. How can I get the database to display?

---

SELECT *
FROM   Employee