DatabaseManagement.pptVIP

Database Management An Introduction Goals For Today: Describe why databases have become so important to modern organizations Describe what database and database management systems are and how they work. Explain four emerging database trends: (1) client / server computing, (2) object-oriented databases, (3) data mining, and (4) integrating Web applications Database Defined Database: A collection of related data organized in a way that facilitates data searches. What are some examples of Databases? Example of a Student Database Databases Before the Use of Computers Data was stored in: books ledgers card files folders file cabinets or simply in people’s heads!? Computers make the process of storing and managing data easier The Database Approach Database Management System software application which allows you to create, store, organize, and retrieve data from a single database or many databases. Example: MS Access Entity something you collect data about Examples: people or classes A Database Contains the Following: Tables how entities are represented in a database, where each row is a record and each column a field. Fields individual pieces of information Record collection of related fields within one entity Sample Data Table (94 in your book) Key Database Issues and Activities Entering and Querying Data Creating Database Reports Data Structure Data Type Entering Data Data Entry: process of getting information into a database possible methods of data entry: Data Entry Professional, Electronic Files, Historical Records, or Web Based (Forms) Querying Data Querying: how we get information from a database Structured Query Language (SQL): most common language used to interface with databases Example: SELECT DISTINCTROW STUDENT_ID, GRADE FROM GRADES WHERE GRADE = “A” ORDER BY STUDENT_ID; Querying Data continued Query By Example (QBE) enables you to fill out a grid, or template, in order to construct a description of the data you would like to retrieve. Cr