Levels Tought:
Elementary,Middle School,High School,College,University,PHD
Teaching Since: | Apr 2017 |
Last Sign in: | 10 Weeks Ago, 5 Days Ago |
Questions Answered: | 4870 |
Tutorials Posted: | 4863 |
MBA IT, Mater in Science and Technology
Devry
Jul-1996 - Jul-2000
Professor
Devry University
Mar-2010 - Oct-2016
Write and run SQL statements to complete the following:
Â
Part A - DML
Â
Part B - DDL
Â
You are required to submit:
Â
CREATE DATABASEIF NOT EXISTS `assignment5` /*!40100 DEFAULT CHARACTER SETlatin1 COLLATE latin1_bin */;USE `assignment5`;-- MySQL dump 10.13Distrib 5.5.16, for Win32 (x86)---- Host: localhostDatabase: assignment5-- -------------------------------------------------------- Server version 5.5.28/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;/*!40101 SET NAMES utf8 */;/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;/*!40103 SET TIME_ZONE='+00:00' */;/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;---- Table structure for table `customer`--DROP TABLE IF EXISTS `customer`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `customer` (`CUS_CODE` int(11) DEFAULT NULL,`CUS_LNAME` varchar(15) COLLATE latin1_bin DEFAULT NULL,`CUS_FNAME` varchar(15) COLLATE latin1_bin DEFAULT NULL,`CUS_INITIAL` varchar(1) COLLATE latin1_bin DEFAULT NULL,`CUS_AREACODE` varchar(3) COLLATE latin1_bin DEFAULT NULL,`CUS_PHONE` varchar(8) COLLATE latin1_bin DEFAULT NULL,`CUS_BALANCE` float DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `customer`--LOCK TABLES `customer` WRITE;/*!40000 ALTER TABLE `customer` DISABLE KEYS */;INSERT INTO `customer` VALUES (10010,'Ramas','Alfred','A','615','844-2573',0),(10011,'Dunne','Leona','K','713','894-1238',0),(10012,'Smith','Kathy','W','615','894-2285',345.86),(10013,'Olowski','Paul','F','615','894-2180',536.75),(10014,'Orlando','Myron','','615','222-1672',0),(10015,'O\'Brian','Amy','B','713','442-3381',0),(10016,'Brown','James','G','615','297-1228',221.19),(10017,'Williams','George','','615','290-2556',768.93),(10018,'Farriss','Anne','G','713','382-7185',216.55),(10019,'Smith','Olette','K','615','297-3809',0);/*!40000 ALTER TABLE `customer` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `emp`--DROP TABLE IF EXISTS `emp`;/*!40101 SET @saved_cs_client= @@character_set_client */;