Normalization Question with Solution up to BCNF for DBMS Exams

[@akashsivatejajayampu2444]

No of Hours worked determines total charge then it is transitive dependency

[@rhitikapal4690]

Thank you for posting

[@pratimaacharya4873]

Thank you so much ! Keep posting more !!

[@sintoomahat6454]

Please add more of this thankyou

[@AnasTahira]

What would be the primary key in R1? you didn't include any primary key because the employee name attribute cant be a primary key.

[@urvashi654]

Thnku sir for this Well explained :)

[@020hamza2]

Thank you very much very much nice question

[@shilpaadhikari8318]

Thank you for posting

[@hasanmougharbel8030]

Hello there, glad to meet again. I have a simple enquiry.. In what case it would be convenient to apply BCNF form of normalization to my data? Thanks for taking care of this.

[@Basanti5]

why did u choose charge hour in R1 table at 3:03 instead of primary key?? plz sir explain

[@wtp]

In R1, we are fetching the attributes directly related to Employee. For 1NF, for the time being, we are considering EmpName as primary key. In real projects, it is better to add EmpID because EmpName is not guaranteed to be unique.

[@Basanti5]

Ok sir thank u😊😊

[@sujalmanandhar6117]

Hya copy ma garera bujhako vaye hunthyo k lekhya nai clear vayena😢

[@animeshkhadka7214]

sir nepali mai video banaununa TU ko question solve garera