CPA Exam Simulation: Relational database Primary and Foreign Key

[@khalilsane]

If you didn’t exist, we would’ve found a way to create you Farhat ! Thanks!

[@sandhya3107]

Thnk you sooo much Sir !

[@AccountingLectures]

Most welcome! Thank you and please visit the website for more farhatlectures.com/ Start your free trial!

[@denishchow1992]

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

[@GoldenSkeeter]

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

[@akhildas1368]

Can we expect same type of questions for CPA exam?

[@sonafrancis7010]

Yes bro!