Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started