PNC Bank: Transactional Database

Decent Essays
The company that I choose was PNC bank. I think that the database that would be most beneficial would be a transactional database. A transactional database is a database management system (DBMS) that has the ability to roll back or undo a database transaction or operation if it is not completed appropriately.
Whenever information or data is stored, or manipulated in a database, the operation is thought to be a database transaction. The word designates that there has been work accomplished within the database management system or in the database itself. In order to guarantee security, a database transaction follows independently from other transactions within the system to guarantee that all information stored remains available, secure, and

Related Documents

  • Improved Essays

    The main issues will be integration, support for industry specifics transaction and advance features and if they are SaaS and on premises Platform implementation (Business Software.com, 20012). The architecture of the three accounting system vary. Netsuite and Unit4 are Multi-tenancy, which allows the programming code to be stored in one database and the customer data in another. This allows for changes and updates not to effect the users data. Sage it muli-tier architecture which mean that the functions of the application are stored separately when updates or changes are needed it have to update across the functions of the application.…

    • 486 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    Briefly describe what is database transaction? Database transaction is a sequence of operations performed as a single logical unit of work. That unit work exhibits four properties atomicity, consistency, isolation and durability properties to qualify as a…

    • 467 Words
    • 2 Pages
    Improved Essays
  • Decent Essays

    o Description of this job:  Responsibilities to contain database administration, optimization, security,…

    • 382 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    DB Billing

    • 651 Words
    • 3 Pages

    Week 3 DB Billing 2 Discuss different types of benefits available to veterans and their family members, giving specific details and examples. Active duty service members and their families can receive health benefits through the following TRICARE plans listed below. To be eligible the uniformed service member (sponsor) and their families (beneficiaries) must be enrolled in the Defense Enrollment Eligibility Reporting System (DEERS) TRICARE deductibles renew on OCT 1st. Patient responsibility is referred to as “cost share”.…

    • 651 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    Unit 10 D2

    • 502 Words
    • 3 Pages

    Task 10 (D1) Discuss how potential errors in the design and construction of a database can be avoided. One of the potential errors that can occur when creating a database is that field names and names can be spelt incorrectly due to human error this can be difficult to spot if the database is big the way of making sure that there are no naming errors is to make sure that every is checked regularly and more than twice to make sure that the chances of finding a spelling mistake is reduced. Using the wrong data type is another potential error that can occur when creating a database this can be troublesome as if there is a relationship created between the tables and the mistake is found and changed then the database wouldn’t allow you to change the field where the data type is incorrect without removing the relationship first so it will be made into a long process of removing the relationship between the tables changing the data types for each of the table before remaking the relationship between the tables again the way of preventing this is by looking at the field names for the database and then choosing the correct data type also perhaps getting the opinion of another person and rechecking that they are all correct before creating the relationship.…

    • 502 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    P1 Unit 6 Business

    • 462 Words
    • 2 Pages

    Data Confidentiality: When you keep important data it is important that the data doesn’t go out to the wrong hands. So if a business data is suddenly leaked online or maybe stolen, then this can result in a huge loss for the business and this can potentially put the business out of business. To overcome this problem, then you would need a good security program which can safeguard against any breach in confidentiality. Data Integrity: This is used to ensure that the most important data is secure and also makes sure that the data isn’t messed around with. If any of the data has been messed around with then this can result in major problems.…

    • 462 Words
    • 2 Pages
    Improved Essays
  • Decent Essays

    Ist 305 Assignment 6-3

    • 538 Words
    • 3 Pages

    ID: 2597622 IST 305 – Assignment 6 6-1: The Toronto Globe and Mail had an information systems issue with how their business databases and files were stored. Throughout the firm, multiple databases were isolated and duplicated among departments. This had caused issues, such as their subscribers receiving unnecessary marketing material, and not being able to keep the databases secure. In order for them to solve this issue was to implement and store all company data into a data warehouse using SAP NetWeaver, as well as educate their own employees on the new system to prevent further inconsistent databases. By implementing the data warehouse and training their employees, it produced the results that management envisioned.…

    • 538 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    Unit 7 D2

    • 693 Words
    • 3 Pages

    Describe the functions of database technology, the differences between centralized and Distributed database architecture, how data quality impacts performance, and the role of A master reference file in creating accurate and consistent data across the enterprise. In Chapter three, Turban discusses four types of database technologies: 1. Databases -store data gathered from business applications, transaction processing systems, and sensors.…

    • 693 Words
    • 3 Pages
    Improved Essays
  • Decent Essays

    The database is spread across two locations in an effort to centralize two uniquely different needs. The data centers are Windward Data Center in Atlanta, Georgia and Ramap Ridge in Mahwah, New Jersey. One center is used for all of the company’s computing needs and the other center for shipping, respectively. The database manages the company’s daily functions up to 30,000 terabytes of…

    • 416 Words
    • 2 Pages
    Decent Essays
  • Great Essays

    Case Study Assignment – I Campbellsville University MASSIVE DATABASE MASTERING - MASTERCARD INTERNATIONAL Various affiliations are endeavoring to address the open entryways and limit challenges related with "huge data." Industry masters gage that the total volume of data is increasing at general interims and most by a wide margin of new data being delivered is prepared to go spaces. MasterCard Universal (www.mastercard.com) is not any more impossible to miss to think about the issues identified with monstrous databases. MasterCard has amassed a data circulation focus that is more than 100-terabytes in size. Insiders expect that it will create to more than 1.8 petabytes.…

    • 933 Words
    • 4 Pages
    Great Essays
  • Improved Essays

    Farrow's Bank Case Study

    • 1002 Words
    • 5 Pages

    1. How did corporate culture, leadership, power, and motivation affect Thomas’ level of managerial hubris? The corporate culture, leadership and power at Farrow‘s Bank were questionable. The corporate culture can be described as substandard.…

    • 1002 Words
    • 5 Pages
    Improved Essays
  • Improved Essays

    Jos A Bank Case Study

    • 2526 Words
    • 11 Pages

    Discuss the significant aspects of quality control as they relate to this process. The Jos A Banks factory seemed to be split the foremen were chiefly responsible for checking quality and plant manager were responsible for product. Jos A banks had rigid standards; workers didn’t get paid for re-work. Bolt fabric was inspected and marked when received and any flaws were trimmed out during cutting. There were numerous inspection areas throughout the process from beginning to end and all products were given a final inspection once production was completed.…

    • 2526 Words
    • 11 Pages
    Improved Essays
  • Improved Essays

    Relational Database Paper

    • 800 Words
    • 4 Pages

    The relational database consists of data the business needs to be operational. Relational databases split data into two-dimensional tables as entity and attributes. Every level of the…

    • 800 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Foundational Hardware Review Questions TB–1. IS hardware is classified into what three major types? The components of an Information Systems are hardware, software, and telecommunications networks. The hardware refers to machinery, which includes central processing unit, keyboard, monitor, and mouse.…

    • 1758 Words
    • 7 Pages
    Improved Essays
  • Great Essays

    Blockchain is a shared, distributed ledger that facilitates the process of recording transactions and tracking assets in a business network [1]. It is an incorruptible digital ledger of economic transactions that can be programmed to record not just financial transactions but can be applied to everything of value. Once the information is entered in Blockchain it cannot be erased, modified or tampered with. Everyone in the network will be able to write data/perform transactions but cannot modify the data. Traditional systems follow either Centralized or Decentralized model – Examples are Banks having single point of control (Centralized) and in some cases Decentralized model – with finite points of control.…

    • 1580 Words
    • 7 Pages
    Great Essays