Page 1 of 1
Consider the following two relational database tables to answer all the below (a-b) questions. Book Table Book_ID Book_L
Posted: Wed Apr 27, 2022 1:25 pm
by answerhappygod
- Consider The Following Two Relational Database Tables To Answer All The Below A B Questions Book Table Book Id Book L 1 (50.94 KiB) Viewed 32 times
Consider the following two relational database tables to answer all the below (a-b) questions. Book Table Book_ID Book_Language Book_Price B-001 English 50 KWD B-002 English 10 KWD B-003 Arabic 80 KWD B-005 French 20 KWD Author Table Author_ID Book_ID B-001 A-001 Author_Full_Name Date_of_Publishing Ali Ahmad Ali 1/12/2018 Lama Ahmad Ali 17/5/2019 A-007 B-001 A-012 B-002 Eman Ahmad 15/4/1994 A-005 B-003 Hamad Omar 12/7/2018 A: Identify the primary keys and foreign keys for each table. (30 Points) B: Is it possible to add the below record to the Author table? Explain why? (10 Points) A-006 B-006 Khaled Omar 16/8/2021