Entity Relationship Diagram

9:46 AM

Construct database with entity model relationship is with Entity Relationship Diagram (ERD). In model entity relationship there are three base notations, there are entity sets, relationship sets, and attributes.

This is following symbol of three base notations in entity model relationship.
Entity set -->


Relationship set -->



Attribute -->


There are some terminology is had to understand before construct database with entity model relationship, there are:


  1. Super key

    2. Super key is one or more attribute(s) which can differentiable with data row in table uniquely.
  2. Candidate key

    3. It is number of attributes which can differentiable each data row in table uniquely.
  3. Relation key/Primary key

    4. Value of relation key had to identifying a unique row in a relation. Relation key is involved of one more relation attribute. To be a primary key is an attribute had to complete candidate key objective.
  4. Alternate key

    5. Is nothing in real world, but it is created and being primary key. Alternate key is made when no one attribute in a relation which can be representing that’s relation, or any candidate key but is not effective to be primary key.
  5. Composite key

    6. Is primary key which have more than one attributes.
  6. Foreign key

    7. Is number of attributes in relation then this number of attributes is not relation key but key of another relation.
  7. Cardinality

    8. Is showing number of entity which associated with an another entity with any relationship sets. Cardinality involved:

    • One to one : is one entity associated with maximum one on an entity.

    • On to many: is one entity (A) associated with number of another entity(B), (B) associated with maximum one on (A) entity.

    • Many to many : is number of entity(A) associated with number of entity(B) and number of entity (B) associated with number of entity(A).


Read More...

PHP & MYSQL

4:22 AM

PHP is server side programming language. It can be used to make a powerful and dynamic web. PHP is open source. PHP can be inserted in HTML code. Directly, we go to how to make a database and other database properties with PHP. First you must ensure the server is activated. Here, I use XAMPP (download XAMPP)for my local server. To open your XAMPP you can go to Start menu all programs XAMPP for windows XAMPP control panel. You will see this following picture. After that activate Apache and MySql service with clicking start button in XAMPP Control Panel Application in each service. If services was active there are a running sign beside start button.




Now open your browser. Here, I use Mozilla Firefox(download Mozilla Firefox) . Type “localhost” or “127.0.0.1”. Then you will see a page with orange color. And you can use MySql service by clicking “phpMyAdmin” in XAMPP tools.
You will go to “phpMyAdmin” page. This is the service to allow you to managing databases. And in the left of the page you will see databases already exist.


download connect.php

Attention, because PHP is server side programming you must put you PHP files in your server directory. If you were install XAMPP in drive “C:\Program Files\xampp”. Go to “htdocs” folder, and make a folder named “php”, finally put your php files there. To try this file(s) you type in your browser url http://localhost/php/ and click “connect.php”.


Good luck ^_^


 Read More...

REGISTRY TIPS

7:52 AM

Put Background in Windows Explorer's toolbar

Windows Explorer is usually we use to manage files. Now, I will tell you how to put a customize picture in your windows explorer toobar. First step, picture must be BMP format (*.bmp). Put your picture in your directory, this is where you want. Then go to registry editor, click start menu icon, then click run and type "regedit" (without double quote).





Go to this following location:
HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\Toolbar



In subkey Toolbar create a new value named "BackBitmapShell" (without double quote) and the type is String. You just right-click then new >> String Value. After you choose String Value, type BackBitmapShell then press Enter. Then double click at the string to modify. In value data label, type path bitmap file you wanted to put.



After that try open your windows explorer.




 Read More...

CREATE DATABASE WITH PHP

12:19 PM

PHP can connetct to MySql. It can create database, table,insert,update, and delete record. To create database you can use sintaks in MySql query language. This is following sintaks to create database in MySql query language 'CREATE DATABASE db_trial' (without single quote). But, before we can make database in PHP, we have to connect PHP with MySql first. Connect php to MySql was I publish before, so we can use connect.php to connect our php to MySql. Now we make php file to create a database.This is following file.


download createdb.php

This sintaks will make a database named 'db_trial'and will show sentences about succes or not to make a database, but before it make a database, it need connect.php to comunicate php file with MySql. The sintaks to use other php file is (include 'connect.php';). And $con sintaks mean a connect sintaks which this is in connect.php file. Save your file(s) in your server directory. If you install XAMPP in C:\Program Files\xampp”. Go to “htdocs” folder, and make a folder named “php”, finally put your php files there.
To try this file(s) you type in your browser url http://localhost/php/ and click “createdb.php”. If create database was succesful you will see following picture .






To check your database was made, you can go to your browser, type 'http://localhost/phpmyadmin/'. If database already exist you will see this following picture.


Good luck ^_^

 Read More...

Subscribe to: Posts (Atom)
/*ini ttg amazon*/ /*selese di sini*/