1.Given below are two tables of COMPANY and STUDENT for a Practical Training Database:

TABLE NAME: COMPANY

C_RegisNo	Comp_Name	State	Allowance
C001	Telekom Malaysia	Sabah	300
C002	Tenaga Nasional Berhad	Kuala Lumpur	400
C003	Jalur Lebar Sdn Bhd	Selangor	500
C004	Smart Tech Enterprise	Pulau Pinang	400
C005	Jaya Bina Sdn Bhd	Kuala Lumpur	400
C006	Perbadanan Perpustakaan Awam Negeri	Kelantan	250
C007	Muzium Negeri	Terengganu	200

TABLE NAME: STUDENT

StudentNo	Stud_Name	Program	C_RegisNo
S101	Atiqah Omar	CS110	C001
S102	Faizal Tahir	CS110	C004
S103	Mariam Iskandar	CS240	C007
S104	Muzammil Harun	CS220	C007
S105	Sofea Kamarul	CS110	C003
S106	Sufian Jamil	CS240	C002
S107	Zawatil Salleh	CS240	C003
S108	Zulhilmi Ikram	CS220	C005

Note: C_RegisNo means Company Registration No

1. Write the business rule(s) that govern the relationship between COMPANY and STUDENT.
2. Create the Crows Foot Entity Relationship Diagram to capture the business rules given in a). Show all entities, relationships, primary key(s), foreign keys, and attributes.

   2.Based on the following statements, draw the Entity Relationship Diagram. Show all entities, relationships, primary key(s), foreign keys, and attribute The MDEC offers various professional courses to the unemployed workers. Each unemployed worker is only allowed to register one professional course. The course can be run if the courses enrolment is more than 10 unemployed workers. The data that should be recorded about the unemployed workers are IC number, name, and email address. While the professional course must have the Course ID, course name and duration of course being recorded.