chapter11 - Chapter 11 Behind the Scenes: Databases and...

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

View Full Document Right Arrow Icon
CIS1000DE Chapter 11 Behind the Scenes: Databases and Information Systems
Background image of page 1

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

View Full DocumentRight Arrow Icon
CIS1000DE 2 Chapter Topics Databases and their uses Database components Types of databases Database management systemRelational databases Data warehouses and data marts Information systems Data minings Collections of related data Easily stored, sorted, organized, and queried Turn data into information
Background image of page 2
CIS1000DE Chapter Topics This chapter explores the basic building blocks from which databases are created. We discuss important features of databases and the types of database programs organizations use. We also discuss the various types of information systems that use databases and explore modern data storage designs, such as data warehouses. Finally, we examine how data can be further analyzed (or “mined”) to yield information beyond the original scope of the database design
Background image of page 3

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

View Full DocumentRight Arrow Icon
CIS1000DE 4 Advantages of Using Databases Store and retrieve large quantities of information Enable information sharing Provide data centralization Promote data integrity Allow for flexible use of data
Background image of page 4
CIS1000DE Advantages of Using Databases Without databases, you could not store and retrieve large quantities of information easily. Even very large databases can provide the information you request in seconds. Databases provide additional advantages: -they enable information sharing -they provide data centralization -they promote data integrity -they allow the flexible use of data
Background image of page 5

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

View Full DocumentRight Arrow Icon
CIS1000DE Database Terminology Field: Category of information, displayed in columns A category of information in a database is stored in a field. Fields are displayed in columns. Each field is identified by a field name, which is a way of describing the field. In a database, fields have other characteristics to describe them (aside from the field name), such as field data types and field size.
Background image of page 6
CIS1000DE 7 Database Terminology Data types: Type of data that can be stored in the field
Background image of page 7

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

View Full DocumentRight Arrow Icon
CIS1000DE When fields are created in the database, the user assigns those fields a data type. The data type indicates what type of data can be stored in the field. Common data types are as follows: Text fields hold any combination of letters or numbers and are most often used to hold text. Although text fields can contain numbers (such as telephone numbers), they are stored as text and therefore cannot be used to store numbers that will be used in calculations. Numeric fields store numbers. Values in numeric fields can be used to perform calculations. In MS-Access, currency is handled as a separate data type. Computational fields are numeric fields that store the contents of a calculation, which is generated with a formula in the numeric field. This is similar to a formula computation in a spreadsheet cell. Date fields hold date data such as birthdays, due dates, and so on. Memo fields are text fields that are used to hold long pieces of text. Object fields hold objects such as pictures, video clips, or entire documents. Hyperlink fields store hyperlinks to
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/23/2010 for the course CS 001 taught by Professor Jix during the Spring '10 term at Riverside Community College.

Page1 / 49

chapter11 - Chapter 11 Behind the Scenes: Databases and...

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

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