Data is used to make decisions at all levels in the

This preview shows 3 out of 5 pages.

Data is used to make decisions at all levels in the organization (operations, tactical, strategic). Firms collect more and more data as technology now allows data collection and management more easily and at a cheaper cost. Given the importance of data in the decision making process, it is of utmost importance to maintain the data quality . High quality data is: Accurate Complete Timely Consistent Accessible Relevant, and Concise Firms need right tools to organize the data available and to work with it and ensure data quality. In this lecture note we will provide an overview of relational database management system that is used to manage data efficiently and effectively. Database Management System makes it easier to manage the data and ensure a high level of data quality. IT for data management: Database Management Systems A database is simply a list or lists of information. Most organizations have several databases – perhaps even hundreds or thousands. And these various databases might be focused on any combination of functional areas (sales, product returns, inventory, payroll), geographical regions, or business units. Firms often create specialized databases for recording transactions, as well as databases that aggregate data from multiple sources in order to support reporting and analysis. 3
Image of page 3

Subscribe to view the full document.

Databases are created and maintained using programs called database management systems (DBMS), sometimes referred to as database software. DBMS is a software application with which you can add, delete, modify, access, and analyze data from one or many databases. There are many database formats (such like hierarchical , and object-oriented ), but relational databases are far and away the most popular. Relational databases are databases where multiple tables are logically related based on common keys (as explained later). DBMS 3 products vary widely in scale and capabilities. They include the single-user, desktop versions of Microsoft Access 4 or Filemaker Pro, web-based offerings like Intuit QuickBase, and industrial strength products from Oracle, IBM (DB2), Sybase, Microsoft (SQL Server), and others. Oracle is the world’s largest database software vendor, and database software has meant big bucks for Oracle co-founder and CEO Larry Ellison. Ellison perennially ranks in the Top 10 of the Forbes 400 list of wealthiest Americans. The acronym SQL (often pronounced sequel) also shows up a lot when talking about databases. SQL or structured query language is a language for creating and manipulating databases, and it is by far the most common database language. You’ll find variants of SQL inhabiting everything from lowly desktop software, to high-powered enterprise products. Microsoft’s high-end database is even called SQL Server. And of course there’s also the open-source MySQL (acquired by Oracle as part of the firm’s purchase of Sun Microsystems). Given this popularity, if you’re going to learn one language for database use, SQL’s a pretty good choice. And for a little inspiration, take a look on Monster.com, searching for jobs mentioning SQL. You’ll likely
Image of page 4
Image of page 5
You've reached the end of this preview.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern