Originally Posted by
ScottGem
ohh sorry I tried to solve the HW but I'm pretty sure my answer is not correct take look at and let me know what's wrong with my answer.
thanks
ERD
============
Organization (OrgId, supervisor_id) (1:1)
Supervisors( Supervisor_id, name, experience) (1:1) [[FK references Organization]]
Licensee_Details (Licensee_Key, Licensee_Id, Name, Licensee_Addr_Key,License_Issue_Date, License_Expiry_Date)(1:1)
Licensee_Address (Licensee_adress_key, licensee_key, addr1, addr2, state) (1:1)
Licenses_Issues_Record (License_Issued_Key, Licensee_key, License_Issue_Date) [[REPORT]]
Species_Records (Species_Key, Species_Id, Min_Population, Total_Catch, Year) (1:1)
Govt_Quote_List (Govt_Quote_List_key, Licensee_Key, year, species_key,quantity) (1:1)
fisherman_report_master (fisherman_report_key, licensee_key, expedition_date, weather, boat_name, year) (1:n)
fisherman_report_child(fisherman_report_child_key, fisherman_report_master_key,species_key, tonnage) (n:1)