== Релациска шема

'''__Primary__''' - oznacuva primaren kluc [[br]]
__atribute__ – oznacuva zadolzitelen atribut [[br]][[br]]
 
''Prisoner''('''__prisoner_id__''',__date_of_birth__,sentence_start_date, __first_name__,__last_name__,__gender__,crime_details,__age__, cell_id*, activity_name#)

      *cell_id referencira od cells(cell_id) [[br]]
      #activity_name referencira od InmateActivities(activity_name)

''Cells''('''__cell_id'''__, __cell_type__, security_level, capacity, __cell_number__)

''Prison_staff''('''__staff_id*'''__)

      *staff_id referencira od staff(staff_id)

  

''Prison_incidents''('''__incident_id'''__, __incident_date__, __incident_details__)


''Medical_record''('''__prisoner_id*'''__, __medications__, __health_condition__, __alergies__)

      *prisoner_id referencira od Prisoners(prisoner_id)

''Visits''('''__visit_id'''__, __visit_time__, __visit_date__, __check_in_time__, __check_out_time__, __prisoner_id*__)

      *prisoner_id referencira od Prisoners(prisoner_id)

''Approved_visitor''('''__visitor_id'''__, __contact_number__, __relationship_to_prisoner__, __d_staff_id*__,__first_name__, __last_name__) 
     
      *staff_id referencira od Prison_director(staff_id)

''Prison_director''('''__staff_id*'''__)

      *staff_id referencira od Staff(staff_id)

''Kitchen_staff''('''__staff_id*'''__)

      *staff_id referencira od Staff(staff_id)

''Staff''('''__staff_id'''__, __first_name__, __last_name__, __position_staff__)

''Activities''('''__activities_name'''__, activity_type, activity_location, working_hours)

''Inmate_activities''('''__activity_name*'''__, start_time, end_time, working_days)

''Punishment''('''__punishment_id'''__, __start_date__, end_date, __punishment_type__)

''Involved_in''('''__prisoner_id*'''__, '''__incident_id#'''__)
      
      *prisoner_id referencira od Prisoner(prisoner_id)

      #incident_id referencira od Prison_incidents(incident_id)

''Witnessed''('''__incident_id*'''__,'''__p_staff_id#'''__)
      *incident_id referencira od Prison_incidents(incident_id)
 
      #staff_id referencira od Prison_staff(staff_id)

''Is_given''('''__prisoner_id*'''__,'''__punishment_id#'''__)
      *prisoner_id referencira od Prisoner(prisoner_id)

      #punishment_id referencira od Punishment(punishment_id)

''Has_taken_part''('''__visit_id*'''__,'''__visitor_id#'''__)
      *visit_id referencira od Visits(visit_id)
    
      #visitor_id referencira od Approved_visitor(visitor_id)

''Guarded_by''('''__cell_id*'''__,'''__p_staff_id#'''__, __shift__)
      *cell_id referencira od Cells(cell_id)
    
      #p_staff_id referencira od Prison_Staff(staff_id)

== DDL скрипта за бришење на табелите и креирање на табелите

[attachment:kreiranje_v3.sql​]

== DML скрипта за полнење на табелите со податоци 

[attachment:polnenje_v3.sql​]

== Релациски дијаграм изваден од DBeaver

[[Image(DBEAVER_ER_FINAL.jpg)]]