UTS SBD

PG 15 soal
Essay 3soal (1soal ada a dan b ) --> alias 6 soal
Kasus 3soal (1soal a dan b juga ) --> alias 6 soal

soal nya udah agak lupa, tp kurang lebih gini...

PG :
Karakteristik dari file-based :

• Data terpisah - pisah dan terisolasi (separation and isolation of data)
• Duplikasi data (duplication of data)
• Ketergantungan data (data dependence)
• Ketidaksesuaian format file (incompatible file formats)
• Program aplikasi dengan query/pengembangan yang terbatas (fixed queris/proliferation of applocation programs)

Yang termasuk komponen DBMS

• hardware
• software
• data
• procedures
• human

Essay :
Jelaskan dan berikan contoh tentang :

• Selection
• Projection

Jelaskan dengan singkat apa yg dimaksud dengan :

• Candidate key
• Foreign key / Primary key
  

Jelaskan perbedaan antara level eksternal dan level konseptual !

Jelaskan apa yang dimaksud dengan entity integrity dan referential integrity !

Kasus :
ada beberapa table...
1. tampilkan field2 tertentu dengan beberapa syarat... menghubungkan 2 table
2. delete table
3. insert data
4. alter

Iron and Wine_Flightless Bird, American Mouth

Iron & Wine
Flightless Bird, American Mouth

http://www.indowebster.com/iron_and_wineflightless_bird_american_mouth.html

I was a quick wet boy, diving too deep for coins
All of your street light eyes wide on my plastic toys
Then when the cops closed the fair, I cut my long baby hair
Stole me a dog-eared map and called for you everywhere

Have I found you
Flightless bird, jealous, weeping or lost you, american mouth
Big pill looming

Now I'm a fat house cat
Nursing my sore blunt tongue
Watching the warm poison rats curl through the wide fence cracks
Pissing on magazine photos
Those fishing lures thrown in the cold
And clean blood of Christ mountain stream

Have I found you
Flightless bird, grounded, bleeding or lost you, american mouth
Big pill stuck going down

Breaking Dawn [Stephenie Meyer]

Breaking Dawn

Stephenie Meyer

published 2008 - - - 754 pages

Summary (from the book jacket)

To be irrevocably in love with a vampire is both a fantasy and a nightmare woven into a dangerously heightened reality for Bella Swan. Pulled in one direction by her intense passion for Edward Cullen, and in another by her profound connection to werewolf Jacob Black, she has endured a tumultuous year of temptation, loss and strife to reach the ultimate turning point. Her imminent choice, to either join the dark but seductive world of immortals or pursue a fully human life, has become the thread from which the fate of two tribes hangs.

Now that Bella has made her decision, a startling chain of unprecedented events is about to unfold with potentially devastating and unfathomable consequences. Just when the frayed strands of Bella’s life – first discovered in Twilight, then scattered and torn in New Moon and Eclipse – seem ready to heal and knit together, could they be destroyed… forever?

The Review

Breaking Dawn is the fourth and final novel in Stephenie Meyer’s hugely popular Twilight saga. With all the hype surrounding the release of Breaking Dawn I doubt that there is anyone left on the planet that isn’t aware of the books publication! However, readers who haven’t read any of the previous books in this saga should not be tempted to start here – you really need to read these books in order since the story continues over the series.

For readers who have read Stephenie Meyer’s previous offerings Breaking Dawn is the long awaited and highly anticipated end to the compelling tale of vampire Edward and human Bella’s impossible romance. Beginnings can be tricky but Twilight got this series off to a fantastic start with its modern day fairy tale quality and heart stopping romance. New Moon further built on that with Bella and Edward’s bleakly painful separation and subsequent happy reunion - but since the end of New Moon the romantic tension that had been driving the story into the heady heights compelling reading has been lacking.

As a result Eclipse was a different novel – it was clear that what ever happened in Eclipse Edward and Bella would be together forever – and the stresses on their relationship came from outside forces rather than from within the relationship itself. Breaking Dawn is similar. The romantic tension between Edward and Bella is non-existent – it is clear that whatever happens to them (death, Jacob, mutant vampire baby) their love is non-negotiable and to a certain extent this alters the feel of the story, losing some of the romantic magic of Twilight in the process.

If beginnings are tricky, endings are fraught with difficulties. At the beginning readers have no expectations but by the end everyone seems to have an opinion on how they would have finished the book if they were writing it. Thankfully Stephenie Meyer was writing the ending so the resulting story is a good one and in my opinion a fitting end to this fantastic series.

