Working with Databases in Java - Beginning Java Programming: The Object-Oriented Approach - page 314

REFERENCES 'EmployeeSchema'.'Department' ('DNR')
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB

CREATE TABLE IF NOT EXISTS 'EmployeeSchema'.'Department' (
'DNR' INT NOT NULL,
'DName' VARCHAR(45) NULL,
'DAddress' VARCHAR(45) NULL,
PRIMARY KEY ('DNR'))
ENGINE = InnoDB

7. Use an SQL insert statement to add the following tuples to the Department table:

insert into employeeschema.department
values
(1, 'ICT', 'Brussels'),
(2, 'Marketing', 'New York'),
(3, 'Finance', 'Singapore'),
(4, 'Accounting', 'Sydney');

8.

Use an SQL insert statement to add the following tuples to the Employee table:
insert into employeeschema.employee
values
(1, 'Bart Baesens', 'Male', 1),
(2, 'Aimée Backiel', 'Female', 1),
(3, 'Seppe vanden Broucke', 'Male', 1),
(4, 'Michael Jackson', 'Male', 2),
(5, 'Sarah Adams', 'Female', 3);

9.

Your MySQL screen should now look like Figure 9-7.

figure 9-7