SYSTEMS DEVELOPMENT AND DECISION MAKING PPP3-6.pptx

Information management has become more crucial as

Info icon This preview shows pages 37–41. Sign up to view the full content.

accurate, relevant valuable, organizational resource. Information management has become more crucial as data is increasing beyond kilobytes, megabytes, and gigabytes to terabytes (1,024 gigabytes), petabytes (1,024 terabytes), and exabytes (1,024 petabytes) Data redundancy - Occurs when the same data are stored in multiple locations resulting in the waste of information systems resources. Data inconsistency - Occurs when different values occur for the same attribute in one or more location. Database - is a set or collection of data that is centrally located in an electronic format, organized in tables, and easily searchable through use of query. Databases support a real-time environment and avoid data redundancies database contains one or more lists, known as tables of data, that are organized by columns, rows, and cells((i.e., name, address, dollar amount, etc.) Database management system (DBMS) - is a software program that manages, organize, and provides multiple users with access to data, creating, retrieving, and updating database to perform administrative tasks to databases.
Image of page 37

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Database Terminology Entity -A person, item, event, etc., managing a collection of data(e.g. customer or student info) Field - An attribute of an entity, such as name, address, or student ID. Record - A set of related fields, also called a tuple(items in parenthesis), that describe one occurrence of an entity, such as a customer. Table - A collection of related records(e.g. customer Information contained in one table) Primary key - A field that uniquely identifies a record(e.g. customer ID or student ID) Foreign key – A collection of fields that link two tables together that uniquely identifies the row of a table. Essentially, defined secondary table. Schema - The complete definition of a database, including the tables, records, fields, and relationships.
Image of page 38
Relational Database – A structured database(Software) using relationships in rows and columns to connect tables of records together with complex relationships. Uses SQL Made of indexed tables that can be implemented using a partitioned approach. Benefit from partitioning the data as part of implementation and maintenance. Cannot handle big data Object oriented database model Used when media or other types of files are required because multimedia files and diagrams or blueprints such as those generated by computer aided design (CAD) are more complex and not easily sorted by columns and rows. Operational databases (OLTP) used to update data in real-time used to track inventory etc. Online analytical processing (OLAP) Allows businesses to create new records, update records, and delete records in real time and in provides real time information enable ease of decision making Flat file – a database that stores data in plain text files Hierarchical - A database in which data is sorted in a tree like structure, where one phase must be complete before the other can progress.
Image of page 39

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Web-Based Databases Improve Performance and Decision Making Advantage: Allows users to access information from anywhere at any time Flexible and information can be shared among several computers, often in a cloud-computing format
Image of page 40
Image of page 41
This is the end of the preview. Sign up to access the rest of the document.

{[ 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