NP10_Chapter11 - Chapter 11 Databases 11 Chapter Contents...

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

View Full Document Right Arrow Icon
Databases Databases Chapter 11 Chapter 11
Background image of page 1

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 2 Chapter Contents h Section A: File and Database Concepts a Section B: Data Management Tools a Section C: Database Design a Section D: SQL a Section E: Database Security
Background image of page 2
1 1 SECTION A Chapter 11: Databases 3 File and Database Concepts File and Database Concepts h Database Basics a Database Models
Background image of page 3

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 4 Database Basics h A database is a collection of information Typically stored as computer files a The tasks associated with creating, maintaining, and accessing the information in databases are referred to as data management, file management, or database management
Background image of page 4
1 1 Chapter 11: Databases 5 Database Basics h Databases can be used in a variety of ways Collect and store data Update data Organize and output data Distribute data Find data Analyze 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
1 1 Chapter 11: Databases 6 Database Basics h Data mining refers to the process of analyzing existing information in databases to discover previously unknown and potentially useful information, including relationships and patterns Data warehouse Predictive analytics
Background image of page 6
1 1 Chapter 11: Databases 7 Database Basics h OLAP (online analytical processing) allows decision makers to look for relationships between multiple data dimensions Executive dashboard software
Background image of page 7

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 8 Database Models h An unstructured file has a unique structure a A structured file uses a uniform format to store data a The underlying structure of a database is referred to as a database model
Background image of page 8
1 1 Chapter 11: Databases 9 Database Models h The simplest model for storing data is a flat file that consists of a single, two-dimensional table of data elements Records can be displayed as rows in a table or as forms.
Background image of page 9

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 10 Database Models h A field contains the smallest unit of meaningful information a Each field has a unique field name a Variable-length field vs. fixed-length field
Background image of page 10
1 1 Chapter 11: Databases 11 Database Models h A record is a collection of data fields a The template for a record is referred to as a record type a A record that contains data is referred to as a record occurrence
Background image of page 11

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 12 Database Models h A relationship is an association between data that is stored in different record types One-to-many Many-to-many One-to-one
Background image of page 12
1 1 Chapter 11: Databases 13 Database Models h Cardinality refers to the number of associations that can exist between two record types a The relationship between record types can be depicted graphically with an entity-relationship diagram
Background image of page 13

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 14 Database Models h A hierarchical database arranges record types in a hierarchy
Background image of page 14
1 1 Chapter 11: Databases 15 Database Models h The network database model allows many-to- many relationships in addition to one-to-many relationship
Background image of page 15

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

View Full DocumentRight Arrow Icon
1 1 Chapter 11: Databases 16 Database Models h A relational database stores data in a collection of related tables
Background image of page 16
1 1 Chapter 11: Databases 17 Database Models h A dimensional database organizes relationships over three or more dimensions
Background image of page 17

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

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

Page1 / 64

NP10_Chapter11 - Chapter 11 Databases 11 Chapter Contents...

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

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