Database Systems 1 - Spring 2011

Database Systems 1 - Spring 2011 - BUSMIS 1060 INTRODUCTION...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
NTRODUCTION TO I NFORMATION S YSTEMS Database Systems Part 1 – Database Fundamentals Background For many companies, the most valuable asset the company has is data. Organizations store data in databases and data warehouses, as discussed in class, and use this information in their production systems and for data mining. Some examples include: Banking transaction systems store data in databases containing information about customers, accounts, and transactions for those accounts University enrollment systems store data in databases containing information about students, faculty, courses, and enrollment in those courses Cell phone billing systems store data in databases containing information about customers, rate plans, and calls made Credit card billing systems store data in databases containing information about customers, credit plans, and items charged Supermarket checkout systems store data in databases containing information about customers, products, and buying habits of their customers. The loyalty card that you have swiped at the checkout ties all of your purchases back to your name All of the databases discussed above are relational databases. A relational database is simply a group of tables that record information about business activities. In other words a relational database consists of tables of data. To get information in and out of a relational database requires a Relational Database Management System (RDBMS). The goal of the system is to ensure rapid transactions while safe guarding the integrity of the data. Analyzing data stored in these databases to spot trends and problems is a skill required by virtually all managers. Often you have a “hunch” what the problem may be but you need the data to back up your position. Sometimes you have no idea and are just fishing through the data. In either case, your analytical skills are very much in demand by the company. Senior management will make decisions based on your findings. In this first Database Systems assignment, you will use Microsoft Access, a Relational Database Management System, to build a relational database which focuses on a company’s products and orders. This document walks you through a set of exercises designed to help you learn to use Microsoft access and some of its capabilities and tools. The following skills will be covered in these exercises: Creating databases Importing Microsoft Excel files and text files Creating queries from one table Creating queries from multiple tables Creating reports using the report wizard Editing and formatting the report layout after creating a report Instructions for handing in your assignment are provided at the end of the exercises. These deliverables are due by the date indicated in the syllabus. 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 12/03/2011 for the course BUSMIS 1060 taught by Professor Robbins during the Spring '09 term at Pittsburgh.

Page1 / 22

Database Systems 1 - Spring 2011 - BUSMIS 1060 INTRODUCTION...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online