Релациска шема
Primary - oznacuva primaren kluc
atribute – oznacuva zadolzitelen atribut
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)
#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 скрипта за бришење на табелите и креирање на табелите
DML скрипта за полнење на табелите со податоци
Релациски дијаграм изваден од DBeaver
Attachments (11)
- kreiranje.sql (3.9 KB ) - added by 4 months ago.
- polnenje.sql (4.1 KB ) - added by 4 months ago.
- shema_updated.jpg (113.2 KB ) - added by 4 months ago.
- DBeaver_ER.jpg (122.2 KB ) - added by 3 weeks ago.
- polnenje_updated.sql (4.2 KB ) - added by 3 weeks ago.
- kreiranje_updated.sql (4.1 KB ) - added by 3 weeks ago.
- DBeaver_ER_Modified.jpg (124.3 KB ) - added by 3 weeks ago.
- DBeaver_ER_NEWEST.jpg (117.8 KB ) - added by 11 days ago.
- kreiranje_v3.sql (4.0 KB ) - added by 11 days ago.
- polnenje_v3.sql (4.2 KB ) - added by 11 days ago.
- DBEAVER_ER_FINAL.jpg (116.4 KB ) - added by 7 days ago.
Download all attachments as: .zip