Year 2015, previously, then and now ...

short note: - missed blogging.. yet, here I am! (non-hiatus mode) ********************************************************************************************

I am finally back into blogging! (at least for today)

Looking back at the dates that I've last written a proper blog post (not to mentioned the amount of anonymous bot spams) it is very clearly that I have abandoned my blog and let it rot.. while Google still thinks I'm important by NOT removing anything at all. Thanks Google! I'm much touched.

Basically... time flies way back ever since the last I blogged - lots of events, misfortune, happenings ups and downs that are just too many to list down (they're 99% forgotten by now, heh) So allow me to just reflect on what's going on with my life recently.

Times have totally change when the country that we're living are not showing much prosperous signs around (expenses up, petrol price shrinking, missing fei ji etc) it kinda sums that trying to survive what you got a few years back and what you currently trying to sustain yourselves, while meeting goals, targets is just getting much harder and harder.. A little rant, but I'm sure more than half of the society must be facing some financial problems in trying to get ends meet.

It is not just time that is bringing people into burden..sometimes it is just the people around you, or the kind of friends that you joined with during your adult age. Some up to the point that you have to learn "how to become people" with fake expressions or just being tolerate (maybe it is just me) but... nah, meh, pft..

Oh my..suddenly I lost mood to write longer. Damn, should try to improve myself again one day.

So before I end, I actually wanna share my current resolutions for the year. Short and sweet, here goes!

• lose 5kg
• better handling in finance management
• gain better opportunities in project, team handling management stuffs
• enable extrovert mode more often (while staying humble LOL)
• talk straight, no hiding around

Til then.
 

ECP4136 tut 3 part 1

import java.awt.*;
import javax.swing.*;
import java.util.*;

public class test
{
public static void main (String[] args)
{
JFrame frame = new JFrame ("Funky Panels");
frame.setDefaultCloseOperation (JFrame.EXIT_ON_CLOSE);

ImageIcon icon = new ImageIcon ("Launch.gif");

Random generator = new Random();
float num1, num2, num3;

num1 = generator.nextFloat();
num2 = generator.nextFloat();
num3 = generator.nextFloat();

JLabel label1,label2, label3, label4;

label1 = new JLabel ("Sine(" + num1 + ") = " + Math.sin(num1), SwingConstants.CENTER);
label2 = new JLabel ("Cosine(" + num2 + ") = " + Math.cos(num2),SwingConstants.CENTER);
label3 = new JLabel ("Tangent(" + num3 + ") = " + Math.tan(num3),SwingConstants.CENTER );
label4 = new JLabel (icon, SwingConstants.CENTER);





JPanel subpanel1 = new JPanel();
subpanel1.setPreferredSize (new Dimension (400,100));
// subpanel1.setBackground (Color.green);
subpanel1.add (label1);
subpanel1.add (label2);
subpanel1.add (label3);

JPanel subpanel2 = new JPanel();
subpanel2.setPreferredSize (new Dimension (200,100));
// subpanel2.setBackground (Color.red);
subpanel2.add (label4);


// Set up primary panel
JPanel primary = new JPanel();
primary.setBackground (Color.yellow);
primary.setPreferredSize (new Dimension (800,250));
primary.add (subpanel1);
primary.add (subpanel2);
// primary.add (label3);


frame.getContentPane().add(primary);
frame.pack();
frame.setVisible(true);
}
}

attempt #2 : redesign blog templates

short note:
wat happen to attempt #1? i din save haha, looks ugly anyway~

********************************************************************************************

After trying so many different designs given by Blogger...original one still best =.=!! All their design dun hav tat "feel" i'm looking for, sad~ next time will try other websites and try~ for now I think I'll just leave it alone like tis, quite stressful keep design fail haha.

ECP3076 tut2

1. Key defines entity relationships. Primary key, secondary key, foreign key, superkey, candidate key.
2. …
4. SELECT, PROJECT, JOIN, INTERSECT, UNION, DIFFERENCE, PRODUCT, and DIVIDE, same commands. Note* SLECT in relational algebra only means selecting entities from an entity set, while SELECT in SQL is a command that has much wider use.
5. PRODUCT produces a list of all possible pairs of rows from two tables.
SELECT yields values for all attributes found in a table. It yields a horizontal subset of a table. (command: select * from table1, table 2)
PROJECT produces a list of all values for selected attributes. It yields a vertical subset of a table
6. all joins are implemented with SELECT. The difference is in the WHERE clause. With a natural join, you are always comparing attributes with the same name, using the = comparison
Select * from table1, table2 where table1.t1_ID = table2.t1_ID
An equi join, u use table columns which are permitted to be different, but still with the = comparison
Select * from table1, table2 where t1_ID = t1_ID
A theta join is where the comparison operatior may be some other thing
Select * from table1, table2 where T1_A < T1_B


Section B
b. DIR_NUM
c. 1 to many, no
d. The foreign key must hav a null value or matches primary key values in the PLAY TABLE.
The PLAY table has a foreign key which is the primary key of the DIRECTOR table. Entering data into the PLAY table requires that the foreign key hav a matching value to the PK of the DIRECTOR table. This ensures that a PLAY must be directed by a listed/recorded director in the database else it must be left null (it is possible for a play to exist without a director..)

Part C:
create database test;
connect to test;
create table student1
(
stud_id char(10) not null,
stud_name varchar(50),
stud_hometown varchar(50),
stud_state varchar(50),
stud_religion varchar(50),
stud_birthday date,
primary key (stud_id)
);

insert into student1 values ('1071112489', 'Edwin', 'Batu Berendam', 'Melaka', 'Buddhist', '1989-03-25');
insert into student1 values ('1061111659', 'Adrian', 'Sin Hoe Garden', 'Melaka', 'Buddhist', '1989-07-07');

select * from student1;
select * from student1 where stud_name = 'Edwin';

create table student2
(
stud_id char(10) not null primary key,
stud_name varchar(50),
stud_hometown varchar(50),
stud_state varchar(50),
stud_religion varchar(50),
stud_birthday date
);

ECP3076 tut 1

1. Describe the different ways a DBMS can be classified.
• No of users, locations, expected type and extend of use

2. A relational database differs from network and/or hierarchical databases in what aspect(s)?
- Physical structure closely resembles the logical structure.
- The relational DBMS handles most physical details.

3. Describe the basic features of the relational data model and discuss their importance to the end user as well as the designer.
- The relational data model illustrates end user data as beong stored in tables. Each table is a matrix consisting of a series of row/column intersections. Tables also called relations are related to each other by sharing of a common entity characteristic (value in a column). The relational database is perceived by the user to be a collection of tables in which data are stored. The relational data model allows the designer to focus on how the data components interact rather than on the physical details of how the data are store. The makes much easier to model the complex real world data environment.

4. Explain structural independence and its importance in data management.
- In terms of data management, structural independence means that the way the data is stored will have no effect on the programs that use it. In other words, any changes to the file structure will not effect existing programs that access the data stored within the file structure. File system data management is an example of data structure that does NOT show structural independence – program access is tied tightly with how data is stored. DBMS structures support better structural independence as the user no longer need to know where/what is used to store the data but only how to access it.

a) What problems can you identify with the data file structure shown above? How can they be corrected?
- Table shows data from 2 separate ‘objects’ – projects and managers, results in redundant copies of data which increase occurrence of data anomalies – insertion, deletion and update anomalies. At current structure, multiple copies of same data MUST be created even though real life the relationship does not exist such as:
- 1. A new manager in the company can only be inserted once he/she is assigned a project.
- 2. Projects must have a manager at time of data insertion into the table.
- 3. Other employee data is not listed as project members except the manager.
- 4. If Holly gets married, her last name has to be changed three times (update)
- 5. Information about “William K. Moor” will be lost if his row is deleted. (delete)
- To correct the problems the file structure can be subdivided into simpler files, each representing a single subject – i.e. Normalization.

blog revived soon?

Dear edwinho89...

sry for keeping u idle for so long, i 4got how u used to keep track of all my past posts n memories already...nonetheless i might be coming back soon, with new layouts n templates (since it's getting easier to edit nowadays) brb ya!

sincerely,

totally an shuang