In Breaking Dawn Stephenie Meyer addresses one of the major issues that some readers had with Bella’s character – namely that she wasn’t independent enough. This novel sees Bella coming into her own power and proving that she is more that capable of independent thought and action. While the Cullen family vampires have always been kind to Bella, it has been clear that she was no match for this talented bunch - but Bella’s character gains strengths that make her just as unique and talented as the rest of her new family.

Breaking Dawn is a weighty novel, weighing in at over 750 pages but it doesn’t feel like a long read. The story is well paced and well balanced, with a mixture of exciting supernatural action as well as good character development and romance. The strength of Stephenie Meyer’s writing as ever lies in her exploration of love in its many guises and Breaking Dawn gives her the opportunity to examine the relationships between mother and child, father and daughter, husband and wife and the bonds of friendship.

Breaking Dawn is a different novel to Twilight (and New Moon) and some readers may be disappointed by this but I’m not one of them. I don’t want to keep buying the same story over and over again just with a different title and cover picture – I enjoy seeing the development of the characters as well as seeing the development of the author’s writing. Breaking Dawn is more like Eclipse, Edward and Bella are sure of their love for each other but outside forces (this time it’s the Volturi) may tear them apart as the story reaches its thrilling climax.

The only small gripe I have about this novel is that in wrapping up the story every loose end has been neatly tied into a pretty bow - sometimes it’s good to leave something dangling in the breeze! Oh, and I don’t like the book's cover either. But apart from that, this book is all that I was personally hoping it would be.

dojob CHALLENGE MISSION : PARIS

kalau udh memenuhi syarat awal, kalian masuk ke sini...
















do job...
hati2 sama job heat meter..







nanti bakal ada warning nya kog... warningnya kayak gini...















selain itu 24jam 1x kalian bs dapet paris maps (*selain dr dojob and roobing)

CHALLENGE MISSION : PARIS

nah ga lupa kan post yg Paris ?
nah skr ada challenge missionnya... yaitu steal the mona lisa . . .

we will see this message box . . .















coz i can't wait any longer . . . hha ~
so i decide to buy it with 20GF . . . so expensive . . .
but i have it, so why not . . .
(*now i hv to start collect GF again) lol
and then u'll see this . . .










nah paris' map bs d dapet bukan cuma dr roobing, do job, or something like that . . .
u also can wait it . . . and klik it when it's ready . . .

call for backup

apa yg kalian lakukan kalo xp sudah mendekati full (*alias udh mw naik level) tp energy udh abis dan ga bs d pake sama sekali ??

deng deeeeng . . .

yuup betul sekali . . .
pasti pada memanfaatkan stamina . . .
cara memanfaatkannya c bisa macem2 . . . ada yg d pake buat fight, ada yg d pake buat roobing (*fitur baru dr newyork <-- ga baru baru jg c) yang belom pernah roobing ? hellooo . . . ngapain kalian fight fight (*kecuali ngejer achivement di cuba yah <-- like me) . . . selain ngabisin stamina, itu jg nguras ur health . . . so kalo udh masuk hospital krn health tdk mencukupi buat fight . . . pasti pada heal ur character . . . it's spend ur money . . . dan ga sedikit lg, secara kalo health abis sampe ga bs d pake buat fight brarti butuh banyak buat heal nya . . . nah mendingan beralih dh ke roobing . . . suer ga ngurangin health . . . selain itu bs dapet barang yg cuma di drop dari roobing. . . (lihat inventory mafia kalian atau http://cha35.blogspot.com/2010/04/c-o-l-l-e-c-t-i-o-n-p-r-t-1.html) hha ~ nah skr ada fitur baru dr roobing . . . kalian bisa call for backup . . . terutama buat yg robbery failed . . .






nah buat yg masih pada bingung soal roobing + call for backup . . .
gw jelasin dh ^^

pertama :
buka mafia kalian -> newyork -> fight -> roobing
(*ingat yah roobing cuma ada di newyork)

kedua :
pilih yg mana yg kalian mw roobing (*saran saya c semua nya ajah, secara walau failed, ttp dpt xp kog )



klik "Rob"





kalau kalian menang :














kalau kalian kalah :













nah kalau kalian kalah ada pilihan "call for backup"
di klik ajah . . .
kalau kalian klik, kalian harus memastikan kalian punya stamina yg diminta pas awal . . .
udh gt harus liat stok call kalian . . .
stok nya bs diliat di kanan atas

nah kalau yg udh abis bs ask mafia nh . . .
stiap kali kalian klik "call for backup" stok call kalian berkurang 1 . . .
pas awal2 kalian disediain 5x buat call . . . selanjutnya ask ur mafia ^^


