Technology guide 3
Download
1 / 17

Technology Guide 3 - PowerPoint PPT Presentation


  • 75 Views
  • Uploaded on

Technology Guide 3. Data & Database. Agenda. Definition File processing problems Database Selection criteria. Definition. Element Bit, byte, field, record, file, database Entity, attribute, key field Organization & access method Sequential file Indexed sequential file

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Technology Guide 3' - margie


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Technology guide 3

Technology Guide 3

Data & Database


Agenda
Agenda

  • Definition

  • File processing problems

  • Database

  • Selection criteria


Definition
Definition

  • Element

    • Bit, byte, field, record, file, database

    • Entity, attribute, key field

  • Organization & access method

    • Sequential file

    • Indexed sequential file

    • Direct or random file


Agenda1
Agenda

  • Definition

  • File processing problems

  • Database

  • Selection criteria


File processing problems
File Processing Problems

  • Redundancy

  • Inconsistency

  • Isolation

  • Security

  • Integrity

  • Data/program independence


Agenda2
Agenda

  • Definition

  • File processing problems

  • Database

  • Selection criteria


Database
Database

  • Types

  • Structure

  • Models

  • Creation

  • Topology


Database types
Database Types

  • Business database

  • Geographical information database

  • Knowledge database / deductive database

  • Multimedia database

  • Data warehouse

  • Data marts

  • Multimedia and hypermedia database

  • Object-oriented database


Database structure
Database Structure

  • Data definition language

    • Schema & subschema

  • Data Manipulation language

    • Structured Query Language (SQL)

    • Query By Example (QBE)

  • Data dictionary


Database models
Database Models

  • Hierarchical

    • One to many

    • Usage

  • Network

    • Many to many

    • Usage

  • Relational

    • Normalization

    • Usage

  • Object-oriented

    • Usage


Database creation
Database Creation

  • Conceptual design

    • Logical view

    • Entity-relationship (ER) diagram

      • Entity, entity classes, instance, attributes, identifier

      • Relationships, binary relationships

    • Normalization


Database creation1
Database Creation

  • Physical design

    • Physical view

    • Data topology (organization)

      • Centralized

      • Distributed database

        • Replicated database

        • Partitioned

    • Access method

    • Security


Agenda3
Agenda

  • Definition

  • File processing problems

  • Database

  • Selection criteria


Selection criteria
Selection Criteria

  • User’ needs (type of application)

  • Compatibility

  • Portability

  • Reliability

  • Cost

  • Feature

  • Performance

  • Vendor’s support

  • Others?


Points to remember
Points to Remember

  • Definition

  • File processing problems

  • Database

  • Selection criteria


Discussion question
Discussion Question

  • How can a database help an organization?

  • Why normalization is very important for building a database?

  • What kind of database model(s) is most suitable for E-bay?

  • Do you see any problem(s) of the database in your organization?


Assignment
Assignment

  • Review technology guides 1-3

  • Read technology guide 4, chapter 1

  • Group Assignment

  • Research paper


ad