Program Studi: Manajemen Bisnis Telekomunikasi & Informatika Mata Kuliah: Data Management Oleh: Yudi Priyadi
( DATA MANAGEMENT OVERVIEW )
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Learning Objectives for Overview Students are able to analyze the implementation of data management in an organization / industry, through the creation of a plan modeling business process (Flow Map) and database modeling (E-RD) is implemented through the structure of the language in the database (SQL), so as to present the design of of logical database appropriate and consistent with the modeling notation.
2
Creating the great business leaders
1-2
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University GRADING • TASK-1 (individual/group/quiz) • MID TEST • TASK-2 (individual/group/quiz) • FINAL TEST
: 20 % : 30 % : 20 % : 30 %
e-Mail for the Task >>>
[email protected] REFERENCE: A.Silberschatz, H.F. Korth, S. Sudarshan. 1997. Database System Concept. New York; McGraw-Hill Companies. Y.Priyadi. 2014. Kolaborasi SQL & ERD Dalam Implementasi Database (ISBN:978-979-29-2195-3), Andi Publisher Elmasri, Ramuz, and Shamkant B. Navathe, Fundamentals of Database Systems, Addison Wesley 2011 (EN) Kenneth E. Kendall, Julie E. Kendall (2008), Systems Analysis and Design, 9th Edition, Prentice Hall Material Course Download >>> http://whyphi.staff.telkomuniversity.ac.id My Contact: 081……………. 3
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Week
Week
Core Subject
Core Subject
1
Overview
9
E-R D >>> Database >>> SQL >>> http
2
BUSINESS PROCESS MANAGEMENT (Flow Map)
10
E-R D >>> Database >>> SQL >>> http
3
BUSINESS PROCESS MANAGEMENT (Flow Map)
11
E-R D >>> Database >>> SQL >>> http
4
Modelling Data Management (E-R Diagram)
12
E-R D >>> Database >>> SQL >>> http
5
Modelling Data Management (E-R Diagram)
13
E-R D >>> Database >>> SQL >>> http
6
Modelling Data Management (E-R Diagram)
14
Database Applications
15
7
Modelling Data Management (E-R Diagram)
Data Management System Project (Simple Database System)
8
Mid-term Test
16
Final Exam
4
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
It can be for BPM >>>>
Systems Flowcharting Symbols (Flowmap) Decision
One input and two output: T/F, Y/N, Etc. For decision making.
5
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Application Architecture Evolution
Source: A.Silberschatz, 7Th Edition 6
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Database Concept
Source: Y.Priyadi, 2014 7
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Summary of Symbols Used in E-R Notation
Source: A.Silberschatz, 6Th Edition 8
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Basic notation E-R D:
Example:
Source: Y.Priyadi , 2014 9
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Our Target for this course >>>>>>
Source: A.Silberschatz, 7Th Edition 10
Creating the great business leaders
Fakultas Ekonomi dan Bisnis
Program Studi:
Dosen:
School Economic and Business
MANAJEMEN BISNIS TELEKOMUNIKASI & INFORMATIKA
Yudi Priyadi, M.T.
Telkom University
Example:
SQL :
1. Data Definition Language (DDL) >>> create, alter, & drop. 2. Data Manipulation Language (DML), >>> Insert, Select, Update, & Delete 3. Data Control Language (DCL), >>> grant & revoke.
create database cobacoba; use cobacoba; drop database cobacoba; create table tb1 ( nip int primary key, nama varchar(50), alamat varchar(50) not null ); go; insert into tb1 values (450900009,'yudi priyadi','Soekarno-Hatta Bandung'); select * from tb1;
Source: Y.Priyadi, 2014
End of Overview 11
Creating the great business leaders
