From book "Data Modeling and Database Design (2nd Edition)"

The answer for problem 12 is not there.

12The purpose of this exercise is to give you an opportunity to create the tables for Bearcat . 12. Incorporated. The tables themselves are based on the relations that appear in the following figure . Database creation in , Emp , Emp , , , EMPLOYEE (Emp nameEmp mindname, Emp nametagemptaEmpomp onEmp address, Emp salary. Emp_p_rame. Emp gender. Emp datehired, Emp_ta, Empetin) , EMPLOYEE Emp empstian, Emp emp_ein C EMPLOYEE (Emp , Emp.com) or EMPLOYEE (Emp Pl_name) C PLANT.PI name 2 (Pbudget Plname, PL empta, Pompetin, PLmgrstdte) PLANT P =. , PLANT IP PL emp oils, P1_ampolin) C EMPLOYEE (Empola, Emp _ein ) L3: BUILDING Bld building, Bld Dl 4) ( 4 BUILDING. (Bld plP) S PLANT.Plpi) L4: PROJECT Paname, Plocation, Pip#, PHPlp) PROJECT (PO pipt) C PLANTPlpf) or L5: ASSIGNMENT ( Asa an D# . Asg emo ofta , Asa emp eth, Asghs) # ASSIGNMENT. (Asg pipt ) C PROJECT.(Pn p) ASSIGNMENT(Asg cmp., AsgcmptinC EMPLOYEEEnp_eaEmpetin) L6: DEPENDENT (Dep_Depbrthdte, sex, _Dee name Dep rehow, Dee emp sta. Dep emo eth) DEPENDENTDep_emp_eta, Dep_cmpetin, S EMPLOYEE (Empeta, Emp on L7: BCU AccoUNT (Bcu_dep_name, Bau_dop_relhow, Bou depempeka, Bau_ep empetim, Bau acct type, Bau acct, Barbalance, Bkamp sta Bcu_emp_etin) BCUACCOUNT (Bau_empeka, Bauemp_etin) C EMPLOYEE (Emp of , Empolin) or BCU ACCOUNT (Beu dep_nameBeu deprellowRuder emp_eta, Bau dep.cmp.cn) CDEPENDENT { Dep_nameDep_rehow, Dep. emp ethnep emp emy or L8: PARTICIPATION (Par dep name, Par deo relhow.Par deo emp esta Par depomp onPar hobnname, Par _ancost, Paris Week) PARTICIPATION. Par_hob_name)CHOBBY.(Hob_ name PARTICIPATION. Par dep_name, Par deprelhow, Par_depenpeia, Par depamp_cn) CDEPENDENT { Dp_name, Dep_rellow, Dep . emp eaDe_empein) L9: HOBBY Hob nameHob_ loact, Hob_giact)