Consider the following two relational database tables to answer all the below (a-b) questions. Book Table Book_ID Book_L
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Consider the following two relational database tables to answer all the below (a-b) questions. Book Table Book_ID Book_L
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!