Please answer all question

[answerhappygod]

Please answer all question

Please Answer All Question 1 (71.83 KiB) Viewed 32 times

b) Diberi rajah perhubungan entiti dalam Rajah 6, tulis transaksi SQL untuk melaksanakan transaksi berikut: - Cari conf_ name, conf_organizer, art_id dan art_title dengan art_status ialah "Accept". - Pilih art_id terkini daripada jadual article dan gunakan art_id seterusnya sebagai art_id baharu - Kemudian, masukkan butiran artikel baharu ke dalam jadual article. - Selepas itu, masukkan butiran pengarang ke dalam jadual author_details. Anda boleh menggunakan data palsu untuk menunjukkan transaksi SQL. Given the entity relationship diagram in Figure 6 , write a SQL transaction to perform the following transactions: - Find the conf_name, conf_organizer, art_id and art_title where the art_status is "Accept" - Select the latest art_id from article relation and use the next art_id as the newart_id - Then, insert a new article data into the article relation. - After that, insert the author's details into the author_details table. You can use the dummy data to demonstrate the SQL transaction. Rajah 6: conference_db Diagram Perhubungan Entiti Figure 6: conference_db Entity Relationship Diagram