Build ERD & Database Without the Headache: Dormitory Exit Permit Case Study

Today i want to create Database and ERD with case study is an exit permission for student in Dormitories

1. Go to gemini and write like this

   

2. if you already understand, go to draw.io, for create ERD

   

3. create 3 list, for teacher, student, and licensing with type data column

   

4. finally ERD

   

5. go to terminal, and login for start our project

   

6. create table student, teacher and exitpermits

   

   

   

   FOREIGN KEY is

7. add values to tables

   

8. and the finally step is displaying the data

   

   in the table there are two identical clolumns, one is student and other is teacher

BONUSES

Behind The Scene & ERRORS.

• here I made mistake, instead of creating table i creating a database

  

• this error is due to my typos, primary key can’t written in front type data column

  

• FOREIGN KEY should unique or type data is PRIMARY KEY

  

  

  

  

  EENNNNNDDDDDDD!!!!!!, follow me for more tutorial about database.

  I 💖 Error.