Question

Create a database called COMPANY using those generated SQL scripts in MySQL database. Show the screenshot of your database and tables in MySQL. To manage your database, you can use the phpmyadmin tool or MySQL Workbench.

Answer 1

Answer:

Create tables in company database:

CREATE DATABASE COMPANY;

USE COMPANY;

CREATE TABLE DEPARTMENT (

dname VARCHAR2(20) NOT NULL ,

dnumber INTEGER NOT NULL ,

mgrssn NUMBER(9) NULL );

CREATE TABLE DEPARTMENT_LOCATIONS (

dnumber INTEGER NOT NULL ,

dlocation VARCHAR2(20) NOT NULL

);