gitu deeee ^^

oh ia di roobing ini ada levelnya lhooo . . .



nah cuma gw ga tw brapa x kalian roob / brapa kali kalian win baru bs nambah . . .
soalnya ga merhatiin


trus kalau kalian udh roob semua yg tersedia kalian bs free ganti target . . .










nah tp kalau kalian blm rob semua yg tersedia, kalian jg bs ganti target, tp ada biaya nya . . . biayanya dalam stamina, contohnya :



jadi kalau saran dari aku sih rob semua dl ajah . . .
secara kalo kalah jg dapet xp . . .
xp nya jg lumayan koog

yuuum yuuum ~

Paris -Limited Time Only-

Paris will open coming soon

nah biar bs ke paris, kalian harus cari peta nya . . .
caranya . . .



kalo hari ini buka MW, pasti lsg dapet pesan kayak gini . . .
soalnya kemaren c masih belom, emang kayaknya baru buka hr ini









kalau kalian klik "continue" maka kalian pindah ke sini . . .
kalian d suruh add mafia, biar mafia nya nambah . . .






jumlah mafia yg diminta ga sama . . .
kurang lebih mrk minta tambah 1 dr jumlah mafia kalian yg skr . .
cth : my Mafia kalian 41, mrk pasti kasih note "You need 42 people in your mafia"
kalau Mafia kalian 249, mrk kasih note "You need 250 people in your mafia"
kurang lebih sih gitu . . .
nanti kalian bs klik "add crew" trus tampilannya berubah jd kyak gini

















nah tp buat yg ngerasa punya banyak GF (*God Father) ga usah tggu terlalu lamaa . . .
kalian bs beli pake GF . . .

di tampilan sebelum ini kalian jgn klik "add crew" tp pilih "buy"
jadi . . .
Can't Wait ?
gain access to Paris now for 20GF Reward Points by buying 10 hired guns . . .

soo . . . selamat mencobaa ^^

Westlife's Shane 'Flies without Wings' for charity

When Westlife's Shane Filan's name is mentioned, an image of brilliant concerts in front of screaming fans comes to mind coupled with dazzling stagecraft, DVD's and multi-million sales of CDs.

However recently the Sligo star took to a different stage, this time the footlights were replaced by floodlights, gladrags replaced by football kit as Shane, 'Against All Odds', proudly took his team onto the hallowed Sligo Rover's Showgrounds to help raise much-needed funds for the Irish Red Cross.

The challenge game between Sligo Rovers and a Shane Filan X1 was a great success with hundreds of fans turning up to support their teams. Over €4k was raised on the evening.

Two Sligo girls, Hillary Jones and Leslie-Ann Culkin persuaded Shane, an keen footballer, who, when at home, turns out for his local team every week, to support their fund-raising activity which has seen them already depart this week to take part in The Platinum Peak Challenge trek up Africa's majestic peak, Mount Kilimanjaro to help fundraise for the Irish Red Cross 70th anniversary.

The Irish Red Cross is part of the world's largest humanitarian aid organization with 97 million volunteers in 186 countries who are on the ground at every natural disaster and conflict zone, bringing life-saving aid to people in desperate need.

In the end, like his 'day job', Shane's team proved too good for the opposition with their 'All Or Nothing' attitude and defeated the Sligo Rover's team with style. The Rover's team looked to the Referee pleading 'Don't Say It's Too Late', but the whistle was blown at the 3-1 final score.

Fans are hoping that Rovers will want to 'Try Again' for a return match and had to be consoled with the comment, 'Nothing Is Impossible'.

before westlife = westside, before westside = io you

