Loading...

PRDV208: Information Management and Processing

Unit 8: Database Management, Processing, and Techniques   This unit will provide you with an overview of database management and how you can use database information retrieval in a business environment to manage inventories, customer information, and sales. This unit will also introduce you to the various types of databases (hierarchical, network, rational, and object-oriented) used in business environments and will provide you with an understanding of how databases may be structured to allow for information retrieval and the generation of reports. You will conclude this unit by examining how information can be acquired from a database and how such retrieval may help to guide business decisions. Have you ever wondered why businesses seem to know so much about you and your activities and can provide you with validation information that you may struggle to remember?  Businesses structure information in a manner that allows quick retrieval and consolidation. This unit will show you how to manage your business data and information so that when your boss asks you for a list of the organization’s biggest donors or clients in a certain region of the country, you can easily retrieve the data.

Unit 8 Time Advisory
This unit should take approximately 3.25 hours to complete.

☐    Subunit 8.1: 0.75 hours

☐    Subunit 8.2: 1.25 hours

☐    Subunit 8.3: 0.75 hours

☐    Activity: 0.5 hours

Unit8 Learning Outcomes
Upon successful completion of this unit, the student will be able to: - identify how information is structured and entered into a database; - identify business needs that require a database solution; - describe how to design a database solution in order to address a business need, and perform this task; - describe how to design database reports and retrieval processes, and perform this task; - identify various types of databases; - explain the process and techniques used to create a database; - explain Database Management systems and how a database is used in a business environment; and - identify techniques used to acquire database information for business decisions.

8.1 What Is a Database Management System?   - Web Media: YouTube: PowderSoftware’s “What Is a Database?” Link: YouTube: PowderSoftware’s “What Is a Database?” (YouTube)

 Instructions: Please click on the link above and watch this video
for an overview of databases.  

 Watching this video and pausing to take notes should take
approximately 15 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

8.1.1 How Is a Database Used in a Business Environment?   - Reading: Life123: Jacqueline Thomas’ “What Is a Database Used For?” Link: Life123: Jacqueline Thomas’ “What Is a Database Used For?” (HTML)

 Instructions: Please click on the link above and read the webpage
to learn about how businesses use databases.  

 Reading this section and completing the examples should take
approximately 10 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

8.1.2 What Are the Types of Databases?   - Web Media: YouTube: SolubleTech’s “Database Types” Link: YouTube: SolubleTech’s “Database Types” (YouTube)

 Instructions: Please click on the link above and watch this video
for information on the two basic database types.  

 Watching this video and pausing to take notes should take
approximately 15 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

8.2 How to Create a Database   8.2.1 Structure   - Web Media: YouTube: Alan Weaver’s “Creating an Access Database” Link: YouTube: Alan Weaver’s “Creating an Access Database” (YouTube)

 Instructions: Please click on the link above and watch this video
for an overview of how to structure a database and data entry
techniques.  

 Watching this video and pausing to take notes should take
approximately 15 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.
  • Activity: The Saylor Foundation’s “Database Creation Practice” Instructions: Enter the data in this image (PNG) into a database table using the steps in the previous video.

    Save the database file as “MyFirstDB.”

    Completing this activity should take approximately 30 minutes.

  • Reading: The Saylor Foundation’s “Database Creation Practice Activity Discussion Board” Link: The Saylor Foundation’s “Database Creation Practice Activity Discussion Board”

    Instructions: After completing the “Database Creation Practice” activity, please post and respond to the following topic on the course discussion board. Feel free to start your own related posts, and respond to other students’ postings as well.

    Based on the exercise in this sub-subunit, what would you add to this database in order to use it as a donor database for your annual fund raising campaign?

    Completing this activity should take approximately 15 minutes.

8.2.2 Retrieving and Creating Reports   8.2.2.1 How to Create a Business Form/Report   - Web Media: YouTube: Lynda.com’s “How to Create Forms in Access” Link: YouTube: Lynda.com’s “How to Create Forms in Access” (YouTube)

 Instructions: Please click on the link above and watch this video
for an overview of how to create a database form.  

 Watching this video and pausing to take notes should take
approximately 5 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

8.2.2.2 How to Create a Reusable Business Report   - Web Media: YouTube: Lynda.com’s “Access: How to Format Forms and Reports” Link: YouTube: Lynda.com’s “Access: How to Format Forms and Reports” (YouTube)

 Instructions: Please click on the link above and watch this video
for an overview of how to format forms and reports.  

 Watching this video and pausing to take notes should take
approximately 10 minutes.  

 Terms of Use: Please respect the copyright and terms of use
displayed on the webpage above.

8.3 Acquiring Pertinent Information for Business Decisions   Information for business decisions can be a very valuable commodity. There are many businesses that collect and sell data to organizations based on the type and quantity of data needed. Before considering the purchase of data, a business analyst should consider data that is in the public domain. The US Census collects a great deal of data on the US population that can be used to assist in business decisions.

  • Reading: United States Census Bureau’s Latest Data in American FactFinder (AFF): “How Do I Get Started?” Link: United States Census Bureau’s Latest Data in American FactFinder (AFF): “How Do I Get Started?” (HTML) 

    Instructions: Please click on the first link above, and read “How Do I Get Started?” to learn about how to search and download data that may be pertinent to your business environment.

    Studying these webpages should take approximately 30 minutes.

    Terms of Use: Please respect the copyright and terms of use displayed on the webpage above.

  • Activity: The Saylor Foundation’s “PRDV208 Course Discussion Board” Link: The Saylor Foundation’s “PRDV208 Course Discussion Board”

    Instructions: After reviewing the unit materials, please post and respond to the following topics on the course discussion board. Feel free to start your own related posts, and respond to other students’ postings as well.

 1.    Think of a situation in which you have had to or in which you
might have to use a database tool. Describe how you used these
tools.  
 2.    Why do you think a database tool is important for business
decision-making?  

 Completing this activity should take approximately 30 minutes.