Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please anyone a nswer this?? QUESTION 5 a) Briefly explain about partial and transitive dependencies. (2 marks) b) Based on the following dependency diagram, identify

image text in transcribed

image text in transcribed

please anyone answer this??

QUESTION 5 a) Briefly explain about partial and transitive dependencies. (2 marks) b) Based on the following dependency diagram, identify the partial dependency, transitive dependency and full functional dependency. A1 A2 A3 A4 A5 A6 A7 (4 marks) c) Question i, ii and iii are based on the following table. SubjName Emp No 1212 Emp Name Umar Hashim Emp Post Lecturer Unit Code CSC Unit Name Computer Science Subj Code CSC131 Credit Hour 4 Room No B04 CSC122 4 B11 ITT330 4 Lab12 2323 ENG ENG312 Engineering Zaleha Ibrahim 4 Computer Concept Problem Solving Operating System Heat and Mass Transfer Introduction to Electrical Engineering Writing Skill Senior Lecturer Lab09 ENG111 4 C06 ELC112 5 B05 1516 Aishah Professor ELC English Borhan 2356 Samad Assoc. STA Statistics Abdul Prof Note: Emp means Employee, Subj means Subject STA244 Probability 4 B09 i. ii. What normal form is the table in? Please give your reasons. (3 marks) What will be the primary key of the above table? (2 marks) Normalize the table into 3NF. Show all steps on how you arrive at your answer. (7 marks)

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

How Do I Use A Database Research Tools You Can Use

Authors: Laura La Bella

1st Edition

1622753763, 978-1622753765

More Books

Students also viewed these Databases questions

Question

8. Design office space to facilitate interaction between employees.

Answered: 1 week ago