## Business_Profession

id | profession
--- | ---
1 | Sales Manager
2 | Sales Associate
3 | Marketing Specialist
4 | Product Manager
5 | Data Analyst

## Working_Arrangement

id | arrangement
--- | ---
1 | Hybrid
2 | Remote
3 | Onsite
4 | Flexible
5 | In-office

## Company

id | name | industry | location
--- | --- | --- | ---
1 | TechCorp | Technology | New York
2 | Finance Inc. | Financial Services | Los Angeles
3 | Health Solutions | Healthcare | Chicago
4 | EcoFriendly | Environmental Services | San Francisco
5 | Travel World | Travel & Tourism | Miami

## Job_Posting

id | title | description | required_skills | salary | post_date | business_profession_id | working_arrangement_id | company_id
--- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Business_Profession.id) | (→ Working_Arrangement.id) | (→ Company.id)
1 | Senior Sales Manager | Lead a team of sales representatives... | Strong communication skills, leadership experience... | 80000.0 | 2022-06-01 | 1 | 1 | 1
2 | Regional Sales Manager | Manage multiple territories across the country... | Strong negotiation skills, knowledge of CRM systems... | 70000.0 | 2022-06-02 | 1 | 2 | 2
3 | Digital Marketing Specialist | Develop and execute digital marketing strategies... | SEO, SEM, social media management... | 60000.0 | 2022-06-01 | 3 | 1 | 1
4 | Market Research Specialist | Analyze market trends, customer behavior... | Statistical analysis, data visualization... | 55000.0 | 2022-06-02 | 3 | 3 | 3
5 | Software Engineer | Design and develop software applications... | JavaScript, Python, HTML/CSS... | 90000.0 | 2022-06-01 | 4 | 4 | 4