Our database system won't useful and function, If without application. The Application is database querying, is able to put data for managing, viewing, and store data to database system.
We are able to develop the application in various platform such as C/C++, Java, ASP, etc.. . Each
platforms is different database querying command such as JAVA has JDBC ,but they are implement SQL command such as INSERT, UPDATE, DELETE.
My mini-project application has been developed in PHP Platform, Web application,is require Apache and web browser for execute.The platform is database supported and it is OPEN-SOURCE platform.I implement MySQL for my database. The core of my mini-project is data querying,INSERT, UPDATE, DELETE ,they are essential. I have develop with others language are HTML and JavaScript. I have develop in OOP concept because it is easy to maintain.The entities in my database is Class in PHP so fine-grained of code is decresed and easy to query in entities table in my database. I have to implement SQL in any section such as viewing.
Sometimes, I have trouble in development. Coding is not meet requirement because SQL is
useless in sometime, can't querying data thorough application when I test in Unit testing. The
trouble may caused by environment such as Apache is hanging or Operating system problems.
I also have developed other functional of the application and decorate my Application.
I do 85% for coding in PHP because I can't select suitable PHP IDE for me.Although I use
Netbeans, It is trouble. I think coding in dreamweaver is easy because I can see web application
appearence.
I will develop remain module in PHP language. I expect my knowledge about web development
will improved.
Saturday, February 28, 2009
Wednesday, February 25, 2009
Is normalization necessary or not?
Normalization is one of process in database design. It separate complexs table in ER-Diagram into several table by consider field dependence and break down table for make each field is independent.
It step are 1NF --> 2 NF -->3NF -->BCNF-->4NF-->5NF. The end point or last step of normalization are depend on type of database or on business, largely, the last step is BCNF. Many to Many relationships between table are not appropriate because It would make maintenance and expand database difficultly ,and data anomaly will occurred. It is make every table in relationship is One to many or Many to Many, so It will help to prevent data anomaly. It usually perfrom for optimize transaction table in database.
Normalization is very good to optimize table, but It is not appropriate in any type of database such simple data collection ,etc. If we design database table well, we won't to normalize table. I think ,we usually normalize database when we need to change database structure in our business. It may not improve database and application efficiency, so to improve database and application efficiency, Denormalization is one way to do it.Although we able to normalize but DATA ANOMALY is not vanished.
IN MY MINI-PROJECT ... NORMALIZATION IS NOT NECESSARY.
I am sure in my database design, because my mini-project will collect simple girl(MOE) information . girls in my database are don't have to bill or other transaction information. My database is collect only entity type of database. I had normalize my database at once,but result is very bad, because fine-grained normalized database is very complexily.
It step are 1NF --> 2 NF -->3NF -->BCNF-->4NF-->5NF. The end point or last step of normalization are depend on type of database or on business, largely, the last step is BCNF. Many to Many relationships between table are not appropriate because It would make maintenance and expand database difficultly ,and data anomaly will occurred. It is make every table in relationship is One to many or Many to Many, so It will help to prevent data anomaly. It usually perfrom for optimize transaction table in database.
Normalization is very good to optimize table, but It is not appropriate in any type of database such simple data collection ,etc. If we design database table well, we won't to normalize table. I think ,we usually normalize database when we need to change database structure in our business. It may not improve database and application efficiency, so to improve database and application efficiency, Denormalization is one way to do it.Although we able to normalize but DATA ANOMALY is not vanished.
IN MY MINI-PROJECT ... NORMALIZATION IS NOT NECESSARY.
I am sure in my database design, because my mini-project will collect simple girl(MOE) information . girls in my database are don't have to bill or other transaction information. My database is collect only entity type of database. I had normalize my database at once,but result is very bad, because fine-grained normalized database is very complexily.
Tuesday, December 30, 2008
Correcting Diagram and Deploy database
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.
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.
Subscribe to:
Comments (Atom)
