-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `southern_dbsts`
--

-- --------------------------------------------------------

--
-- Table structure for table `exam_name`
--

CREATE TABLE `exam_name` (
  `ex_id` double NOT NULL,
  `exam_name` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `exam_name`
--

INSERT INTO `exam_name` (`ex_id`, `exam_name`) VALUES
(1, 'Bachelor of Arts with Honours in Islamic History & Culture'),
(2, 'Bachelor of Arts with Honours in Islamic History & Culture'),
(3, 'Master of Arts in Islamic History & Culture'),
(4, 'BSc.  in Computer Science and Information Technology'),
(5, 'Bachelor of Business Administation (BBA)'),
(6, 'Master of Business Administration (MBA)'),
(7, 'BSc. in Computer Science and Engineering'),
(8, 'Executive Master of Business Administration (EMBA) '),
(9, 'BSc. in Computer Science and Engineering'),
(10, 'Master of Arts in English'),
(11, 'Bachelor of Education (B.Ed.)'),
(12, 'BSc. in Computer Science and Engineering (CSE)');

-- --------------------------------------------------------

--
-- Table structure for table `major_name`
--

CREATE TABLE `major_name` (
  `major_id` double NOT NULL,
  `major_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `major_name`
--

INSERT INTO `major_name` (`major_id`, `major_name`) VALUES
(1, 'Islamic History & Culture'),
(2, 'CSIT'),
(3, 'Management'),
(4, 'CSE'),
(5, 'Marketing'),
(6, 'Accounting'),
(7, 'English'),
(8, ' B.Ed');

-- --------------------------------------------------------

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (
  `id` int(100) NOT NULL,
  `stu_id` varchar(100) NOT NULL,
  `department` varchar(100) NOT NULL,
  `c_duration` varchar(100) NOT NULL,
  `first_name` varchar(100) NOT NULL,
  `l_name` varchar(100) NOT NULL,
  `nationality` varchar(100) NOT NULL,
  `religion` varchar(100) NOT NULL,
  `sex` varchar(100) NOT NULL,
  `dobDay` varchar(100) NOT NULL,
  `dobMonth` varchar(100) NOT NULL,
  `dobYear` varchar(100) NOT NULL,
  `cell` varchar(100) NOT NULL,
  `fathersName` varchar(100) NOT NULL,
  `mothersName` varchar(100) NOT NULL,
  `semester` varchar(100) NOT NULL,
  `adDay` varchar(100) NOT NULL,
  `adMonth` varchar(100) NOT NULL,
  `adYear` varchar(100) NOT NULL,
  `session` varchar(100) NOT NULL,
  `session1` varchar(100) NOT NULL,
  `courseFee` varchar(100) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `stu_id`, `department`, `c_duration`, `first_name`, `l_name`, `nationality`, `religion`, `sex`, `dobDay`, `dobMonth`, `dobYear`, `cell`, `fathersName`, `mothersName`, `semester`, `adDay`, `adMonth`, `adYear`, `session`, `session1`, `courseFee`, `image`) VALUES
(1, '1', 'Bachelor of Business Administration - (BBA)', '16 Months', 'rokshana', 'akter', 'Bangladeshi', 'Islam', 'Female', '03', 'January', '2014', '7', 'jhhf', 'dsfdfddw', 'Spring Semester', '14', 'February', '2000', 'Spring', 'ssfd', '11', 'photo/'),
(2, '', '', '1 Years', '', '', 'Bangladeshi', '', 'Male', '', '', '', '', '', '', '', '', '', '', 'Select Semester', '', '', 'photo/'),
(3, '', '', '1 Years', '', '', 'Bangladeshi', '', 'Male', '', '', '', '', '', '', '', '', '', '', 'Select Semester', '', '', 'photo/');

-- --------------------------------------------------------

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

CREATE TABLE `student` (
  `srno` int(11) NOT NULL,
  `roll_no` varchar(100) NOT NULL,
  `Name` varchar(100) NOT NULL,
  `f_name` varchar(100) NOT NULL,
  `m_name` varchar(100) NOT NULL,
  `gender` varchar(20) NOT NULL,
  `program` varchar(100) NOT NULL,
  `major` varchar(30) NOT NULL,
  `session` varchar(100) NOT NULL,
  `cgpa` decimal(10,2) NOT NULL,
  `referance` varchar(100) NOT NULL,
  `date` date NOT NULL,
  `image` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `student` (`srno`, `roll_no`, `Name`, `f_name`, `m_name`, `gender`, `program`, `major`, `session`, `cgpa`, `referance`, `date`, `image`) VALUES
(88, '111-G15-208', 'Rubina Akter', 'Md. Abdul Ali Fakir', 'Rahima Begum', 'Female', 'BBA', 'Marketing', 'Spring-2011', 3.55, 'Najrul', '2017-04-03', 'photo/Arju.JPG'),
(90, '011-G21-009', 'Sabbir Khaleque', 'Abdul Khaleque Kaisar Biswas', 'Sherina Kaisar', 'Male', 'EEE', '----', 'Spring 2011 ( Complete Six Semester Ending Semester Fall 2012 )', 3.54, 'Billah', '2016-06-06', 'photo/received_705512179587886.jpeg'),
(94, '777-G16-22', 'Md. Jahangir Alam', 'Nur Mohammod Ali Akondo', 'Jorina Begum', 'Male', 'EMBA', 'Management', 'Spring 2008 to Fall 2008', 3.50, 'Bokkor', '2016-08-06', 'photo/Jahangir.jpg'),
(95, '111-G4-44', 'Md. Jahangir Alam', 'Nur Mohammod Ali Akondo', 'Jorina Begum', 'Male', 'BBA', 'Management', 'Spring 2004 to Fall 2007', 3.56, 'Bokkor', '2016-08-06', 'photo/Jahangir.jpg'),
(96, '121-G4-48', 'Mafrin Akter', 'Md. Mozaharul Islam', 'Nazma Begum', 'Female', 'B A (Hons) English', 'English', 'Fall 2012 to Sumer 2016', 3.55, 'Sahin Kuri', '2016-10-20', 'photo/Pic.jpg'),
(97, '109-G51-09', 'Md. Zulfikar Sazzad', 'Md. Jwaherul Islam', 'Bilkis Parvin', 'Male', 'Master of Law', 'N/A', 'Spring 2015 to Fall 2015', 3.50, 'Sohag', '2016-12-15', 'photo/New Photo(1).jpg'),
(98, '125-G8-54', 'Md. Tanjimul Islam Sarkar', 'Md. Azizul Islam Sarkar', 'Most. Bilkis Jahan', 'Male', 'BSc in Mechanical Engineering', 'Mechanical Engineering', 'Spring 2008', 3.80, 'ruhul', '2017-01-23', 'photo/Tanjimul.jpg'),
(99, '151-G16-23', 'Md. Abdur Rahman Ansary', 'Md. Abdus Samad', 'Most. Rajia Begum', 'Male', 'EMBA', 'Accounting', 'Spring-2015 To Spring-2016', 3.50, 'Ripa', '2017-02-01', 'photo/Abdul.jpg'),
(100, '125-G81-540', 'Md. Rafiqul Islam', 'Md. Abdul Quddus', 'Mst. Nofiza Begum', 'Male', 'Master of Arts in Islamic History & Culture', 'Islamic History & Culture', 'Spring-2006 To Fall-2007', 3.50, 'Nazrul', '2017-02-04', 'photo/Rafiqul.jpg'),
(101, '153-G59-039', 'Md. Atiqur Rahman', 'Mawlana Mazibur Rahman Zamader', '---', 'Male', 'Bachelor of Arts with Honours in Islamic History & Culture', 'Islamic History & Culture', 'Spring 2000 to Fall 2002', 3.50, 'Smim', '2003-02-10', 'photo/Atiqur Pic.jpg'),
(105, '121-G257-28', 'Mohammad Shofikur Rahman', 'Late Mokhlasur Rahman', 'Sumsun Nahar Begum', 'Male', 'BSc. in Computer Science and Information Technology', 'CSIT', 'Spring 2012 to Fall 2014', 3.50, 'Samim', '2017-03-29', 'photo/Sofiqur.jpg'),
(106, '125-G81-045', 'Md. Atiqur Rahman', 'Mawlana Mazibur Rahman Zamader', '---', 'Male', 'Master of Arts in Islamic History & Culture', 'Islamic History & Culture', 'Spring 2003 to Fall 2003', 4.46, 'Samim', '2004-02-04', 'photo/Atiqur Pic.jpg'),
(107, '111-G1-72', 'Md. Golam Kabir', 'Md. Jabed Ali', 'Mrs. Kohinur Begum', 'Male', 'Bachelor of Business Administation (BBA)', 'Management', 'Spring 2003 To Fall 2006', 3.35, 'National H', '2007-01-30', 'photo/Kobir.jpg'),
(108, '136-G6-45', 'Md. Golam Kabir', 'Md. Jabed Ali', 'Mrs. Kohinur Begum', 'Male', 'Master of Business Administration (MBA)', 'Management', 'Spring 2007 To Fall 2007', 3.55, 'National H', '2008-01-30', 'photo/Kobir.jpg'),
(109, '013-G17-010', 'Sabuz Kumar', 'Gopal Chandra Sarkar', 'Purnima Rani', 'Male', 'BSc. in Computer Science and Engineering', 'CSE', 'Summer 2013 to Spring 2017', 3.55, 'Raju', '2017-06-20', 'photo/Male-Blank-Image.png'),
(110, '811-G3-12', 'Md. Aman Ullah', 'Md. Abdul Karim', 'Ferdausy Begum', 'Male', 'Bachelor of Business Administation (BBA)', 'Marketing', 'Spring 2008 to Fall 2011', 3.10, 'Raju', '2012-01-25', 'photo/Aman.jpg'),
(111, '134-G15-204', 'Md. Abdul Mannan', 'Md. Abdur Rahman', 'Mst. Golajan Begum', 'Male', 'Master of Arts in Bangla', 'Bangla', 'Fall-2003 To Summer-2004', 3.46, 'Shahin', '2004-10-17', 'photo/Mananpic.png'),
(112, '167-G17-29', 'Md. Maruf Hossain', 'Md. Jaherul Islam', 'Bilkis Parvin', 'Male', 'Master of Business Administration (MBA)', 'Marketing', 'Fall 2016 To Summer 2017', 3.55, 'Sohag Ghora', '2017-12-31', 'photo/16[47].jpg'),
(113, '189-G89-12', 'Md. Golam Siddiqur Rahman', 'Md. Golam Murshed', 'Ayesha Siddika', 'Male', 'Executive Master of Business Administration (EMBA)', 'Marketing', 'Spring 2008 To Spring 2009', 3.50, 'Nazrul', '2009-06-15', 'photo/Golam Pic.jpg'),
(115, '117-G1-15', 'MD. RUPAK HOSSAIN', 'MD. SOLAIMAN', 'MST. ROKEYA BEGUM', 'Male', 'Bachelor of Business Administration (BBA)', 'Marketing', 'Summer2011 To Spring 2014', 3.15, 'Raju Darul', '2015-01-10', 'photo/php0Behxl'),
(116, '121-G12-715', 'Rockya Ackther', 'Md. Rafiqul Islam', 'Mst. Rahima Begum', 'Female', 'Bachelor of Business Administation (BBA)', 'Marketing', 'Spring 2012 to Fall 2015', 3.55, 'Ripa', '2016-10-02', 'photo/Rokeya.jpg'),
(117, '012-G16-17', 'S. M. Sihab Uddin Prince', 'Md. Rezaul Karim', 'Anisa Akhter', 'Male', 'BSc. in Electrical & Electronics Engineering', 'Management', 'Fall-2012 To Summer-2016', 3.52, 'Nazrul', '2018-11-29', 'photo/Sihab.jpg'),
(119, '175-G18-32', 'Md. Golam Hafiz', 'Md. Mofazzal Hossain', 'Mst. Meherun Nesa', 'Male', 'Master of Business Administration (MBA)', 'HRM', 'Spring-2019 To Summer-2020', 3.55, 'Ripa', '2020-10-17', 'photo/187-G18-32.jpg'),
(120, '021-G14-24 ', 'Md. Momin Mondol', 'Md. Eyakub Ali Mondol', 'Mst. Morzina Khatun', 'Male', 'Bachelor of Business Administation (BBA)', 'Marketing', 'Spring 2020 To Fall 2023', 3.56, 'Ripa', '2024-02-23', 'photo/021-G14-24 .jpg'),
(121, '019-G16-20', 'FARHANA AFROZE', 'MD. ABDUL BASED', 'MST. REHENA BEGUM', 'Female', 'Bachelor of Business Administation (BBA)', 'Accounting', 'Spring-2016 To Fall 20019', 3.56, 'Ripa', '2020-01-25', 'photo/019-G16-20.jpg'),
(122, '151-G216-18', 'MD. ARIF HOSEN', 'MD. AZIZAR RAHMAN', 'MST. ZIBONNNAHAR', 'Male', 'BSc. in Computer Science and Engineering', 'CSE', 'Spring-2015 To Fall-2018', 3.50, 'Nazrul', '2019-01-25', 'photo/151-G216-18.jpg'),
(123, '321-G216-20', 'Md. Helal Uddin', 'Md. Shamsul Hoque', 'Mahima Khatun', 'Male', 'Master of Arts in English', 'English', 'Spring 2020 To Fall 2021', 3.56, 'Ibrahim Uttora', '2023-09-17', 'photo/321-G216-20.jpg'),
(124, '151-G101-16', 'Md. Shahadat Kabir', 'Md. Husain Ahmed', 'Samarta Begum', 'Male', 'Bachelor of Education (B.Ed.)', 'B.Ed', 'Spring 2015 to Fall 2015', 3.63, 'Sumon', '2016-01-23', 'photo/151-G101-16.jpg'),
(125, '105-G106-05', 'Mohammad Ashraful Haque', 'Mohammad Shahnoor Ali', 'Anwara Begum', 'Male', 'Bachelor of Education (B.Ed.)', 'B.Ed', 'Spring 2005 to Fall 2005', 3.60, 'Sumon', '2006-01-23', 'photo/105-G106-05.jpg'),
(126, '131-G152-16', 'Juhon Proney Anjus', 'Desmond Anjus', 'Ciciliya Anjus', 'Male', 'BSc. in Computer Science and Engineering (CSE)', 'CSE', 'Spring 2013 to Fall 2016', 3.60, 'Sumon', '2017-02-25', 'photo/131-G152-16.jpg'),
(127, '105-G106-10', 'Poritosh Sarkar', 'Khogendronath Sarkar', 'Shanti Lota Sarkar', 'Male', 'Bachelor of Education (B.Ed.)', 'B.Ed', 'Spring-2010 To Fall-2010', 3.60, 'Sumon', '2011-01-23', 'photo/105-G106-10.jpg');

-- --------------------------------------------------------

--
-- Table structure for table `test`
--

CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `roll_no` int(11) NOT NULL,
  `stu_name` varchar(100) NOT NULL,
  `cgpa` float NOT NULL,
  `subject` varchar(100) NOT NULL,
  `image` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `test`
--

INSERT INTO `test` (`id`, `roll_no`, `stu_name`, `cgpa`, `subject`, `image`) VALUES
(1, 1, 'kamal', 2.3, 'EEE', 'photo/Chrysanthemum.jpg'),
(2, 2, 'Rokshana Akhter', 3.74, 'CSE', 'photo/Penguins.jpg'),
(3, 4, 'ahshdgs', 3.74, 'EEE', 'photo/Hydrangeas.jpg');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `exam_name`
--
ALTER TABLE `exam_name`
  ADD PRIMARY KEY (`ex_id`);

--
-- Indexes for table `major_name`
--
ALTER TABLE `major_name`
  ADD PRIMARY KEY (`major_id`);

--
-- Indexes for table `registration`
--
ALTER TABLE `registration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student`
--
ALTER TABLE `student`
  ADD PRIMARY KEY (`srno`);

--
-- Indexes for table `test`
--
ALTER TABLE `test`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `exam_name`
--
ALTER TABLE `exam_name`
  MODIFY `ex_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `major_name`
--
ALTER TABLE `major_name`
  MODIFY `major_id` double NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `registration`
--
ALTER TABLE `registration`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `student`
--
ALTER TABLE `student`
  MODIFY `srno` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;

--
-- AUTO_INCREMENT for table `test`
--
ALTER TABLE `test`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

