questions1 question 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 Identify the suitable Primary key and foreign key for each table If the table does not have a foreign key, write None ANSWER Table name Primary key Foreign key STAFF VEHICLE DEPARTMENT marks) Do the STAFF and VEHICLE exhibit referential integrity Answer Yes or No, and then explain your answer (5 marks) ANSWER Table Yes No Explanation STAFF VEHICLE QUESTION 2 Given below are the business rules for UiTM library system The book borrower may be classified as either a student or a staff A staff who is doing a part time study program is also classified as a student A staff may be a lecturer or an administrator or both A student is either a postgraduate or an undergraduate student Draw an Extended Entity Relationship Diagram (EERD) that shows a generalization hierarchy of supertype and subtype entities Your answer must fulfill the rules of EERD

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 26, 2024

questions1 question 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

questions1

question 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

Identify the suitable Primary key and foreign key for each table. If the table does not have a foreign key, write None.

ANSWER:

Table name	Primary key	Foreign key
STAFF
VEHICLE
DEPARTMENT

marks)

Do the STAFF and VEHICLE exhibit referential integrity? Answer Yes or No, and then explain your answer.

(5 marks)

ANSWER:

Table

Yes/No

Explanation

STAFF

VEHICLE

QUESTION 2

Given below are the business rules for UiTM library system:

The book borrower may be classified as either a student or a staff.

A staff who is doing a part-time study program is also classified as a student.

A staff may be a lecturer or an administrator or both.

A student is either a postgraduate or an undergraduate student.

Draw an Extended Entity Relationship Diagram (EERD) that shows a generalization hierarchy of supertype and subtype entities. Your answer must fulfill the rules of EERD.