BU 204 Week 3 Script with timestamps.docx

BU 204 Week 3 Script with timestamps.docx - BU204 Week...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
BU204 Week Three Script Week 3 Part 1 0:00 Hello and welcome to the Week 3 audio lecture. I am your host Ron Rosalik, a Faculty at Herzing University online. In this audio lecture we will cover two main topics: Foundations of Business Intelligence: Databases and Information Management & Telecommunications, the Internet, and Wireless Technology 0:25 TOPIC 1: Foundations of Business Intelligence: Databases and Information Management Information is becoming as important a business resource as money, material, and people. Even though a company compiles millions of pieces of data doesn’t mean it can produce information that its employees, suppliers, and customers can use. Businesses are realizing the competitive advantage they can gain by compiling useful information, not just data. 1:00 To better understand our first topic this week we will accomplish the following FOUR GOALS: 1. How to Organizing Data in a Traditional File Environment 2. The Database Approach to Data Management 3. Using Databases to Improve Business Performance and Decision Making 4. Managing Data Resources 1:26 1
Image of page 1

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

View Full Document Right Arrow Icon
Goal #1: How to Organize Data in a Traditional File Environment It's almost inevitable that someday you'll be establishing or at least working with a database of some kind. As with anything else, understanding the lingo is the first step to understanding the whole concept of managing and maintaining information. It all comes down to turning data into useful information, not just a bunch of bits and bytes. And, in order to do so, to begin, one needs to understand some basic terms and concepts. File Organization Terms and Concepts This chart is a good visual since the first terms, field , record , file , database , show the relationship between each of them. 2:20 First Name Last Name Street City State Zip Telephone John Jones 111 Main St Center City Ohio 22334 555-123-6666 2
Image of page 2
In addition, an entity is basically the person, place, thing, or event on which you maintain information. Each characteristic or quality describing an entity is called an attribute . In the table shown, each column describes a characteristic ( attribute ) of John Jones’ (who is the entity ) address. Suppose you decide to create a database for your newspaper delivery business. In order to succeed, you need to keep accurate, useful information for each of your customers. You set up a database to maintain the information. For each customer, you create a record. Within each record you have the following fields: customer first name and last name, street address, city, state, zip, ID, date last paid. Smith, Jones, and Brooks are the records within a file you decide to call Paper Delivery. The entities then are Smith, Jones, and Brooks, the people about whom you are maintaining information. The attributes are customer’s name (first and last), address (street, city, state, zip code), ID, and date last paid. This is a very simplistic example of a database, but it should help you understand the terminology.
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
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