Practice Creating an Attendance System in a Boarding School

1. Create ERD

   

2. Create all table

   

   

   

3. Create Index

   

4. Insert data into tables

   

   

   

   

5. crud operations on tables

   1. In table class

      1. Create

         

         

      2. Read

         

      3. Update

         

      4. Delete

         

         

   2. In table teacher

      1. Create

         

      2. Read

         

      3. Update

         

      4. Delete

         

   3. In table student

      1. Create

         

      2. Update

         

      3. Read

         

      4. Delete

         

   4. In table schedule

      1. Create

         

      2. Update & Read

         

      3. Delete

         

   5. In table attendance

      1. Create

         

      2. Update & Read

         

      3. Delete

         

6. Recap

   1. Status

      1. per day

         

      2. per month

         

   2. Late

      

7. Constraint test

   1. By student_id

      

      

   2. By FK

      

   3. UNIQUE( date, schedule, student ) in table attendance

      

      

   4. Test check in column late_minutes in attendance table

      

Oke See You next time gusy