Group 2

CREATE TABLE `tbl_attendance` (
  `Attendance_Days` int(11) NOT NULL,
  `Student_ID` int(11) NOT NULL,
  `Attendance_date` varchar(20) DEFAULT NULL,
  `Time_in` varchar(30) DEFAULT NULL,
  `Time_out` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `tbl_attendance` (`Attendance_Days`, `Student_ID`, `Attendance_date`, `Time_in`, `Time_out`) VALUES
(1, 1, '[July 15, 2023]', '[7:32]', '[5:00]'),
(2, 2, '[July 15, 2023]', '[7:32]', '[5:00]'),
(3, 3, '[July 15, 2023]', '[7:32]', '[5:00]'),
(4, 4, '[July 15, 2023]', '[7:32]', '[5:00]'),
(5, 5, '[July 15, 2023]', '[7:32]', '[5:00]'),
(6, 1, '[July 16 2023]', '[7:47]', '[5:00]'),
(7, 2, '[July 16 2023]', '[7:47]', '[5:00]'),
(8, 3, '[July 16 2023]', '[7:47]', '[5:00]'),
(9, 4, '[July 16 2023]', '[7:47]', '[5:00]'),
(10, 1, '[July 17 2023]', '[7:55]', '[5:00]'),
(11, 2, '[July 17 2023]', '[7:55]', '[5:00]'),
(12, 3, '[July 17 2023]', '[7:55]', '[5:00]'),
(13, 4, '[July 17 2023]', '[7:52]', '[5:00]'),
(14, 5, '[July 17 2023]', '[7:55]', '[5:00]'),
(15, 1, '[July 18, 2023]', '[7:32]', '[5:00]'),
(16, 2, '[July 18, 2023]', '[7:32]', '[5:00]'),
(17, 3, '[July 18, 2023]', '[7:32]', '[5:00]'),
(19, 4, '[July 18,2023]', '[7:32]', '[5:00]');

CREATE TABLE `tbl_studentlist` (
  `Student_ID` int(11) NOT NULL,
  `First_name` varchar(20) DEFAULT NULL,
  `Last_name` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_studentlist`
--

INSERT INTO `tbl_studentlist` (`Student_ID`, `First_name`, `Last_name`) VALUES
(1, 'Emilene Joy', 'Ypulong'),
(2, 'Reah Rica Marie', 'Padroncillo'),
(3, 'Ysieh Joy ', 'Morillo'),
(4, 'Gina', 'Cordero'),
(5, 'Beltran', 'Cadete');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_attendance`
--
ALTER TABLE `tbl_attendance`
  ADD PRIMARY KEY (`Attendance_Days`);

--
-- Indexes for table `tbl_studentlist`
--
ALTER TABLE `tbl_studentlist`
  ADD PRIMARY KEY (`Student_ID`);