Submit a Microsoft Word document showing each of your 15 SQLcommands and a screen capture of the results of each command in thedatabase application (i.e Microsoft Access, Oracle, or MySQL,etc.).
Your 15 SQL commands must have Select From Statements includingat least one from the attached document.
MY DATABASE:
CREATE TABLE `company_projects`.`project_budget` (
`project_code` CHAR (5) NULL,
`project_name` VARCHAR(45) NOT NULL,
`project_budget` FLOAT NULL,
PRIMARY KEY (`project_code`)
);
CREATE TABLE `company_projects`.`project_budget` (
`project_code` CHAR (5) NULL,
`project_name` VARCHAR(45) NOT NULL,
`project_budget` FLOAT NULL,
PRIMARY KEY (`project_code`)
);
CREATE TABLE `company_projects`.`employee` (
`employee_id` CHAR(4) NOT NULL,
`employee_name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`employee_id`)
);
CREATE TABLE `company_projects`.`deparment` (
`department_id` CHAR (3) NOT NULL,
`deparment_name` VARCHAR(45) NOT NULL,
PRIMARY KEY (`department_id`)
);
CREATE TABLE `company_projects`.`hourly_rate` (
`deparment_id` CHAR(3),
`hourly_rate` DATETIME NOT NULL,
PRIMARY KEY (`deparment_id`)
);
- Using The Same Scenario And The Database You Created In Practice Exercise 4 Write At Least 15 Sql Queries On Your Popul 1 (96.14 KiB) Viewed 11 times