Question: Execute the following SQL and successfully create two tables, employee and department. # SET FOREIGN_KEY_CHECKS=1; # # DROP DATABASE IF EXISTS `COMPANY`; # CREATE DATABASE

Execute the following SQL and successfully create two tables, employee and department.

# SET FOREIGN_KEY_CHECKS=1; # # DROP DATABASE IF EXISTS `COMPANY`; # CREATE DATABASE `COMPANY`; # USE `COMPANY`;

# TABLE: `COMPANY`.`employee` CREATE TABLE `employee` ( `Fname` varchar(15) NOT NULL, `Minit` char(1) DEFAULT NULL, `Lname` varchar(15) NOT NULL, `SSN` char(9) NOT NULL, `bdate` date DEFAULT NULL, `Address` varchar(30) DEFAULT NULL, `sex` varchar(2) DEFAULT NULL, `Salary` decimal(10,2) DEFAULT NULL, `Super_ssn` char(9) DEFAULT NULL, `Dno` int(11) NOT NULL, PRIMARY KEY (`SSN`), CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`Dno`) REFERENCES `department` (`dnumber`) ); # TABLE: `COMPANY`.`department` CREATE TABLE `department` ( `dname` varchar(15) NOT NULL, `dnumber` int(11) NOT NULL, `mgr_ssn` char(9) NOT NULL, `mgr_start_date` date DEFAULT NULL, PRIMARY KEY (`dnumber`), UNIQUE KEY `dname` (`dname`), KEY `mgr_ssn` (`mgr_ssn`), CONSTRAINT `department_ibfk_1` FOREIGN KEY (`mgr_ssn`) REFERENCES `employee` (`SSN`) ) ;

#drop table department; #drop table employee;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q. SQL HOSPITAL Database Implementation 1.Do the following operation from given hospital schema hospital data. a.SQL Update Operations of the Hospital database by creating hospital data. b.Simple SQL...

Answer this question using a subquery if needed, thanks! SQL statement must prompt table in my SQL workbench 2. Retrieve the name and salary of the two highest salaried employees for the department...

Consider the following relational schema. An employee can work in more than one department; also, the percentTime field of the Works relations shows the percentage of time that a given employee works...

Answer this question using subqueries if needed. Table must prompt in my SQL workbench, thanks! 3. Retrieve the name of employees, whose salary is higher than the average of all employees, and their...

DROP DATABASE IF EXISTS XYZ; CREATE DATABASE XYZ; USE XYZ; CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY DECIMAL(10,2),...

Please complete the following setup tasks before attempting the assignment Connect to MySQL through the command line prompt to DO THIS ASSIGNMENT Next, please answer the questions: 1) How many total...

PLEASE ANSWER THE QUESTIONS IN ODER DROP DATABASE IF EXISTS XYZ; CREATE DATABASE XYZ; USE XYZ; CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME...

DROP DATABASE IF EXISTS XYZ; CREATE DATABASE XYZ; USE XYZ; CREATE TABLE Worker ( WORKER_ID INT NOT NULL PRIMARY KEY AUTO_INCREMENT, FIRST_NAME CHAR(25), LAST_NAME CHAR(25), SALARY DECIMAL(10,2),...

Question 3. The attached text file XYX_LTD is an executable SQL script containing workers informations at XYZ company ltd. Execute the script on my SQL workbench and use it to answer the following...

The attached text file XYX_LTD is an executable SQL script containing workers informations at XYZ company ltd. Execute the script on my SQL workbench and use it to answer the following questions: (20...

Based on the figures in practice problems 17 and 18, how much money did the shareholders actually invest in the firm (i.e., what is the value of the capital stock)?

After finishing your Bachelor of Accounting, you joined a multinational enterprise in 2007. During the last thirteen years in a multinational enterprise, you have performed various roles, including:...

9. During the 1970s, we experienced . (LO8) a) high infl ation and high unemployment b) low infl ation and low unemployment c) high infl ation and low unemployment d) low infl ation and high...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

LO2 Analyze the differences between employee benefits in the United States and those in other countries.

3. A reduction in the use of commissions for salespeople has occurred because more sales are taking place online with limited interaction with salespeople. This has changed the nature of pay given to...

LO1 Define a benefit and identify four strategic benefit considerations.