Using MIS (9th Edition)
Using MIS (9th Edition)
9th Edition
ISBN: 9780134106786
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 5.8, Problem 8ARQ

Explanation of Solution

Increase of database data that will affect the business Intelligence and Security:

The increase of database data will affect the business Intelligence and security in the following ways:

  • Increases the threat of data theft.
  • Data mishandling.
  • Data being lost.
  • Data leaks.

Two major requirements of the Internet database application created:

The two major requirements of the Internet database application created are:

  • Code to process the data that are to process the internet application that are developed.
    • The data that are created needs to be stored for the future purpose that needs to follow ACID properties of the transaction.
  • Power to handle the data that are generated using the internet application that are created.
    • The data that are generated are stored based on the requirements not following ACID Properties of the Transaction.

These two requirements made the evolution of three databases namely “No SQL”, “New SQL”, and “in-memory” databases.

Characteristics of ACID properties in processing the Transaction:

The main characteristic properties of ACID in processing the transaction are discussed below:

“ACID” stands for “Atomicity”, “Consistency”, “Isolated” and “Durable”.

Atomicity:

In processing a transaction, a transaction needs to be processed completely or should not contain anything in it.

  • Example: If an account is credited by amount the amount must be either added to overall balance or should not happen at all.

Consistency:

A transaction that is established needs to be processed in a similar way throughout the transaction.

  • Example: If an account is credited by amount that amount must be either added to overall balance or should not happen at all and it should at the same time with the account holder and with the bank database.

Isolated:

The transaction that is happening needs to processed is separate unit such that another transaction should not affect the current process.

  • Example: Consider an online transaction that is happening simultaneously, any processing made with the one should not affect another processing the same process.

Durable:

The transaction that is processed needs to be established completely or should be aborted in case of failure...

Blurred answer
Students have asked these similar questions
this module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks )  this is question 3: Question3:                                                                                                                                    (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…
this module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks )  this is question 3: Question3:                                                                                                                                    (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…
this module is java 731 . make sure my answers are 1005 correct and the layout and structure is perfect and also include all comments etc. thank you i have attached question 1 (40 marks) and question 2 (30 marks )  this is question 3: Question3:                                                                                                                                    (30 MARKS) Passenger Rail Agency for South Africa Train Scheduling System Problem Statement Design and implement a train scheduling system for Prasa railway network. The system should handle the following functionalities: 1. Scheduling trains: Allow the addition of train schedules, ensuring that no two trains use the same platform at the same time at any station. 2. Dynamic updates: Enable adding new train schedules and canceling existing ones. 3. Real-time simulation: Use multithreading to simulate the operation of trains (e.g., arriving, departing). 4. Data management: Use ArrayList to manage train schedules and…
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education