AIS+ch04 - CHAPTER 4 Relational Databases 1 LECTURE OUTLINE...

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

View Full Document Right Arrow Icon
CHAPTER 4 Relational Databases 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
LECTURE OUTLINE How are databases different than file-based legacy systems? Why are databases important and what is their advantage? What is the difference between logical and physical views of a database? What are the fundamental concepts of database systems such as DBMS, the data dictionary, and DBMS languages? What is a relational database, and how does it organize data? How are tables structured to properly store data in a relational database?
Background image of page 2
File Organization Terms & Concepts Bit Bit : Smallest unit of data; binary digit (0,1) Byte Byte : Group of bits that represents a single character Field Field : Group of words or a complete number Record Record : Group of related fields File File : Group of records of same type Database Database : Group of related files
Background image of page 3

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

View Full DocumentRight Arrow Icon
File Vs. Databases Database systems were developed to address the problems associated with the proliferation of master files. For years, each time a new information need arose, companies created new files and programs. The result: a significant increase in the number of master files. problems of proliferation of master files: same information stored in multiple files. difficult to effectively integrate data and obtain an organization-wide view of the data. same information may not have been consistent between files. If a student changed his phone number, it may have been updated in one master file but not another. Master File 1 Fact A Fact B Fact C Master File 2 Fact A Fact D Fact F Master File 3 Fact A Fact B Fact F Enrollment Program Fin. Aid Program Grades Program
Background image of page 4
File Vs. Databases A database is a set of inter-related, centrally coordinated files. Database Fact A Fact B Fact C Fact D Fact E Fact F Enrollment Program Fin. Aid Program Grades Program Database Management System
Background image of page 5

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

View Full DocumentRight Arrow Icon
File Vs. Databases The database approach treats data as an organizational resource that should be used by and managed for the entire organization, not just a particular department. A database management system (DBMS) serves as the interface between the database and the various application programs. Database Fact A Fact B Fact C Fact D Fact E Fact F Enrollment Program Fin. Aid Program Grades Program Database Management System
Background image of page 6
File Vs. Databases The combination of the database, the DBMS, and the application programs that access the database is referred to as the database system . The person responsible for the database is the database administrator . As technology improves, many large companies are developing very large databases called data warehouses. Database Fact A Fact B Fact C Fact D Fact E Fact F Enrollment Program Fin. Aid Program Grades Program Database Management System
Background image of page 7

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

View Full DocumentRight Arrow Icon
Huge database system that stores and manages data required to analyze historical and current transactions Supports reporting and query tools Stores current & historical data Consolidates data for management analysis and decision making Data Warehousing
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 12/21/2010 for the course ACCT 330 taught by Professor Heidi during the Fall '09 term at Hong Kong Shue Yan.

Page1 / 42

AIS+ch04 - CHAPTER 4 Relational Databases 1 LECTURE OUTLINE...

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