ERD dan Tabel

Contoh ERD dan Tabel untuk rumah sakit :

ERD :

Tabel :

• Pasien
  
• Dokter
  
• Perawat
  
• Petugas Administrasi
  
• Pegawai Pendaftaran
  
• Apotik (kosong)

Contoh Menerjemahkan Tabel menjadi ERD

Tabel :

Menjadi :

Prospektus PT Smartfren Telecom, Tbk.

PT Smartfren Telecom, Tbk.

• Nature of Business :

The Company is a telephone service and wireless data operator in the telecommunication market of Indonesia. With its CDMA technology base, the Company is competing by offering a variety of products to reach a market share that enables the Company to operate as a going concern

•  Activity of Business :

a.  Offer telecommunication services in the Republic of Indonesia;

b.  Provide multimedia products and related services, including but not limited to direct and indirect sales of voice services, data/image and mobile commercial services;

c.  Develop, lease and own a wireless telecommunications network in 800 MHZ band based exclusively on Code Division Multiple Access (CDMA) technology, specifically CDMA 2000 1X and 1X EVDO technology;

d.  Trading telecommunication goods, equipment and/or products, including but not limited to import of such telecommunication goods, equipment and/or products;

e.  Distribute and sell telecommunication goods, equipment and/or products;

f.  Provide after sales services for telecommunication goods, equipment and/or products.

• Stakeholder :

The Ownership Structure of the Company Share as of 31 December 2010 is as follows:

          o Jerash Investment Ltd - 15,6% 

          o United Investments Limited - 10,76% 

          o Corporate United Investment Limited - 9,76% 

          o ETrading Securities, PT - 9.22% 

          o Masyarakat / Public - 55,16%

• Business Function :

• Corporate Governance :

o   Board of Commissioners :

The duties of the Board of Commissioners (BOC) includes two main parts: supervising the management of the Company by the Board of Directors and providing advice to the Board of Directors in terms of the effectivity of the Board of Directors’ decision-making and the execution of strategies. The duties are explained more comprehensively in the Company's Articles of Association.

Periodically, the Board of Commissioners met with the Board of Directors to receive a progress report on operational activities and the ongoing restructuring. During the year 2010 the Board of Commissioners has held 3 (three) meetings.

o   Board of Directors :

The Company's Board of Directors consists of five directors, including the President Director and four Directors. The Board of Directors (BOD) is responsible for the management of the Company in compliance with rules and regulations and inline with the Company's objectives. The Directors represent the Company in all activities of the BOD, both with internal parties and external parties.

o   Audit Committee :

The Audit Committee participates in the selection and appointment of the public accountant, reviews the internal and external audit plans and reports, reports to the Board of Commissioners issues that are related to the quality and integrity of the Company's financial reports, identifies issues that require attention of the BOC, responds to questions of the members of the BOC, and provides independent opinions about the Company's compliance towards internal procedures, as well as applicable laws and regulations.

o   Remuneration Committee :

This committee has the duty and responsibility of defining the amount of remunerations for the commissioners, directors, Vice Presidents and senior managers. Currently, the function and role of the Remuneration Committee is fulfilled by the Board of Commissioners, so that the amount of remunerations for members of the Board of Directors are stated by the Board of Commissioners, while the honorarium of members of the BOC are stated in a BOC meetings.

o   Internal Meetings :

The following table presents the frequency of BOC Meetings, BOD Meetings, and Audit Committee Meetings in 2010 as well as the attendance of each Commissioner, Director, and Audit Committee Member.

o   Internal Audit :

The main function of the Internal Audit unit is to review on the effectivity and the feasibility of the Company's internal control system, particularly to safeguard the assets and the records of the Company, to ensure the reliability of the financial and operational information, and the compliance towards the policies and regulations of the Company.

The Internal Audit functions also ensure the compliance towards existing applicable laws and regulations. Issues that emerge have to be identified, analyzed and communicated regularly to the Audit Committee and the Board of Directors. The Internal Auditor also monitors and updates to ensure that all improvement recommendations have been implemented. In fulfilling its function, the Internal Audit unit implements risk-based auditing approach to enhance cost efficiency and strengthen internal control in the higher risk areas.

