Question: Answer this question please?? QUESTION 3 a) Based on the following statements, draw the Entity Relationship Diagram. Show all entities, relationships, primary key(s), foreign keys,

 Answer this question please?? QUESTION 3 a) Based on the following

statements, draw the Entity Relationship Diagram. Show all entities, relationships, primary key(s),

Answer this question please??

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 Staff_No 781107 TABLE NAME: VEHICLE Registration_No Model JKL 8118 Proton X70 VET 4563 Perodua Myvi JSS 7898 Honda City VTT 4563 Perodua Myvi Colour Silver White Black Silver 811118 791010 TABLE: DEPARTMENT Department_Code IT HR Department Name Information Technology Human Resource i. 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) 8 CONFIDENTIAL CS/FEB 2021/1CT200/TS232 ii. Do the STAFF and VEHICLE exhibit referential integrity? Answer Yes or No, and then explain your

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!