Hi Prof. Farhat, thanks for the video. I understand all except the part where you indicated Pizza_Code as both (PK) and (FK). I would have imagined Pizza_Code would only be FK and linked with Pizza table. In Order_details table, Pizza Code could appear more than once. So I am not sure why Pizza_Code qualifies as a PK in this case. Would you please explain if you see this comment? Thanks
They're both foreign keys because they are not uniquely identifiable to that column of order details Both of them together become a primary key, because then they are uniquely distinguishable between the other columns as a single unit of order No and Pizza code. There is not a another order number and pizza code combo key located in any other columns
If you didn’t exist, we would’ve found a way to create you Farhat ! Thanks!
Thnk you sooo much Sir !
Most welcome! Thank you and please visit the website for more farhatlectures.com/ Start your free trial!
Hi Prof. Farhat, thanks for the video. I understand all except the part where you indicated Pizza_Code as both (PK) and (FK). I would have imagined Pizza_Code would only be FK and linked with Pizza table. In Order_details table, Pizza Code could appear more than once. So I am not sure why Pizza_Code qualifies as a PK in this case. Would you please explain if you see this comment? Thanks
They're both foreign keys because they are not uniquely identifiable to that column of order details
Both of them together become a primary key, because then they are uniquely distinguishable between the other columns as a single unit of order No and Pizza code.
There is not a another order number and pizza code combo key located in any other columns
Can we expect same type of questions for CPA exam?
Yes bro!