Question

Using DDL (data definition language) statement(create table statement) to define each relation schema, i.e., giving the create table statement for each relation schema with the definition of primary key in each table.

Each employee has a name, social security number (primary key), gender, age, and salary. Each employee works for only one department, and there are more

than one employee working in a department. Each department has a department name, a department number (pk), and a department location.

Answer 1

CREATE table department(dname varchar(255),dno int,dloc varchar(255),PRIMARY KEY(dno));

CREATE table emp(name varchar(255),social_security_no int(255),gender char,age int,salary int,PRIMARY KEY(social_security_no),dno int,FOREIGN KEY(dno) REFERENCES department(dno));