Employees

idnameemailphoneNumberaddress
1John Doejohndoe@example.com123-456-7890123 Main St
2Jane Smithjanesmith@example.com987-654-3210456 Elm St

Departments

iddepartmentNamemanagerId
(→ Employees.id)
1Sales1
2Marketing2

Sales_and_marketing_jobs

jobTitletargetMarketsalarydepartmentId
(→ Jobs.title)(→ Departments.id)
Sales AssociateB2B500001
Sales AssociateRetail400001
Marketing SpecialistB2B600002
Marketing SpecialistConsumer Goods550002

Skills

skillNamerequiredForJobId
(→ Jobs.id)
Customer Service1
Digital Marketing2

Experience

employeeIdyearsOfExperiencejobTitlecompanyNamestartDateendDate
(→ Employees.id)
15Account ManagerABC Corporation2015-01-012020-01-01
23Graphic DesignerXYZ Company2017-01-012020-01-01

Jobs

idtitledescriptionlocationpostedOnclosingDateminimumYearsOfExperienceskillsRequiredId
(→ Skills.skillName)
1Sales AssociateResponsible for selling products to B2B clients.New York2021-01-012021-02-0111
2Sales AssociateAssisting customers at a retail store.Los Angeles2021-01-012021-02-0102
3Marketing SpecialistDeveloping digital marketing campaigns.San Francisco2021-01-012021-02-0123
4Marketing SpecialistCreating traditional advertising materials.Chicago2021-01-012021-02-0114