Database Systems 1 - Spring 2011

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

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

BUSMIS 1060 – I 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.
Image of page 1

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

Image of page 2
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