Page 1 of 1
Given the entity relationship diagram in Figure 6, write a SQL transaction to perform the following transactions: - Find
Posted: Thu Jul 14, 2022 2:28 pm
by answerhappygod
- Given The Entity Relationship Diagram In Figure 6 Write A Sql Transaction To Perform The Following Transactions Find 1 (88.41 KiB) Viewed 37 times
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 new art_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.