1 / 10

Course Overview

Course Overview. Outline. S511 Intro Course Objective Course Design Course Overview Database Intro. Course Objective. Learn how to design and implement a database system. Understand basic database concepts and theories . Acquire hands-on experience in database design .

gillian-livingston
Download Presentation

Course Overview

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Course Overview S511 Session 1, IU-SLIS

  2. Outline • S511 Intro • Course Objective • Course Design • Course Overview • Database Intro S511 Session 1, IU-SLIS

  3. Course Objective • Learn how to design and implement a database system. • Understand basic database concepts and theories. • Acquire hands-on experience in database design. • Validate and refine the database design by prototype implementation. • Group project in database modeling and implementation (in Access, MySQL, or PostgreSQL, Oracle) • Build a solid foundation of database knowledge and skills • Gain knowledge required for a database architect/consultant/designer • prerequisite for Advanced Database Course S511 Session 1, IU-SLIS

  4. Course Design • Lecture • Database theories and principles • Lab • Hands-on database design & implementation skills • Homework Assignments • Application of acquired knowledge from lecture & lab • Group Project • Database design & prototype system development S511 Session 1, IU-SLIS

  5. S511 Overview • Grading • Group Project (50%) • Project Specification, 20% • Completed Database System, 20% • Project Presentation and demo, 10% • Homework Assignments (50%) • Course Website • http://info.slis.indiana.edu/~dingying/ • Syllabus, Schedule, Project S511 Session 1, IU-SLIS

  6. Database Intro • Data vs. Information • Data is a collection of facts. • Information is data processed for knowledge. • Changing data into information • Organize data so that it can be viewed in a useful form. • What data to collect, how & why? • What form will the derived information take? • How will information be extracted? • Requirements • Identify context of data • Organize • Summarize S511 Session 1, IU-SLIS

  7. Data into Information:Identify Context • Data • Baker, Kenneth D. 32491768 • Doyle, Joan E. 47683248 • Lewis, John C. 55174216 • Sisneros, Michael 39241658 • Context • Class Roster • Course S511, Section: 1, Fall 2010 S511 Session 1, IU-SLIS

  8. Data into Information:Organize Data • Organize data/metadata into a structured form. • Course Number: e.g. S511 • Section: e.g. 1 • Semester: e.g. Fall • Year: e.g. 2010 • Student name: e.g. Baker, Kenneth D. • Student ID: e.g. 32491768 • Identify additional data items. • Student Status: Graduate • GPA: 3.7 • Major: MIS S511 Session 1, IU-SLIS

  9. Data into Information:Summarize • Patterns, Trends & Visualization 15% CS 15% TCOM 45% ACCT 10% IST 15% MIS S511 Session 1, IU-SLIS

  10. Database Intro • Purpose • Store/retrieve/view data efficiently & effectively. • Transform data into information for decision making • Characteristics • A collection of organized data related to a particular subject/purpose • structured data, security, control • Database Management System • data storage, processing, retrieval • User Interface • data entry, search/query, view/report • Comparisons • Database vs. Search Engine • Database: design vs. administration vs. application development S511 Session 1, IU-SLIS

More Related