Question

Question 3 (10 MARKSI Consider the following relation and set of functional dependencies: LECTURER (STAFE-ID, LEC-NAME, LEC-ADDR, LEC-PHONE, YEAR-OF-BIRTH, RETIREMENT-YEAR LECT-TYPE, SALARY) YEAR-OF-BIRTH-> RETIREMENT-YEAR LECT-TYPE → SALARY State, with reasons, the highest normal form. Decompose into a set of BCNF relations. a) 14 MARKS)

SUBJECT : DATABASE MANAGEMENT SYSTEMS

REPOST: DIDNT GET AN ANSWER BEFORE

Answer 1

Decomposition: in 3rd Normal Form Lecturer(StaffID,Lec name,Lec-Addr Lec phone,Year of birth,Lec-Type Lectruer type Lec type, Salary) Now it Convert to BCN Lecturer Staff ID.Lec name.Lec-Addr Lec-phone·Year of birth) Lectruer type Lec type,Salary Lect type(Staff ID,Lec type)

if you still have any Problem regarding this question please comment and if you like my code please appreciate me by thumbs up thank you.........