o   Internal Control :

In the designing and implementing the Internal Control System, the Internal Audit unit refers to the standards developed by COSO (the Committee of Sponsoring Organizations of the Treadway Commission).

o   Corporate Secretary :

The Corporate Secretary is responsible for the Company's compliance, ensuring that the Company complies with existing rules and regulations of the capital market. The Corporate Secretary also manages the distribution of information to the Company's stakeholders in a timely manner.

·         Process Management Business :

1.       The national telecommunication industry of Indonesia features many players which shaped a very high competition level in the sales activities of the Company's products to the customers. To anticipate the condition, the Company has engaged in a synergy with PT Smart Telecom in the form of creating the shared brand of “Smartfren”. Other synergies include the synergy of distribution and marketing activities. From this synergy the Company expects several benefits, including among others operational cost and capex efficiency and the acquisition of a larger market share. In addition, Mobile-8 will continuously introduce new innovative products, services or features, with competitive price levels; also continue the handset bundling program with various types, both candy bar and qwerty. Furthermore, the Company also continues variations of the Fren Duo hybrid product in the form of Fren Jos that offers various bonuses. In the mobile product, the Company has also launched 2 high-speed modems that equal to 3.5G technology to the customers.

2.       The Company's and its subsidiary's financial instruments are prone to to the risk of interest rates, the risk of foreign currency exchange rates, the equity risk, the credit risk and the liquidity risk. The policy of managing these risks has improved significantly by taking into account several parameters of change and the volatility of financial markets, both in Indonesia and internationally. The Board of Directors of the Company has analyzed and approved the risk policy, which comprises risk tolerance in the strategy of managing risks as has been elaborated in the Notes on the Consolidated Financial Statements for the period ended 31 December 2010.

3.       Mobile-8 is operating with the CDMA technology amidst the more popular GSM technology, so that there is the risk of technology change that may impact the business activities of Mobile-8. Furthermore, Mobile-8 also faces competition from the  ntroduction of the WiMax technology, whose licenses have been awarded by the Government to several companies. In the effort to anticipate this development, Mobile-8 continuously follows the development of the CDMA technology by applying the CDMA 1X EVDO Rev. A technology, which is equal to 3.5G technology.

source : http://www.smartfren.com and from various source

by : Yogi Nur Zakaria - 0610u057

Membuat Animasi Actionscript Flash

Di sini saya akan menjelaskan tentang membuat animasi menggunakan ActionScript 3.0 dengan adobe flash cs4.

sebenarnya yang mau diposting bukan yang ini, tapi gara-gara filenya kehapus, jadi aja animasi yang ini deh.
Kita akan membuat animasi seperti ini :

biar gaul,(dan bahasa inggrisnya bagus) tutorialnya pake bahasa inggris aja yah, kalo rada susah ngartinnya ya ada google translate lah.
hhe
kalo mau donlot filenya,di sini

Step 1: Brief Overview

We’ll create a Class that will take care of the whole effect. When you call the class, you’ll be able to change the number of lights, color, alpha, size, direction, speed and the quality of the Blur filter. In this way it’s possible to achieve many different results when using it. Also, you can use any background you want.

Step 2: The .fla Document

Create a new ActionScript 3.0 document (File > New…). Set the Stage size to your desired dimensions, I’ve used 600 x 300 px.

Step 3: Your Background

