#A4# #employee# ## ## #employee_id# #identity# ## ## #department_id# #int# #not null# ## #first_name# #varchar(255)# #not null# ## #last_name# #varchar(255)# ## ## #start_date# #date# ## ## #department# ## ## #department_id# #identity# ## ## #name# #varchar(255)# #not null# ## ## #department (department_id,name)# #1,'Marketing' 2,'Production' 3,'Design'# #mysql: typemap# #identity: int unsigned auto_increment# #db2: typemap# #identity: int generated by default as identity #