I have these following requirements
An employer MAY log in to a system with their username and password and create a job opportunity.
An applicant MAY log in to a system with their username and password to view the job opportunity.
an employer has attributes of employer_id,name,role
an applicant has attributes of applicant_id,DOB,Name
an jobOppotunity has a attributes of JobId,Title,Description
This is the diagram I came up with.
![diagram]http://This image host is not supported, please use another/image/wa59qacwz/
transforming the diagram to sql script
http://pastebin.com/wUnU5NMT
I am not really sure I am writing the script and drawing the diagram correctly according to the requirements.