Technology Briefing

1. 3 Technology Briefing Database Management “Modern organizations are said to be drowning in data but starving for information” p. 509 Information Systems Today: Managing in the Digital World

2. Learning Objectives Information Systems Today: Managing in the Digital World

3. Learning Objectives Information Systems Today: Managing in the Digital World

4. Group DiscussionCompare (present, past) of the following organizations: • Super markets • Libraries • Hospitals • Governmental offices Information Systems Today: Managing in the Digital World

5. Learning Objectives Information Systems Today: Managing in the Digital World

6. Database Foundations • Then: • Card catalogs • File cabinets • Now: • DBMS • Create • Store • Organize • Retrieve data • E.g., Microsoft Access Information Systems Today: Managing in the Digital World

7. Database • Database • Collection of related data organized in a way to facilitate searches • Entities • Something you collect data about • E.g.: people, books Information Systems Today: Managing in the Digital World

8. Record • Contains data about a single entity • Similar to catalog card Information Systems Today: Managing in the Digital World

9. Attributes • Specific characteristic describing the entities • E.g.: name and social security number are attributes of a person Information Systems Today: Managing in the Digital World

10. Example: Entity Student • Entity represented as a table, with rows as records and columns as attributes Information Systems Today: Managing in the Digital World

11. Advantages of the Database Approach • Program-data independence • Minimal data redundancy • Improved data consistency • Improved data sharing 5. Enforcement of standards • Reduced program maintenance Information Systems Today: Managing in the Digital World

12. Group Activity • Visiting “King Abdu-Allah Library” Information Systems Today: Managing in the Digital World

13. Entering Data • Forms • Give some examples of forms.. Information Systems Today: Managing in the Digital World

14. Entering Data Forms • Enter data about a record • Field in a form corresponds to attribute in a record • Used to add, modify, or delete data Information Systems Today: Managing in the Digital World

15. Example: Computer-Based Form Information Systems Today: Managing in the Digital World

16. Querying Data • Query: used to retrieve information • Structured Query Language (SQL) • Example: Display students who earned an “A” • Writing SQL queries can become very complex Information Systems Today: Managing in the Digital World

17. Creating Database Reports • Report • Compilation of data from the database • Example • Quarterly sales for a restaurant • Adding • Grouping

18. Identifying Records • Uniquely identifying records: • Primary Key • Unique identifier • E.g.: Student ID number, social security number Information Systems Today: Managing in the Digital World

19. Linking Website Applications to Organizational Databases • Users can access a variety of data via a company’s web site • Web services help in integration of databases, regardless of physical location • Need for adequate systems performance • Get understanding of customer behavior Information Systems Today: Managing in the Digital World

20. Effective Management of Databases • Database Administrator (DBA) • Responsible for development and management of databases • Works with system analysts and programmers • Works with users and managers • Implements security features • Grants access rights • One of the key actors in creating a successful database Information Systems Today: Managing in the Digital World