Unit 7 assignment

Prompt

Unit 7 Reading Assignment As you go through the readings and watch the videos, consider the following: If faced with a scenario where multiple concurrent transactions need to access the same database resources, how would you approach implementing transaction isolation to maintain data consistency? Is there a significant difference in performance between using static and dynamic SQL, and how does this impact the scalability of database-driven applications? If tasked with developing a cross-platform application that needs to interact with various databases, how would you assess the suitability of ODBC and JDBC in terms of platform compatibility and ease of integration? Read Vidhya, V., Jeyaram, G., & Ishwarya, K. (2016). Database management systems. Alpha Science International. Log into the UoPeople library and go to LIRN-Library & Information Resources Network. Click on Link to the UoPeople LIRN, under the section of Jump to a specific group, click on Computer Science, and click on EBook Central. Search for the entire name of the ebook. Use the Learning Resource Center to read on how to use the online library.  View the online book. Read Chapter 5 - Joins, Constraints and Advanced SQL Section 5.4 - Embedded SQL Sub Section 5.4.1 - Host Variables (pp. 162 till pp. 164) Section 5.5 - Dynamic SQL (pp. 166 till pp. 167) These sections delve into advanced techniques in SQL implementation within programming contexts, focusing primarily on Embedded SQL and Dynamic SQL. Embedded SQL entails integrating SQL statements directly within application code, providing a seamless means of interaction between the application and the database. Furthermore, it explores Dynamic SQL, where SQL statements are generated dynamically at runtime offering increased flexibility and adaptability in database operations. Read Chapter 7 - Transaction Processing Section 7.1 - Introduction (pp. 200 till pp. 203) Section 7.2 - Reasons for Transaction Failures (pp. 203) Section 7.3 - Transaction and System Concepts (pp. 203 till pp. 205) Section 7.4 - The System Log (pp. 205 till pp. 206) Section 7.5 - ACID Properties or Transaction Properties (pp. 206) This chapter offers a concise yet thorough exploration of transaction processing within database systems. It covers the importance of transactions, reasons for transaction failures, transaction and system concepts, the role of the system log, and the ACID properties essential for ensuring data consistency and reliability. Additional Readings Radakovic, M. (2017, January 13). Understanding SQL Server database static data and how it fits into Database lifecycle management. SQLShack. https://www.sqlshack.com/understanding-sql-server-database-static-data-fits-database-lifecycle-management/ This reading delves into the intricacies of managing static data within SQL Server databases by highlighting its significance in supporting various database operations and applications. Baeldung. (n.d.). A guide to JDBC. Baeldung. https://www.baeldung.com/java-jdbc This article provides an introductory explanation of Java Database Connectivity (JDBC). It likely covers the basics of JDBC, including its importance in connecting Java applications to databases. What is ODBC – Open database connectivity. (2023, June 10). Insightsoftware. https://insightsoftware.com/blog/what-is-odbc/ This reading offers a comprehensive exploration of ODBC, a pivotal technology in the realm of database connectivity. It begins by introducing readers to the fundamental concept of ODBC and its crucial role in facilitating access to data stored in various database management systems. Zanini, A. (2023, February 14). Database transactions 101: The essential guide. DbVisualizer. https://www.dbvis.com/thetable/database-transactions-101-the-essential-guide/ This reading describes the significance of transactions in database systems by emphasizing their role in ensuring data integrity and consistency. Central to this discussion are the ACID properties—Atomicity, Consistency, Isolation, and Durability—which serve as guiding principles for transaction management. Instructions This assignment will assess your knowledge and skills about: Identifying SQL implementation methods in programming and defining transactions in database contexts. Explaining embedded SQL usage and use key interface technologies like JDBC and ODBC. Differentiating between static and dynamic SQL and the usage of database API’s for SQL implementation. Assignment Information You are working on a project to develop an online marketplace platform where users can buy and sell products. As part of this project, you need to design and implement the database system to manage product listings, user accounts, transactions, and feedback/reviews. The system should be robust, scalable, and capable of handling large volumes of data efficiently. In the context of developing the online marketplace platform, address the following: Discuss the importance of transactions in ensuring data integrity and consistency within the online marketplace platform. Explain how you would use transactions to handle critical operations such as processing orders and updating inventory levels, ensuring that all related database changes are either committed together or rolled back in case of failure. Explain the role of static, dynamic and embedded SQL to execute database operations efficiently in the context of the online marketplace platform. Explain how you would utilize JDBC (Java Database Connectivity) and ODBC (Open Database Connectivity) to establish connections with the database to support the functionality of the online marketplace platform. Submission Instructions Read the rubric on how your assignment will be graded.   Submit the assignment in MS Word. At least 250 words and not more than 750 words (not including the reference list or the title). Double-spaced in Times New Roman font, which is no greater than 12 points. Support your arguments with sources and evidence. You should use the course readings when creating your assignment. You may also locate and use additional sources provided you cite them according to APA with a correct and clickable link. Remember to cite and list references to validate statements of fact or information that is not considered common knowledge and to corroborate personal opinions/points of view. Explore additional details on the Information Literacy page. (You will also find the Information Literacy Support widget on the right-hand side of your course page). Refer to the UoPeople APA Tutorials in the LRC for help with APA citations. You can contact the librarian at library@uopeople.edu if you need help finding resources. You can also review the resources in the Learning Resource Center. Academic Integrity If at any time you suspect that a post in this assignment violates UoPeople's rules regarding plagiarism and/or any aspect of UoPeople’s Academic Code of Conduct, please notify your instructor immediately.  This assignment will be assessed by your instructor using the attached rubric.