Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  1. 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

  1. marks)

  1. 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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases

Authors: Joachim Schnier

1st Edition

0240809173, 978-0240809175

More Books

Students also viewed these Databases questions

Question

Did the decisions need to be made, or had they already been made?

Answered: 1 week ago

Question

How many Tables Will Base HCMSs typically have? Why?

Answered: 1 week ago

Question

What is the process of normalization?

Answered: 1 week ago