Forensic ERD Version 3 Zvulon Police Forensic Department

Forensic ERD Version 3 מעבדה בעיבוד נתונים Zvulon Police Forensic Department Entity Relationships Diagram B Support staff D Excellency List Person ID (PK) Month (PK), Year (PK) Is In D Vacation Gets Vacation Code (PK) With Case B Case Number (PK) Works on B Employee ID (PK) CEP Name (PK) Goes to Legend Has Testimony B Course D Course Name (PK) Serial Number (PK) Has D Training Goes to Discovery Entity Basic Entity Dependant Entity Primary Key Foreign Primary Key Relation B Serial Number (PK) Equipment Item Code(PK) B 1: 1 1: N N: M Self Relationship Mandatory Optional Entity prime_key(PK) B D PK FPK Relation

Forensic DSD Version 1 Support_staff_Tbl B Zvulon Police Forensic Department Data Structures Diagram Person_ID_Fld (PK) First_name_Fld Last_name_Fld Phone_Fld address_Fld Occupation_Fld B Case_Tbl Support_For_Cases_Tbl Employee_Courses_Tbl Case_Numbe_Fld (PK) Date_Fld Location_Fld Type_Fld Findings(Y/N)_Fld Employee_ID_Fld A Case_Number_Fld(FK) Person_ID_Fld (FK) A Course_Name_Fld (FK) Employee_ID_Fld (FK) Date_Fld Employee_Tbl B B A Training_Tbl Training_Name_Fld (FK) Employee_ID_Fld (FK) Date_Fld Employee_ID_Fld (PK) First_name_Fld Last_name_Fld Phone_Fld address_Fld Rank_Fld Serial_Numbe_Fld (PK) Case_Number_Fld Sentence_Date_Fld Reason_Fld Discovery_Tbl B A B Item_Code_Fld (PK) Item_Name_Fld Quantity_Fld Item_Code_Fld (FK) Employee_ID_Fld (FK) Serial_Numbe_Fld (PK) Case_Number_Fld Status_Fld Legend Xxx_Tbl B Excellency_List_Tbl Month_Fld (PK) Year_Fld (PK) Employee_ID_Fld Reason_Fld D Employee_Vacations_Tbl Vacation_Code_Fld (FK) Employee_ID_Fld (FK) Duration_Fld Location_Fld A D Training_Name_Fld (PK) Duration_Fld Equipment_Tbl Employee_Equipment_Tbl D Course_Name_Fld (PK) Duration_Fld Employee_Training_Tbl Testimony_Tbl Course_Tbl Vacation_Code_Fld (PK) Vacation_Type_Fld D D A PK FK PFK Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M

Forensic DSD Version 1 Support_staff_Tbl Person_ID_Fld (PK) First_name_Fld Last_name_Fld Phone_Fld address_Fld Occupation_Fld B Zvulon Police Forensic Department Data Structures Diagram 1 Support_For_Cases_Tbl A Case_Number_Fld(FK) Person_ID_Fld (FK) 3 Testimony_Tbl Serial_Numbe_Fld (PK) Case_Number_Fld Sentence_Date_Fld Reason_Fld Discovery_Tbl Serial_Numbe_Fld (PK) Case_Number_Fld Status_Fld B Case_Tbl Case_Numbe_Fld (PK) Date_Fld Location_Fld Type_Fld Findings(Y/N)_Fld Employee_ID_Fld Employee_Courses_Tbl Course_Name_Fld (FK) Employee_ID_Fld (FK) Date_Fld 2 A 2 Employee_Training_Tbl Employee_Tbl B Employee_ID_Fld (PK) First_name_Fld Last_name_Fld Phone_Fld address_Fld Rank_Fld 3 B Training_Name_Fld (FK) Employee_ID_Fld (FK) Date_Fld 1 Employee_Equipment_Tbl A Item_Code_Fld (FK) Employee_ID_Fld (FK) 2 Course_Tbl D Course_Name_Fld (PK) Duration_Fld 1 A 2 Training_Tbl D Training_Name_Fld (PK) Duration_Fld 1 Equipment_Tbl B Item_Code_Fld (PK) Item_Name_Fld Quantity_Fld 1 Legend Xxx_Tbl B Excellency_List_Tbl Month_Fld (PK) Year_Fld (PK) Employee_ID_Fld Reason_Fld D 2 Employee_Vacations_Tbl Vacation_Code_Fld (FK) Employee_ID_Fld (FK) Duration_Fld Location_Fld A 2 Vacation_Tbl D Vacation_Code_Fld (PK) Vacation_Type_Fld 1 D A PK FK PFK Table Basic table Dependant Table Association Table Primary Key Foreign Key Primary Foreign Key 1: 1 1: N N: M