Make at least 16 different samplehighlight = PK, bold = FK, can be both

using DB Browser (SQLite)

EMPLOYEE

e_id e_wage e_hiredate

MANAGER

m_id m_fname m_lname m_dept m_wage m_hiredate

ONLINE STAFF

e_id o_fname o_lname o_dept url

STAFF

e_id s_fname s_lname s_dept m_id

WEBSITE

url sitename date_updated

MERHANDISE

i_num dept_location m_stock m_price m_name

TOPS

i_num t_type t_size t_color t_season

BOTTOMS

i_num b_type b_size b_color b_season

ACCESSORIES

i_num a_type a_size a_color a_season

STOCKS

e_id i_num

CREATE TABLE employee (

e_ID number(1) NOT NULL,

e_wage number (4, 2) NOT NULL,

e_hiredate date,

CONSTRAINT e_PK PRIMARY KEY(e_ID)

);

CREATE TABLE manager (

m_ID number(1) NOT NULL,

m_fname varchar (6) NOT NULL,

m_lname varchar (6) NOT NULL,

m_dept number (1) NOT NULL,

m_wage number (4, 2) NOT NULL,

m_hiredate date NOT NULL,

CONSTRAINT m_PK PRIMARY KEY(m_ID)

);

CREATE TABLE website (

url varchar(25) NOT NULL,

sitename varchar(15) NOT NULL,

date_updated date NOT NULL,

CONSTRAINT w_PK PRIMARY KEY (url)

);

CREATE TABLE online_staff (

e_ID number(1) NOT NULL,

o_fname varchar (6) NOT NULL,

o_lname varchar (6) NOT NULL,

o_dept number (1) NOT NULL,

url varchar (25) NOT NULL,

CONSTRAINT os_PK PRIMARY KEY(e_ID),

CONSTRAINT os_FK FOREIGN KEY(e_ID) REFERENCES employee (e_id),

CONSTRAINT os_2FK FOREIGN KEY(url) REFERENCES website (url)

);

CREATE TABLE staff (

e_ID number (1) NOT NULL,

s_fname varchar (6) NOT NULL,

s_lname varchar (6) NOT NULL,

s_dept number (1) NOT NULL,

man_ID number (1) NOT NULL,

CONSTRAINT s_PK PRIMARY KEY(e_ID),

CONSTRAINT s_FK FOREIGN KEY(e_ID) REFERENCES employee (e_ID),

CONSTRAINT s2_FK FOREIGN KEY(man_ID) REFERENCES manager (m_ID)

);

CREATE TABLE merchandise (

i_num number (2),

dept_location number (1),

m_stock number (3),

m_price number (5, 2),

m_name varchar (15),

CONSTRAINT i_PK PRIMARY KEY(i_num)

);

CREATE TABLE tops (

i_num number (2) NOT NULL,

t_type varchar (10) NOT NULL,

t_size varchar (3) NOT NULL,

t_color varchar (10) NOT NULL,

t_season varchar (6) NOT NULL,

CONSTRAINT t_PK PRIMARY KEY (i_num),

CONSTRAINT t_FK FOREIGN KEY (i_num) REFERENCES merchandise (i_num)

);

CREATE TABLE bottoms (

i_num number (2) NOT NULL,

b_type varchar (10) NOT NULL,

b_size varchar (3) NOT NULL,

b_color varchar (10) NOT NULL,

b_season varchar (6) NOT NULL,

CONSTRAINT b_PK PRIMARY KEY (i_num),

CONSTRAINT b_FK FOREIGN KEY (i_num) REFERENCES merchandise (i_num)

);

CREATE TABLE accessories (

i_num number (2) NOT NULL,

a_type varchar (10) NOT NULL,

a_size varchar (3) NOT NULL,

a_color varchar (10) NOT NULL,

a_season varchar (6) NOT NULL,

CONSTRAINT a_PK PRIMARY KEY (i_num),

CONSTRAINT a_FK FOREIGN KEY (i_num) REFERENCES merchandise (i_num)

);

CREATE TABLE stocks (

e_ID number (1) NOT NULL,

i_num number (2) NOT NULL,

CONSTRAINT st_PK PRIMARY KEY (e_ID, i_num),

CONSTRAINT st_FK FOREIGN KEY (e_ID) REFERENCES employee (e_ID),

CONSTRAINT st2_FK FOREIGN KEY (i_num) REFERENCES merchandise (i_num)

);

/* employee table */

INSERT INTO employee VALUES (1, 30.42, '5-JAN-2023');

INSERT INTO employee VALUES (2, 12.34, '6-FEB-2022');

INSERT INTO employee VALUES (3, 48.66, '7-MAR-2016');

INSERT INTO employee VALUES (4, 25.89, '8-DEC-2018');

INSERT INTO employee VALUES (5, 72.22, '9-NOV-2020');

INSERT INTO employee VALUES (6, 30.42, '5-JAN-2023');

INSERT INTO employee VALUES (7, 12.34, '6-FEB-2022');

INSERT INTO employee VALUES (8, 48.66, '7-MAR-2016');

INSERT INTO employee VALUES (9, 25.89, '8-DEC-2018');

INSERT INTO employee VALUES (0, 72.22, '9-NOV-2020');

/* manager table */

INSERT INTO manager VALUES (1, 'joe', 'keep', 2, 88.36, '10-APR-2010');

