1 / 17

Pemrograman Terstruktur

Pemrograman Terstruktur. Dengan FoxPro. Ichwan R Tandjung 2013. Pemrograman Terstruktur. Pokok Bahasan Konsep Database Konsep dasar pemahaman pemrograman dengan Foxpro Konsep pemrograman dengan menggunakan objek. Pustaka

pearl
Download Presentation

Pemrograman Terstruktur

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. PemrogramanTerstruktur Dengan FoxPro Ichwan R Tandjung 2013

  2. PemrogramanTerstruktur PokokBahasan • Konsep Database • KonsepdasarpemahamanpemrogramandenganFoxpro • Konseppemrogramandenganmenggunakanobjek Pustaka RiyantoTosindanTaufikSuriyanto, Dinastindo ,1998, Cara BelajarMudahFoxpro Ian Chandra, 1993, PanduanLengkap Fox Pro for Widows Versi 2.5, Elex Media Komputindo TjendriHerianto, 2000, PanduanBagiPemrogramTuntunanPraktisPemrograman Thomas Connoly-Carolyn Begg, Database Systems, A Practical Approach to Design, Implementation, dan Management

  3. PemrogramanTerstruktur KomposisiPenilaian • Tugas, Kuis 20 % • Ujiantengah semester (UTS) 30 % • Ujianakhir semester (UAS) 50 %

  4. Materi Pert 1: Pendahuluan Pert 2: Basic Foxpro Programming 1 Pert 3: Basic Foxpro programming 2 Pert 4: Basic Foxpro programming 3 Pert 5,6: Basic Foxpro programming 3 (Prosedur, Pengendalian Program) Pert 7: Review Pert 8: Visual Foxpro : Pengenalan Pert 9: Pengolaan Database (Relasi database dan query serta view dalam Visual Foxpro ) Pert 10: Form Pert 11: KontrolMasukan, KontrolEksekusi, KontrolKeluaran Pert 12: Menu dan Toolbar Pert 13: LaporandanAplikasi Pert 14: Review

  5. Visual FoxPro Version 9.0Development Environment

  6. Help

  7. Database & Hierarchy of Data • Database: a collection of integrated and related files • File: a collection of related records • Record: a collection of related data fields • Field: typically a name, number, or combination of characters that describes an aspect of a business object or activity Hierarchy of data: formed by Bits  Characters  Fields  Records  Files  Databases Principles of Information Systems, Seventh Edition

  8. The Hierarchy of Data • A bit (a binary digit) represents a circuit that is either on or off • A byte is typically 8 bits • Character: each byte represents a character, the basic building block of information Principles of Information Systems, Seventh Edition

  9. Database & Hierarchy of Data Principles of Information Systems, Seventh Edition

  10. Data Entities, Attributes, and Keys • Entity: a generalized class of people, places, or things (objects) for which data is collected, stored, and maintained • Attribute: a characteristic of an entity • Data item: the specific value of an attribute • Key: a field or set of fields in a record that is used to identify the record • Primary key: a field or set of fields that uniquely identifies the record Principles of Information Systems, Seventh Edition

  11. Keys and Attributes Principles of Information Systems, Seventh Edition

  12. Database, DBMS & Applications Principles of Information Systems, Seventh Edition

  13. DBMS Database Management System (DBMS): group of programs that manipulate database and provide interface between database and users Data Definition Language (DDL) A collection of instructions and commands used to define and describe data and data relationships in a specific database Data Manipulation Language (DML): the commands that are used to manipulate the data in a database Data Control Language (DCL): the commands that are used to control access to the data in a database Principles of Information Systems, Seventh Edition

  14. Popular Database Management Systems • Popular DBMSs for end users include Microsoft’s Access and Corel’s Paradox • The complete database management software market includes databases by IBM, Oracle, and Microsoft • Examples of open-source database systems: PostgreSQL and MySQL • Many traditional database programs are now available on open-source operating systems Principles of Information Systems, Seventh Edition

  15. Creating and Modifying the Database • Data definition language (DDL) • A collection of instructions and commands used to define and describe data and data relationships in a specific database • Allows the database’s creator to describe the data and the data relationships that are to be contained in the schema and subschemas • Data dictionary: a detailed description of all the data used in the database Principles of Information Systems, Seventh Edition

  16. Manipulating Data and Generating Reports • Once a database has been set up and loaded with data, it can produce reports, documents, and other outputs • Data manipulation language (DML): the commands that are used to manipulate the data in a database Structured Query Language (SQL): adopted by the American National Standards Institute (ANSI) as the standard query language for relational databases Principles of Information Systems, Seventh Edition

  17. Examples of SQL Commands Principles of Information Systems, Seventh Edition

More Related