Question: Answer this please?? QUESTION 2 Given below are two tables of COMPANY and STUDENT for a Practical Training Database: TABLE NAME: COMPANY C_RegisNo Comp_Name State

 Answer this please?? QUESTION 2 Given below are two tables of

Answer this please??

QUESTION 2 Given below are two tables of COMPANY and STUDENT for a Practical Training Database: TABLE NAME: COMPANY C_RegisNo Comp_Name State Allowance CO01 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 a) Write the business rule(s) that govern the relationship between COMPANY and STUDENT. (3 marks) b) Create the Crow's Foot Entity Relationship Diagram to capture the business rules given in a). Show all entities, relationships, primary key(s), foreign keys, and attributes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!