HTM304-4-Database Processing

HTM304-4-Database Processing - Introduction to Management...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Introduction to Management Information Systems Chapter 4 Database Processing HTM 304 Fall 07 2 Learning Objectives Know purpose of database processing List components of a database system Understand important database terms Know elements of the entity- relationship model Understand general nature of database design 3 Purpose of a Database Keep track of things with more than one theme 4 One Theme Spread Sheet 5 Multi-theme Database Student Score Student Score Email records Email records office visits office visits All three records for one student (student is the link of different themes) All three records for one student (student is the link of different themes) 6 Database Hierarchy Bytes : the basic elements which compose of database Fields (Columns). Name, number or characters that describe an aspect of a business object or activity. e.g. Student Numbers, Student Names, Midterm Scores, etc. Record (Rows). Collection of related data fields. e.g. 000054323 Jenny White 89 . File (or Table). Collection of related records. e.g. Student Score Table, Student Office Visit Table, Student Email Record Table Database. Collection of integrated and related files + Relations between (among) tables + structure of data. The relations and structures are called metadata 7 Components of Database Database Tables or Files + Relationships among Rows in Table + Metadata = How to effectively organize and process raw data is the key to a successful database design and an Information System design. 8 Student Table Records/Rows Columns/Fields 9 Poorly Designed Table In Database Design, the record will be split into 2 records: Jones Feb 1, 2002 [email protected] 100 Finance Jones Feb 1, 2002 [email protected] 100 Accounting In Database Design, the record will be split into 2 records: Jones Feb 1, 2002 [email protected] 100 Finance Jones Feb 1, 2002 [email protected] 100 Accounting Common Practice in Excel Common Practice in Excel Pros and cons? 10 Relationships The records in different tables are connected by certain relationships – relational databases Key – column or group of columns that identifies a unique row in a table For example: Student Number is key of Student table The key insures no repeated records Every table MUST have a key Foreign key – non-key column or field in one table that links to a primary key in another table Student Number in Email and Office_Visit tables Foreign keys link records from different tables together as one compound record 11 Examples of Relationships Key Foreign Key Foreign Key 12 Review Components Database Tables or Files + Relationships among Rows + Metadata = 13 Metadata Metadata are data that describe data (Format, Field Properties, etc.) Makes databases much more useful No one needs to guess, remember, or record what is in database Make databases easy to use for authorized and unauthorized purposes 14 Exercise: Use Access to setup a data table Create a database file (*.mdb) Create table in design view All tables are in one database file...
View Full Document

This note was uploaded on 11/15/2011 for the course I SYS 201 taught by Professor Meservy during the Winter '11 term at BYU.

Page1 / 57

HTM304-4-Database Processing - Introduction to Management...

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

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