m67wNpFY

1DROP DATABASE IF EXISTS `Your_VU_ID`;
2CREATE DATABASE IF NOT EXISTS `Your_VU_ID`;
3USE `Your_VU_ID`;
4
5CREATE TABLE `STUDENT`(
6    `Student_ID` VARCHAR(15) PRIMARY KEY NOT NULL,
7    `Student_Name` VARCHAR(75) NOT NULL,
8    `Father_Name` VARCHAR(75) NOT NULL,
9    `Father_Occupation` VARCHAR(150) NOT NULL,
10    `DoB` DATE NOT NULL,
11    `Student_Address` VARCHAR(120) NOT NULL,
12    `phone_no` VARCHAR(20) NOT NULL,
13    `e-mail` VARCHAR(90) NOT NULL,
14    `Enrolled_Program` VARCHAR(50) NOT NULL
15);
16
17CREATE TABLE `COURSE`(
18    `Course_Code` VARCHAR(7) PRIMARY KEY NOT NULL,
19    `Course_Name` VARCHAR(100) NOT NULL,
20    `Developed_By` VARCHAR(75) NOT NULL,
21    `Credit_Hours` INT UNSIGNED NOT NULL
22);
23
24CREATE TABLE `SEMESTER`(
25    `Semester_ID` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
26    `Semester_Name` VARCHAR(15) NOT NULL
27);
28
29CREATE TABLE `FACULTY`(
30    `Faculty_ID` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
31    `Faculty_Name` VARCHAR(75) NOT NULL,
32    `CNIC` VARCHAR(20) NOT NULL,
33    `Mailing_Address` VARCHAR(120) NOT NULL,
34    `Phone_Number` VARCHAR(20) NOT NULL,
35    `Latest_Degree` VARCHAR(50) NOT NULL,
36    `Designated_Dept` VARCHAR(50) NOT NULL
37);
38
39CREATE TABLE `ENROLLMENT`(
40    `Student_ID` VARCHAR(15) PRIMARY KEY NOT NULL,
41    `Course_ID` VARCHAR(7) NOT NULL,
42    `Semester_ID` INT UNSIGNED NOT NULL,
43    `Faulty_ID` INT UNSIGNED NOT NULL
44);
45
46INSERT INTO `student` (`Student_ID`, `Student_Name`, `Father_Name`, `Father_Occupation`, `DoB`, `Student_Address`, `phone_no`, `e-mail`, `Enrolled_Program`) 
47    VALUES 
48        ('Your_VU_ID', 'Your Name', 'Your Fathers Name', 'Occupation', '2018-08-01', 'Address', 'Number', 'VU Email', 'Your Study Program'),
49        ('Another Entry Your_VU_ID', 'Your Name', 'Your Fathers Name', 'Occupation', '2018-08-01', 'Address', 'Number', 'VU Email', 'Your Study Program');
50
51INSERT INTO `course`(`Course_Code`, `Course_Name`, `Developed_By`, `Credit_Hours`) 
52    VALUES
53        ('CS310','Open Source Web Application Development (PHP, PERL, CGI, Mysql)','Muhammad Umair Mujahid',3),
54        ('CS201','Fundamentals of Algorithms','Muhammad Imran Afzal', 3);
55
56INSERT INTO `semester`(`Semester_ID`, `Semester_Name`)
57    VALUES 
58        (1,'Spring 2018'),
59        (2,'Fall 2018');
60
61INSERT INTO `faculty`(`Faculty_ID`,`Faculty_Name`, `CNIC`, `Mailing_Address`, `Phone_Number`, `Latest_Degree`, `Designated_Dept`) 
62    VALUES 
63        (1,'Muhammad Umair Mujahid','37405-5896544-4','Bank road, Saddar, Rawalpindi', '+92335547','MA Computer Programming','Associate Professor'),
64        (2,'Muhammad Imran Afzal','37405-7836454-1','Blue Area, Islamabad', '+92(42)111880880','Phd.','Associate Professor');
65
66INSERT INTO `enrollment`(`Student_ID`, `Course_ID`, `Semester_ID`, `Faulty_ID`) 
67    VALUES 
68        ('Your_VU_ID','CS310',1,1),
69        ('Your_VU_ID','CS201',2,2);