-- MySQL dump 10.13  Distrib 5.7.19, for Win64 (x86_64)
--
-- Host: localhost    Database: lab7
-- ------------------------------------------------------
-- Server version	5.7.19-log

/*!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 `professor`
--

DROP TABLE IF EXISTS `professor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `professor` (
  `ProfessorId` int(11) NOT NULL AUTO_INCREMENT,
  `ProfessorProgram` varchar(255) DEFAULT NULL,
  `PhoneNo` int(10) DEFAULT NULL,
  `Age` int(11) DEFAULT NULL,
  `ProfessorName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ProfessorId`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `professor`
--

LOCK TABLES `professor` WRITE;
/*!40000 ALTER TABLE `professor` DISABLE KEYS */;
INSERT INTO `professor` VALUES (1,'Computer Science',123456789,30,'Ted'),(2,'Computer Programmer',987654321,32,'Joey'),(3,'Business Management',456789123,35,'Mina'),(4,'Business Accounting',123789456,31,'Monica'),(5,'Computer Systems',114477985,33,'Jack'),(6,'Computer Technician',654788978,55,'Ellie');
/*!40000 ALTER TABLE `professor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student`
--

DROP TABLE IF EXISTS `student`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student` (
  `﻿StudentNo` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `StudentProgram` varchar(255) NOT NULL,
  `PhoneNo` int(11) NOT NULL,
  `Age` int(11) NOT NULL,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  PRIMARY KEY (`﻿StudentNo`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student`
--

LOCK TABLES `student` WRITE;
/*!40000 ALTER TABLE `student` DISABLE KEYS */;
INSERT INTO `student` VALUES (1,'Computer Science',147258963,42,'Vicky','Khanna'),(2,'Computer Science',147852369,25,'Anita','Arora'),(3,'Computer Programmer',123741852,45,'Natasha','Smith'),(4,'Business Accounting',235478914,33,'Raj','Kapoor'),(5,'Business Management',324718964,21,'Frank','Tribiani'),(6,'Business Accounting',122134567,33,'George','Kapoor'),(7,'Business Management',112366547,35,'Stan','Smith'),(8,'Computer Programmer',998754126,20,'Steve','Smith'),(9,'Business Intelligence',112201245,29,'Amanda','Kapoor'),(10,'Computer Technician',558877414,36,'Joseph','Gong'),(11,'Computer Science',854777896,33,'David','Kapoor'),(12,'Business Management',854777896,21,'Dennis','Smith'),(13,'Business Management',154777896,45,'Robert','Johnson'),(14,'Business Management',254778960,45,'George','Davis'),(15,'Computer Science',347778960,51,'Jeffrey','Williams'),(16,'Computer Programmer',447778960,57,'Eric','Smith'),(17,'Computer Science',554778960,22,'Ron','Davis'),(18,'Computer Science',654778960,25,'Robert','Smith'),(19,'Computer Science',754778960,28,'Jennifer','Wilson'),(20,'Computer Science',854778960,31,'John','Davis'),(21,'Business Accounting',954778960,34,'Alex','Browm'),(22,'Business Intelligence',847778960,37,'Chris','Smith'),(23,'Business Intelligence',154778960,40,'Elen','Watson'),(24,'Business Intelligence',247778960,43,'Jimmy','Cox'),(25,'Business Accounting',154778960,19,'Jared','James'),(26,'Business Accounting',157778960,23,'John','Hughes'),(27,'Computer Technician',541178960,27,'Jack','Davis'),(28,'Photography',416477960,31,'David','Cox'),(29,'Photography',547778960,35,'Dennis','Wilson'),(30,'Photography',154778960,39,'Robert','Kapoor'),(31,'Photography',157778960,43,'George','James'),(32,'Computer Technician',247778960,47,'Jeffrey','Gray'),(33,'Computer Technician',214777960,22,'John','Cox'),(34,'Computer Technician',254778960,20,'Jack','Davis'),(35,'Computer Technician',547778960,25,'Jefferey','Collins'),(36,'Computer Science',247778960,28,'Jack','Gray'),(37,'Business Management',554777890,28,'Alice','Cox'),(38,'Photography',265478960,24,'Lester','James'),(39,'Business Management',254778960,28,'Alex','Gray'),(40,'Photography',257778960,28,'Jack','Smith');
/*!40000 ALTER TABLE `student` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `student_professor`
--

DROP TABLE IF EXISTS `student_professor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `student_professor` (
  `student_professor_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ProfessorId` int(11) NOT NULL,
  `StudentNo` int(11) unsigned NOT NULL,
  PRIMARY KEY (`student_professor_id`),
  KEY `ProfessorId_idx` (`ProfessorId`),
  KEY `StudentNo_idx` (`StudentNo`),
  CONSTRAINT `ProfessorId` FOREIGN KEY (`ProfessorId`) REFERENCES `professor` (`ProfessorId`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `StudentNo` FOREIGN KEY (`StudentNo`) REFERENCES `student` (`﻿StudentNo`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `student_professor`
--

LOCK TABLES `student_professor` WRITE;
/*!40000 ALTER TABLE `student_professor` DISABLE KEYS */;
/*!40000 ALTER TABLE `student_professor` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-04-14 17:16:59
