1. DATABASE PLEASE TYPE ANSWER Write the DDL for each of the 6 tables above, inc

Question

1. DATABASE PLEASE TYPE ANSWER

Write the DDL for each of the 6 tables above, including all constraints

salaries emp-no INT (10) salary INT(11 from date DATE to date DATE Indexes titles emp no INT(10 title VARCHAR(50) from date DATE to date DATE Indexes employees emp-no INT(10) LH birth date DATE first name VARCHAR(14) last name VARCHAR(16) gender ENUM (M', F) hire date DATE Indexes dept manager dept no CHAR(40 emp no INT(10) from date DATE to date DATE Indexes dept emp emp no INT(10) dept no CHAR(4) from date DATE to date DATE Indexes dept no CHAR(4) dept name VARCHAR(40) Indexes

Explanation / Answer

1.CREATE TABLE salaries(emp_no int(10),salary int(11),form_date date,to_data date);

2.create table titles(emp_no int(10),title varchar(50),from_date date,to_date date);

3.create table departments(dept_no char(4),dept_name varchar(40));

4.create table dept_emp(emp_no int(10),dept_no char(4),from_date date,to_date date);

5.create table dept_manager(dept_no char(4),emp_no int(10),from_date date,to_date date);

6.create table employees(emp_no int(10),birth_date date,first_name varchar(14),last_name varchar(16),gender enum('M','F'),hire_date date);

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.