Add or draw an image to use as the background, I’ve used a simple blue gradient (#02C7FB, #1F63B4).

Step 4: Layers

Rename the first layer to “Background” then create another one and name it “Code”. You can lock the “Code” layer to avoid placement of unwanted drawings in there.

Step 5: ActionScript

Save your work and let’s get into the code!

I’m assuming you already have a basic understanding of ActionScript 3.0, if you have any keyword specific doubts please refer to the Flash Help (F1).

Create a new ActionScript file (File > New…).

Step 6: Importing Required Classes

package Classes
    {
/* Import required classes */
 
    import flash.display.MovieClip;
    import flash.filters.BitmapFilter;
    import flash.filters.BlurFilter;
    import flash.events.Event;

Here we import the Classes that we’ll use, remember that the word next to “package” is the name of the folder where our Class is located.

Step 7: Extending the Class

//We need to extend the class so we can use the addChild() method.
 
  public class Lights extends MovieClip
{

Extending the MovieClip class will allow our class to inherit all of the methods, properties and functions that the MovieClip has, in this case we use it to get access to the addChild() method.

Step 8: The Variables

Although they have pretty much self explanatory names I’ll add short comments on each var to make sure it’s clear. They get their values from the parameters of the Main function.

private var lightsNumber:int; //The number of Lights on Stage
private var xSpeed:int; //The horizontal speed the Lights have
private var ySpeed:int; //Vertical Speed
private var lightsDir:String; //Direction the Lights are going, this can be Up, Down, Left or Right
private var areaW:int; //The width of the area where the effect will take place
private var areaH:int; //Height
private var lights:Array = new Array(); //This array will store all the Lights MovieClips so we can use them outside the For where we are going to create them.

Step 9: Main Function

/* Main function */
 
    public function init(areaWidth:int, areaHeight:int, numberOfLights:int, lightSize:int, lightColor:uint, minimumScale:Number, hSpeed:int, vSpeed:int, dir:String, quality:int):void
    {
 
    areaW = areaWidth;
    areaH = areaHeight;
    lightsNumber = numberOfLights;
    lightsDir = dir;

This is the function that we need to start the effect, we also set the variable values in this code.

Step 10: Creating the Lights

for (var i:int = 0; i < numberOfLights; i++)
{
/* Create the specified number of lights */
 
   var light:MovieClip = new MovieClip();
 
   /* Set random speed to x and y based on the params */
 
   xSpeed = Math.floor((Math.random() * (hSpeed - -hSpeed + 1)) + -hSpeed);
    ySpeed = Math.round((Math.random() * vSpeed) + 0.5);
 
   light.xSpeed = xSpeed;
    light.ySpeed = ySpeed;
 
    /* Create lights */
 
    light.graphics.beginFill(lightColor);
    light.graphics.drawCircle(0, 0, lightSize / 2);
    light.graphics.endFill();

In this code we use a “For” statement to create the number of Lights the user sets in the parameter and calculate a semi-random speed for every Light.

Step 11: Position

This sets a random start position for the Lights based on the Area parameters.

light.x = Math.floor(Math.random() * areaWidth);
light.y = Math.floor(Math.random() * areaHeight);

Step 12: Blur Filter

var b:int = Math.floor(Math.random() * 10) + 5; //Calculates a random Blur between 0-9 and adds 5 to the result.
 
   var blur:BitmapFilter = new BlurFilter(b,b,quality); //The BlurFilter object.
 
   var filterArray:Array = new Array(blur); //To apply the filter we need an array of filters.
 
   light.filters = filterArray; //Sets the filters array to the Light

The above code applies the Blur. Remember that this code is still part of the For, so the Lights get different Blurs.

Step 13: Alpha

light.alpha = Math.random() * 0.6 + 0.1;

An easy one; this sets the alpha property between 0.1 and 0.6.

Step 14: Scale

light.scaleX = Math.round(((Math.random() * (1-minimumScale)) + minimumScale) * 100) / 100;
light.scaleY = light.scaleX;

This sets the scale of the Lights between the original size and the minimum scale parameter. We use a round method to save processor.

Step 15: Adding the Lights to the Stage

addChild(light);
 
/* Store lights in an array to use it later */
 
lights.push(light);
 
/* Check for lights direction */
 
checkDirection();

This adds the Lights to the Stage, then we save them in an Array to use them later. It also the checkDirection function to see in which direction the Lights will go.

Step 16: Check Direction Function

private function checkDirection():void
{
for (var i:int = 0; i < lights.length; i++)
{
switch ( lightsDir )
{
case "up" :
 
   lights[i].addEventListener(Event.ENTER_FRAME, moveUp);
 
   break;
    case "down" :
 
   lights[i].addEventListener(Event.ENTER_FRAME, moveDown);
 
   break;
    case "right" :
 
   lights[i].addEventListener(Event.ENTER_FRAME, moveRight);
 
   break;
    case "left" :
 
   lights[i].addEventListener(Event.ENTER_FRAME, moveLeft);
 
   break;
    default :
    trace("Invalid Direction!");
    }
    }
    }

Here we use a for to get access to all the Lights in the Array, then check the direction variable to determine where to move the Lights. Depending on the direction we add the listener to the corresponding function.

Step 17: Move Functions

This next section may seem a little complicated, but it’s easier than you think. Basically, it moves the Light depending on the speed calculated in the Main function, then checks if the Light has “left” the Area of the effect. If that is the case, it sets a random position contrary to the direction the Light is heading.

private function moveUp(e:Event):void
  {
  e.target.x += e.target.xSpeed;
  e.target.y-=e.target.ySpeed;
   /* Reset light position, Y first, then X  */
 
   if (e.target.y + (e.target.height / 2) < 0)
    {
    e.target.y = areaH + (e.target.height / 2);
    e.target.x=Math.floor(Math.random()*areaW);
    }
   if ((e.target.x + e.target.width / 2) < 0 || (e.target.x - e.target.width / 2) > areaW)
    {
    e.target.y = areaH + (e.target.height / 2);
    e.target.x=Math.floor(Math.random()*areaW);
    }
    }
   /* Move Down function */
 
   private function moveDown(e:Event):void
    {
    e.target.x+=e.target.xSpeed;
    e.target.y+=e.target.ySpeed;
   /* Reset light position, Y first, then X */
 
   if (e.target.y - (e.target.height / 2) > areaH)
    {
    e.target.y = 0 - (e.target.height / 2);
    e.target.x=Math.floor(Math.random()*areaW);
    }
   if ((e.target.x + e.target.width / 2) < 0 || (e.target.x - e.target.width / 2) > areaW)
    {
    e.target.y = areaH + (e.target.height / 2);
    e.target.x=Math.floor(Math.random()*areaW);
    }
    }
 
  /* Move Right function */
   private function moveRight(e:Event):void
    {
    e.target.x+=e.target.ySpeed;
    e.target.y+=e.target.xSpeed;
 
   /* Reset light position, Y first, then X */
   if (e.target.y - (e.target.height / 2) > areaH || e.target.y + (e.target.height / 2) < 0)
    {
    e.target.x = 0 - (e.target.height / 2);
    e.target.y = Math.floor(Math.random()*areaH);
    }
 
   if ((e.target.x - e.target.width / 2) > areaW)
    {
    e.target.x = 0 - (e.target.height / 2);
    e.target.y = Math.floor(Math.random()*areaW);
    }
    }
   /* Move Left function */
 
   private function moveLeft(e:Event):void
    {
    e.target.x-=e.target.ySpeed;
    e.target.y-=e.target.xSpeed;
   /* Reset light position, Y first, then X */
 
   if (e.target.y - (e.target.height / 2) > areaH || e.target.y + (e.target.height / 2) < 0)
    {
    e.target.x = areaW + (e.target.width / 2);
    e.target.y=Math.floor(Math.random()*areaH);
    }
 
   if ((e.target.x + e.target.width / 2) < 0)
    {
    e.target.x = areaW + (e.target.width / 2);
    e.target.y=Math.floor(Math.random()*areaW);
    }
    }
    }
    }

Step 18: Calling the Function

Save your class (remember that the file has to have the same name as the Class) and let’s get back to the Fla. Open the Actions Panel and write:

import Classes.Lights;
 
  var light:Lights = new Lights();
 
  light.init(600, 300, 40, 60, 0xFFFFFF, 0.3, 3, 3, "up", 2);
 
  addChild(light);

That’s it! Test your movie!

Conclusion

Playing with the parameters in the class will result in a lot of different effects, try changing the background, set slower or faster speeds, use more Lights, less Blur and so on!

I hope you learned something you can use, thanks for reading!

donlot filenya di sini