INSERT INTO manager VALUES (2, 'alex', 'germ', 1, 45.67, '10-MAY-2013');

INSERT INTO manager VALUES (3, 'bob', 'boom', 5, 76.54, '1-JUN-2006');

INSERT INTO manager VALUES (4, 'jen', 'front', 3, 65.56, '6-JUL-2015');

INSERT INTO manager VALUES (5, 'bill', 'sand', 4, 56.56, '7-AUG-2012');

/* website table */

INSERT INTO website VALUES ('www.website.com', 'website1', '25-JAN-2022');

INSERT INTO website VALUES ('www.ustore.com', 'official', '15-FEB-2022');

INSERT INTO website VALUES ('www.ustore.org', 'official2', '5-MAR-2022');

INSERT INTO website VALUES ('www.fakesite.com', 'scam1', '15-FEB-2022');

INSERT INTO website VALUES ('www.fakesite.org', 'scam2', '25-MAR-2022');

/* online staff table */

INSERT INTO online_staff VALUES (5, 'calvin', 'oshman', 4, 'www.ustore.com');

INSERT INTO online_staff VALUES (4, 'pat', 'globe', 3, 'www.ustore.com');

INSERT INTO online_staff VALUES (3, 'dog', 'mertin', 5, 'www.ustore.org');

INSERT INTO online_staff VALUES (2, 'john', 'farms', 2, 'www.ustore.com');

INSERT INTO online_staff VALUES (1, 'caleb', 'betts', 1, 'www.ustore.org');

/* staff table */

INSERT INTO staff VALUES (6, 'joe', 'goldy', 1, 1);

INSERT INTO staff VALUES (7, 'blend', 'carrot', 1, 2);

INSERT INTO staff VALUES (8, 'jeff', 'bezos', 3, 3);

INSERT INTO staff VALUES (9, 'real', 'name', 4, 4);

INSERT INTO staff VALUES (0, 'flint', 'steel', 2, 5);

/* merchandise table */

INSERT INTO merchandise VALUES (1, 1, 100, 123.45, 'wristwatch');

INSERT INTO merchandise VALUES (2, 2, 37, 22.22, 'baseballCap');

INSERT INTO merchandise VALUES (3, 2, 22, 85.33, 'classRing');

INSERT INTO merchandise VALUES (4, 3, 69, 25.99, 'athleticPants');

INSERT INTO merchandise VALUES (5, 4, 105, 25.01, 'muscleShirt');

INSERT INTO merchandise VALUES (6, 5, 32, 30.99, 'sweatpants');

INSERT INTO merchandise VALUES (7, 5, 15, 35.64, 'sweatshirt');

INSERT INTO merchandise VALUES (8, 5, 77, 17.65, 'vNeck');

INSERT INTO merchandise VALUES (9, 4, 8, 12.65, 'tanktop');

INSERT INTO merchandise VALUES (10, 4, 40, 19.99, 'crewneck');

INSERT INTO merchandise VALUES (11, 2, 35, 24.99, 'jeans');

INSERT INTO merchandise VALUES (12, 3, 22, 12.34, 'joggers');

INSERT INTO merchandise VALUES (13, 1, 13, 32.32, 'climbingPants');

INSERT INTO merchandise VALUES (14, 1, 4, 62.84, 'helmet');

INSERT INTO merchandise VALUES (15, 1, 15, 20.99, 'sunglasses');

/* tops table */

INSERT INTO tops VALUES (5, 'shortSleeve', 'M', 'green', 'spring');

INSERT INTO tops VALUES (7, 'longSleeve', 'S', 'blue', 'fall');

INSERT INTO tops VALUES (8, 'shortSleeve', 'M', 'green', 'summer');

INSERT INTO tops VALUES (9, 'shortSleeve', 'XL', 'yellow', 'summer');

INSERT INTO tops VALUES (10, 'longSleeve', 'L', 'red', 'winter');

/* bottoms table */

INSERT INTO bottoms VALUES (4, 'short', 'M', 'red', 'fall');

INSERT INTO bottoms VALUES (6, 'long', 'L', 'red', 'winter');

INSERT INTO bottoms VALUES (11, 'long', 'L', 'blue', 'spring');

INSERT INTO bottoms VALUES (12, 'long', 'XL', 'green', 'fall');

INSERT INTO bottoms VALUES (13, 'short', 'S', 'purple', 'summer');

/* accessory table */

INSERT INTO accessories VALUES (1, 'watch', 'M', 'gold', 'any');

INSERT INTO accessories VALUES (2, 'hat', 'L', 'black', 'summer');

INSERT INTO accessories VALUES (3, 'ring', 'S', 'gold', 'any');

INSERT INTO accessories VALUES (14, 'helmet', 'L', 'black', 'spring');

INSERT INTO accessories VALUES (15, 'glasses', 'M', 'black', 'summer');

/* stock table */

INSERT INTO stocks VALUES (0, 5);

INSERT INTO stocks VALUES (8, 2);

INSERT INTO stocks VALUES (9, 9);

INSERT INTO stocks VALUES (0, 4);

INSERT INTO stocks VALUES (3, 1);

INSERT INTO stocks VALUES (4, 3);

INSERT INTO stocks VALUES (3, 6);

INSERT INTO stocks VALUES (5, 8);

INSERT INTO stocks VALUES (6, 7); queries. Please utilize many tables to create SQL code.