I was planned for develop my database.I was planned about data,table, and drawing dataflow
diagram for determine what datum are flow in database system.I went to met teacher almost every month for present database diagram ,then I learned "How to draw diagram correctly".
database diagrams is involved context diagram,dataflow diagram,E-R diagram.It useful for
operate,develop,implement,my database well.
In last week,I deployed table on MySQL database,I used phpMyAdmin tools. Database is
consits 3 table are MOE_GIRL,CREATOR,MOE_TYPE,these tables are related.I added data
by GUI but I create relation between table by COMMAND LINE. I copied database command
[such as Createtable,CREATEDATABASE]to text file for study it later.
In the future,I will normalize and develop database application for get database more usable
and learning further.
Tuesday, December 30, 2008
Thursday, December 18, 2008
Drawing dataflow diagram
The process that operate our data in our database usually transfer data between processes. We can determine which data flowing in processes by Using dataflow diagram.
When we need to create database operation application such as Web application,Shop inventory system etc, we need to know what data those store in our database. The application will have to running processes to show and response us, each process have to transfer data between them. To determine which data flowing in each processes we have to drawing some diagram in our paper.
Dataflow diagram is very helpful to determine which data will flow in each process.It doesn't like flowchart beacause It certainty mentioned about data,we don't have to write a lot of conditions.It is one of necessary diagram to planing systems those will running on website,inventory,HR etc.It is guide to us which data will using in each process,which data will transfered between processes.
We can draw dataflow in following forms:
1.Yourdon + Demarco.
2.Gane and Sarson.
3.SSDAM
4.Unified
Concept of drawing :::the application or process is like closed box please open them.
In following step to determine data.
1. draw context diagram -- to determine which data will operated between user and application
2.draw Level 0....n dataflow diagram -- to uncover application and determine data in each processes,we can separate in small module to get easily understand.
***********************************************************************************
When we need to create database operation application such as Web application,Shop inventory system etc, we need to know what data those store in our database. The application will have to running processes to show and response us, each process have to transfer data between them. To determine which data flowing in each processes we have to drawing some diagram in our paper.
Dataflow diagram is very helpful to determine which data will flow in each process.It doesn't like flowchart beacause It certainty mentioned about data,we don't have to write a lot of conditions.It is one of necessary diagram to planing systems those will running on website,inventory,HR etc.It is guide to us which data will using in each process,which data will transfered between processes.
We can draw dataflow in following forms:
1.Yourdon + Demarco.
2.Gane and Sarson.
3.SSDAM
4.Unified
Concept of drawing :::the application or process is like closed box please open them.
In following step to determine data.
1. draw context diagram -- to determine which data will operated between user and application
2.draw Level 0....n dataflow diagram -- to uncover application and determine data in each processes,we can separate in small module to get easily understand.
***********************************************************************************
Sunday, December 7, 2008
Practice: How to draw workflow and dataflow?
I studied how to draw workflow and dataflow on last thursday(12-4-2008).I was drew workflow and my dataflow with my partner. And I show it's to my teacher for determine what is mistake in my work.
A workflow is a diagram that show sequence of operation ,declared as a work of a group of person,work of an organization of staff, or machines.
Example of Workflow
A dataflow is a diagram representation of the "flow" of data through an information system. it shows the data flow of the program.
Example of Dataflow
In that class, case study for workflow and dataflow workshop was Student registeration system of My university.It is familiar with students.
students are devided into 3person per a group,3 person are difference major.the problem for workshop is based on experience of people in a group.
First,we drew workflow.We were brainstrom for determined what is processes in each steps those students have to do when they register for each semester and wrote them down in workflow format. Second,we drew dataflow.We were looked workflow for determined what those data in each processes and wrote them down in dataflow format.
Our workshop had been found mistakes when teacher checked for this reason I had to corrected it in many times until it it was correctly.
Teacher was assigned students to drawing their workflow and dataflow in their computer -- use visio, etc. And print it out to paper for submit in teacher office.And teacher assigned student to determine dataflow for their miniproject.
A workflow is a diagram that show sequence of operation ,declared as a work of a group of person,work of an organization of staff, or machines.
Example of Workflow
A dataflow is a diagram representation of the "flow" of data through an information system. it shows the data flow of the program.
Example of Dataflow
In that class, case study for workflow and dataflow workshop was Student registeration system of My university.It is familiar with students.
students are devided into 3person per a group,3 person are difference major.the problem for workshop is based on experience of people in a group.
First,we drew workflow.We were brainstrom for determined what is processes in each steps those students have to do when they register for each semester and wrote them down in workflow format. Second,we drew dataflow.We were looked workflow for determined what those data in each processes and wrote them down in dataflow format.
Our workshop had been found mistakes when teacher checked for this reason I had to corrected it in many times until it it was correctly.
Teacher was assigned students to drawing their workflow and dataflow in their computer -- use visio, etc. And print it out to paper for submit in teacher office.And teacher assigned student to determine dataflow for their miniproject.
Saturday, November 29, 2008
Tables to store data in My database.
I had planed about data will store in my database and I was created tables to store my data.
My database is consists three tables in shown belong.
1. Girl data : It main table is store data about girls.
Field Deatails:
- Name [Character Name]
- Picture [Character Picture]
- Anime [The animation that character is act]
- Manga [The manga that character is act]
- Role [The role in animation or Manga]
- Characteristics [Habit or Behavior]
- Character type [ or MOE Type of Character such as Loli--very young girl]
- Creator [Creator Name that create Character]
- Weapon [Weapon or Tools that Character is usually held]
- Partner [Animal or person that usually to follow the Character]
2. Creator : It is store data about creators who are create girls.
Field Details:
- Creator[Creator Name]
- Publisher[Publisher which Creator is belonged]
- Manga [Manga Name which Creator are create]
- Anime [Anime Name which Creator are created]
3. Character type : It also called "MOE Type", is store types of character information.
Type of character such as Lolicon(very young girl),Nekomimi(girl with cat
ears);
Field Details:
- Character Type[name of Character Type]
- Type details [Commonly behavior of Character Type details]
- Type decoration[decoration details. For example Nekomimi decoration are
cat ears and cat tails. Meganemimi decoration are glasses.]
three tables are related between them in shown belong
Creator in Girl data table is relation with Creator in Creator table
Character type in Girl data table is relation with Character type in Character
type table
***********************************************************************************
My database is consists three tables in shown belong.
1. Girl data : It main table is store data about girls.
Field Deatails:
- Name [Character Name]
- Picture [Character Picture]
- Anime [The animation that character is act]
- Manga [The manga that character is act]
- Role [The role in animation or Manga]
- Characteristics [Habit or Behavior]
- Character type [ or MOE Type of Character such as Loli--very young girl]
- Creator [Creator Name that create Character]
- Weapon [Weapon or Tools that Character is usually held]
- Partner [Animal or person that usually to follow the Character]
2. Creator : It is store data about creators who are create girls.
Field Details:
- Creator[Creator Name]
- Publisher[Publisher which Creator is belonged]
- Manga [Manga Name which Creator are create]
- Anime [Anime Name which Creator are created]
3. Character type : It also called "MOE Type", is store types of character information.
Type of character such as Lolicon(very young girl),Nekomimi(girl with cat
ears);
Field Details:
- Character Type[name of Character Type]
- Type details [Commonly behavior of Character Type details]
- Type decoration[decoration details. For example Nekomimi decoration are
cat ears and cat tails. Meganemimi decoration are glasses.]
three tables are related between them in shown belong
Creator in Girl data table is relation with Creator in Creator table
Character type in Girl data table is relation with Character type in Character
type table
***********************************************************************************
Monday, November 24, 2008
Anime and Manga Girl Details
Anime and Manga Girl Details:
Manga and Anime Girl characters ,We also call “MOE” (pronounce(mo-eh)) and also call 2D girl ,is essential in Manga and Anime because they make reader or audience to get more impression . In commonly, we have seen They attribute is Huge beautiful eye, slim,sexy ,etc. They skill is very wonderful, for example, Magician girls are able to fly without gasoline or jet engine but fly with they wand .They are separated into various kind by their characteristic.
In following Example is kind of Girl
1. Nekomimi --- the girl has got cat ears.
2. lolicon --- very young girl.
3. Maid --- housewife.
4. more than all of above.
more people who addition in Anime or Manga have been fall in love with Manga or Anime girl because they have got advantage more than reality girl.
To get more Anime and Manga girl Details ,you able to visit in following link:
http://www.animenewsnetwork.com/encyclopedia/
http://en.wikipedia.org/wiki/Moe_(slang)
word definition:
Anime means : Japanese animation.
Manga means : Japanese comics.
Manga and Anime Girl characters ,We also call “MOE” (pronounce(mo-eh)) and also call 2D girl ,is essential in Manga and Anime because they make reader or audience to get more impression . In commonly, we have seen They attribute is Huge beautiful eye, slim,sexy ,etc. They skill is very wonderful, for example, Magician girls are able to fly without gasoline or jet engine but fly with they wand .They are separated into various kind by their characteristic.
In following Example is kind of Girl
1. Nekomimi --- the girl has got cat ears.
2. lolicon --- very young girl.
3. Maid --- housewife.
4. more than all of above.
more people who addition in Anime or Manga have been fall in love with Manga or Anime girl because they have got advantage more than reality girl.
To get more Anime and Manga girl Details ,you able to visit in following link:
http://www.animenewsnetwork.com/encyclopedia/
http://en.wikipedia.org/wiki/Moe_(slang)
word definition:
Anime means : Japanese animation.
Manga means : Japanese comics.
Wednesday, November 19, 2008
Girl data those will collect to database.
I will collect each Anime or Manga Girl Character data in following:
- Name [Character Name]
- Picture [Character Picture]
- Anime [The animation that character is act]
- Manga [The manga that character is act]
- Role [The role in animation or Manga]
- Characteristics [Habit or Behavior]
- Character Type [ or MOE Type of Character such as Loli--very young girl]
- Creator [Creator Name that create Character]
- Weapon [Weapon or Tools that Character is usually held]
- Partner [Animal or person that usually to follow the Character]
For Example
Name : Shinobu Maehara
Anime:Love Hina
Manga:Love Hina
Role: Middle School student who clean and cook and takes care of most of the chores around the Hinata Inn.
Characteristics: cook excellent ,very shy girl.
Character type : Loli -- very young female.
Creator : Ken Akamatsu.
Weapon : - ,because She is not Magicial girl.
Partner : Kaolla Su.
Reference : http://en.wikipedia.org/wiki/Love_Hina
Name : Kinomoto Sakura
Anime:Card Captor Sakura
Manga:Card Captor Sakura
Role:Clow Card collector and Magicial who transfrom Clow Card into Sakura Card.
Characteristics: extremely energetic and cheerful character.
Character type : Loli -- very young female.
Creator :CLAMP.
Weapon : sealing wand and cards.
Partner : Dainoji Tomoyo ,Keberos.
Reference :http://en.wikipedia.org/wiki/Kinomoto_Sakura
- Name [Character Name]
- Picture [Character Picture]
- Anime [The animation that character is act]
- Manga [The manga that character is act]
- Role [The role in animation or Manga]
- Characteristics [Habit or Behavior]
- Character Type [ or MOE Type of Character such as Loli--very young girl]
- Creator [Creator Name that create Character]
- Weapon [Weapon or Tools that Character is usually held]
- Partner [Animal or person that usually to follow the Character]
For Example
Name : Shinobu Maehara
Anime:Love Hina
Manga:Love Hina
Role: Middle School student who clean and cook and takes care of most of the chores around the Hinata Inn.
Characteristics: cook excellent ,very shy girl.
Character type : Loli -- very young female.
Creator : Ken Akamatsu.
Weapon : - ,because She is not Magicial girl.
Partner : Kaolla Su.
Reference : http://en.wikipedia.org/wiki/Love_Hina
Name : Kinomoto Sakura
Anime:Card Captor Sakura
Manga:Card Captor Sakura
Role:Clow Card collector and Magicial who transfrom Clow Card into Sakura Card.
Characteristics: extremely energetic and cheerful character.
Character type : Loli -- very young female.
Creator :CLAMP.
Weapon : sealing wand and cards.
Partner : Dainoji Tomoyo ,Keberos.
Reference :http://en.wikipedia.org/wiki/Kinomoto_Sakura
Sunday, November 16, 2008
Determine System Envoirments to Develop My Database.
I was determined about my Database environment to develop my database so I found it free ,reliable ,and easier to use it.
In following environment those I will use to develop.
Operating System : I certainly use WINDOWS XP Professonal Service Pack 3 because It very easier to Installing tools ,implement ,and testing.
Development tools :
I will use APPSERV 2.4.9 ,Internet application server pacek is actually "FREE",It combined in following
Apache 2.0.59
PHP 4.4.7
MySQL 5.0.45
phpMyAdmin-2.10.2
Hardware :
PC.
Internet system is essential.
See Also
AppservNetwork
In following environment those I will use to develop.
Operating System : I certainly use WINDOWS XP Professonal Service Pack 3 because It very easier to Installing tools ,implement ,and testing.
Development tools :
I will use APPSERV 2.4.9 ,Internet application server pacek is actually "FREE",It combined in following
Apache 2.0.59
PHP 4.4.7
MySQL 5.0.45
phpMyAdmin-2.10.2
Hardware :
PC.
Internet system is essential.
See Also
AppservNetwork
Saturday, November 15, 2008
Practice: How To Create my Table.
In second week of Database system laboratory is about "Table" in database. Teacher was teach How to create table in own database ,How to view details in your database that created ,How to Use data types in each field. He let me to do lab activity thorough Kubuntu environment and execute database by Oracle9i.
Student had not prepare my table contents so teacher brought his table contents to teach and let student to practice. He contents is Employee, about employee_id ,employee_name ,etc.
To create table we have to using "CREATE TABLE" command ,define each contents--[Field] in different data type ,and define properties such as "PRIMARY KEY".
In following data type and Properties that I was using to create table in my Laboratory :
VARCHAR(character length) --- define field for store set of character in character length.
INT ---Integer --- define field for store Integer number.
Double(point length) --- decimal --- define field for store decimal number in point length.
I want to create my table is contains: department_id(length of character=5),set as primary key and department_name(length of character=50).
In following line that I type to let Oracle 9i execute:
#1 CREATE TABLE departments
#2 (department_id VARCHAR(5) PRIMARY KEY,
#3 department_name VARCHAR(50));
we can using that code in MySQL ,MicrosoftSQL Server ,etc
and when I type desc:departments;
My table contents was display as above figures.
I also practice to create my table with MySQL Database simulation and typing Command thorough phpMyAdmin. I assume phpMyAdmin is helping tools to manage database easier, you may not to type a lot of commands. MySQL and phpMyAdmin are required PHP HTTP server simulator and Apache Web server or Internet Information Service(IIS).
I get more enjoy and experience in my database lab. I'm going to generate my Database Contents and create my Database In my PC. And will present progress In my next time.
See Also
phpMyAdmin
MySQL
Apache Web Server
PHP
(Internet Information Service)IIS
POSTED 15/11/2008 12.09 pm
Student had not prepare my table contents so teacher brought his table contents to teach and let student to practice. He contents is Employee, about employee_id ,employee_name ,etc.
To create table we have to using "CREATE TABLE" command ,define each contents--[Field] in different data type ,and define properties such as "PRIMARY KEY".
In following data type and Properties that I was using to create table in my Laboratory :
VARCHAR(character length) --- define field for store set of character in character length.
INT ---Integer --- define field for store Integer number.
Double(point length) --- decimal --- define field for store decimal number in point length.
I want to create my table is contains: department_id(length of character=5),set as primary key and department_name(length of character=50).
In following line that I type to let Oracle 9i execute:
#1 CREATE TABLE departments
#2 (department_id VARCHAR(5) PRIMARY KEY,
#3 department_name VARCHAR(50));
we can using that code in MySQL ,MicrosoftSQL Server ,etc
and when I type desc:departments;
My table contents was display as above figures.
I also practice to create my table with MySQL Database simulation and typing Command thorough phpMyAdmin. I assume phpMyAdmin is helping tools to manage database easier, you may not to type a lot of commands. MySQL and phpMyAdmin are required PHP HTTP server simulator and Apache Web server or Internet Information Service(IIS).
I get more enjoy and experience in my database lab. I'm going to generate my Database Contents and create my Database In my PC. And will present progress In my next time.
See Also
phpMyAdmin
MySQL
Apache Web Server
PHP
(Internet Information Service)IIS
POSTED 15/11/2008 12.09 pm
Monday, November 10, 2008
Fist Time To Study Database
In the first week my teacher introduce Database class. He tell about what will we learn in this semester and assign me a work such as create blog to report what they learn in each week,
assign me to create or choose what topic or data to build my database? , and tell about class regulation.In participation time , He ask me and my classmate about "DATABASE" I and my classmate answer well.
I think for a long time for choosing data to create my database. I favorite to reading a Manga and see an Anime because character is cute than real world so I choose "Anime and Manga girl Database",It will collect Japanese Animation and Manga girl character data. I will go to check my cabinet[My Manga and Anime stock] to read and see to get data and go to buy more Manga and Anime. I think this work will enjoy for me although DATABASE Subject is not easy. I
expect my database will share and showing my database to other people who make over about Anime and Manga girl.
Labotory time, I will go to Database Lab to study about Kubuntu Linux , OpenOffice.org, Oracle database solution .
My teacher teach me How many kind of Linux that availble in Ubuntu Series. Ubuntu Linux Series are availble in four kind
* Ubuntu -- I think it probably office or Enterprise Linux using GNOME.
* Kubuntu -- I think it probably home and home office using KDE
* Xubuntu -- Linux For Server using XFCE
* Edubuntu -- Linux For Children using GNOME
In first lab Teacher Assistant was teach about Kubuntu Linux. I had run Linux on VMWARE[comercial Virtual Machine Software].After I logon to Kubuntu Linux He was guide about gadget in Kubuntu.After he had finished guide I was enjoyable with Kubuntu.
Teacher assistant also guide me to Oracle Database solution.He teach how to use query command, How to create database worksheet, and tell about advantage about Oracle.
First Lab Assignment ,I was write about My data that I was choose details by using OpenOffice Writer. and saved as *.odt(Open Document Textfile) and *.pdf(Portable document file) and publish them as *.tar and Upload to my University E-learning system.
After First Class finished ,I think student feel Database subject is difficultly but I don't think so. we should study step by step, ask about what we don't understand. and practice frequenly.
difficultly and easy is depend on your mind not depend on subject.
Words Definition
Anime -- [Japanese]Animation.
Manga -- [Japanese]Comics.
reference
Ubuntu -- http://www.ubuntu.com
Kubuntu -- http://www.kubuntu.org
Xubuntu -- http://www.xubuntu.org
Edubuntu -- http:// www.edubuntu.org
Subscribe to:
Comments (Atom)
