DATABASE

pls answer all questions

QUESTION 3 a) Based on the following statements, draw the Entity Relationship Diagram. Show all entities, relationships, primary key(s), foreign keys, and attributes. 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 course's 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. (4 marks) b) Questions i and ii below are based on the following tables. TABLE NAME: STAFF Staff_No Name Department_Code 781107 Muhammad bin Ali IT 801118 Ahmad Farouk bin Dusuki IT 791010 Azlinah binti Musa HR TABLE NAME: VEHICLE Registration_No Model Colour Staff_No JKL 8118 Proton X70 Silver 781107 VET 4563 Perodua Myvi White JSS 7898 Honda City Black 811118 VTT 4563 Perodua Myvi Silver 791010 TABLE: DEPARTMENT Department Code Department_Name IT Information Technology HR Human Resource 1. Identify the suitable Primary key and foreign key for each table. If the table does not have a foreign key, write None. Table name Primary key Foreign key STAFF VEHICLE DEPARTMENT (3 marks) ii. Do the STAFF and VEHICLE tables exhibit referential integrity? Answer Yes or No, and then explain your