The story begins a long long time ago (well, not quite, but.. y'know...!) in a town named Sligo in the West of Ireland. Three guys named Kian Egan, Mark Feehily and Shane Filan had performed in the school musical Grease together, and after their success on stage, had decided to form a band, called 6 as 1, and later changing their name to IOYOU.

<-- mark, kian, shane, derek, graham, michael

The group released a single "Together Girl Forever" in Ireland, and after limited success, Shane's mother, Mae, contacted the manager of Boyzone, Louis Walsh, to try and persuade him to take a look at the guys and to possibly sign them up. Although Louis was impressed he felt he didn't have the time to manage yet another band. But...luckily for us... he contacted Ronan Keating of Boyzone, who agreed to co-manage the new band with Louis. And so 'Rolo Management' was formed.

<--- westlife with their manager Louis Walsh















<-- westlife with ronan keating

The lineup of IOYOU was changed - 3 members (Derek, Graham and Michael) being asked to leave, and auditions were then held in Dublin to find two new members for the group. Nicky Byrne and Bryan McFadden were eventually chosen...Westlife were born!

<--- The first UK Magazine article featuring the lads - Boyzone Magazine September 1998 - when they were still known as IOYOU

The group (who were originally known as Westside - their name having been changed by Ronan who felt that I.O.YOU was too boyband-esque) first supported the Backstreet Boys in Dublin, and then toured the UK and Ireland with Boyzone in November 1998. They stunned audiences on the Smash Hits Tour around the UK, winning "Best New Tour Act" at the Smash Hits Awards in November 1998.

However, the group were obliged to change their name from Westside to Westlife early in 1999 when it was discovered that a number of existing bands shared the same name. Undeterred, Westlife went on to release their first single Swear it Again in April 1999 which went straight to the top of the British and Irish charts, becoming the biggest-selling debut single ever in Ireland.

Westlife's eagerly-awaited debut album was released in the UK in November 1999, with double A-side single I Have a Dream and Seasons in the Sun becoming the UK Christmas number one of 1999. Westlife won Record of the Year for Flying Without Wings in 1999 and My Love in the following year.

Winning numerous awards left right and centre, it is clear that Westlife have achieved much acclaim and enjoyed a lot of success. Already in their brief career Westlife have broken records as fast as they have set them - their second album, Coast To Coast went triple platinum in Ireland after only one day of release, and their seventh single release, My Love, gave them a place in chart history as they became the only band in UK chart history to have their first seven singles debut at number one.

2002 saw the group release their first Greatest Hits album, and Westlife's subsequent album, Turnaround, released November 2003, continued Westlife's success, going straight into the charts at number one.

March 2004 saw a new chapter begin for the group as Bryan McFadden announced his departure from the band, citing his desire to spend more time with his young family. Rumours suggested that this might be the beginning of the end for the group, however Westlife have set the critics wrong once again.

Westlife - now a four-piece in the tradition of all great pop acts - remain Ireland's most well-known and biggest selling pop export and undoubtedly one of the world's biggest pop groups. As of October 2007, Westlife have released eight albums, and have achieved a massive fourteen number ones in the UK - the third-highest such total in UK history, behind Elvis Presley and The Beatles, and tied with Cliff Richard.

With soulful harmonies, angelic voices, drop-dead good looks, and the management of pop svengali Louis Walsh behind them, their much-anticipated world tour in 2008 means that Westlife look set to enjoy chart success for many years to come!

the story of westlife

Westlife is an Irish pop group formed on 3 July 1998. The group's original lineup comprised Mark Feehily, Shane Filan, Kian Egan, Nicky Byrne and Brian McFadden, who left in 2004. Though none of Westlife's members play an instrument full-time, Egan plays guitar on stage, and Byrne has been seen to play drums. Filan and Feehily sing lead vocals. Egan also is seen playing the piano in the videoclip to the song Angel.

The group is the only act in UK history to have their first seven singles go straight to Number 1, and they have gone on to sell over 43 million records worldwide^[1] which includes their studio, single, video, and compilation albums.^[2][3] Despite the group's worldwide success, they've only had one U.S. hit on the Billboard Hot 100 charts: "Swear It Again," which made it to #20 in 2000.

Westlife were originally signed by Simon Cowell and are currently managed by Louis Walsh. In 2008, they were declared as Ireland's ninth-richest celebrities under 30 years old and 13th in general with 36 million euros as a group.^[4] In 2009, they dropped as 16th richest Irish with estimated 8 million euros each.^[5] They garnered 14 number one singles in the United Kingdom, the third-highest in UK history, tying with Cliff Richard and trailing behind only Elvis Presley and The Beatles. The group has also broken a few top records, including "Music artist with most consecutive number 1's in the UK" and the "Biggest selling arena act in the Wembley Arena". (See Westlife records)

Over years of their career, Westlife's music has evolved from teen pop to a pop sound, with an emphasis on ballads. Most of the group's hits have been composed by experienced songwriters, most notably Steve Mac and Wayne Hector. (See Songs written)

On 1 June 2008, Westlife marked their 10th anniversary with a concert in Croke Park, Dublin which saw more than 83,000 fans attending the special occasion. Music Week revealed on their website that Westlife is the official third top touring act within the years 2005–2008, while they were 7th top touring act of 2008.^[6]

^{http://en.wikipedia.org/wiki/Westlife}

h a p p y - b i r t h d a y - 20 th V