I need someone to build a database schema and SQL query for below:
Imagine you have a bike and a driving license. You also found a job board with a list of companies offering a job. To get the job, you need to fulfill some requirements. There are 10.000 companies on the job board, 10 examples are as follows:
"Company A" requires an apartment or house, and property insurance.
"Company B" requires 5 door car or 4 door car, and a driver's license and car insurance.
"Company C" requires a social security number and a work permit.
"Company D" requires an apartment or a flat or a house.
"Company E" requires a driver's license and a 2 door car or a 3 door car or a 4 door car or a 5 door car.
"Company F" requires a scooter or a bike, or a motorcycle and a driver's license and motorcycle insurance.
"Company G" requires a massage qualification certificate and a liability insurance.
"Company H" requires a storage place or a garage.
"Company J" doesn't require anything, you can come and start working immediately.
"Company K" requires a PayPal account.
Your task is to write code that will calculate for which companies you can work and for which you can't. You can convert the statements like "Company J requires PayPal account" to whatever form or structure you need. Please use PHP if you are applying for a backend developer, or JavaScript if you are applying for a frontend developer role. Also, please put your code online as a snippet, git repository, gist, etc.
Hello there, I`m an experienced full-stack developer and I`m able to help you - just contact me to discuss the details!! Best Regards! If you are interested in asp.net core!
I am professional web developer and database programmer. I have 7 years experience in this field and am a perfect for this job
Relevant Skills and Experience
As you can see on my portfolio I have past 7 years experience on projects similar to this one
Hello, hope you are doing well.
I understood your requirement. we can create database on all your predefined criteria and then once the employee comes and fills the forms we can decide he is eligible or not.
I would love to work in Java with mysql but if you want I can work in MySQL with PHP as well. I will upload the code in GIT repository once we proceed ahead
looking forward to hear from you.