Fifth week Individual Assignment on Information Technology
Lecturer; Prof Dr Prabowo
Theme; Introduction and the use of DATABASE
Written and composed by; Harold Wiriadinata Wirawan
Date of Submission; 21 March 2010

1. Technology and software database is an application that gives us a free access to download, learn within unlimited evaluation time, incredibly each software comes with development license that provides us to use a full version of the product at no hidden cost whilst we are developing and prototyping our applications. These databases have been clearly proven to be highly successful for giant companies like oracle, IBM, and Microsoft whilst the open source also have RDBMS post SQL and SQ Lite, Virtually these databases are nestled in data base file which is more into desktop application like Microsoft access and SQ Lite that stands for public domain database classify as stores data in one file, Database server runs on network PC apparently huge database are server based as it more faster and robust. Subsequently application communicate with database server through these following links; Domain name of the server or local host of DNS name, server port – 3306 for My SQL and 1433 for Microsoft SQL serve username and password them name of database meanwhile for those who aren’t familiar SQL stands for structured query language and define as simple language provides instruction used to build and modify structure of database. Command used to modify and retrieve data inclusive of select means fetches data, Insert – means entering one or more rows of data, Update – means modify existing data and delete – means getting rid off data. Furthermore open source data base inclusive of My SQL is classify to be one of the most fast approaching power and usability of commercial rivals whilst open database connectivity provides interface to database. Overall data base is best described as an application which store and retrieve data in the fastest way as fast as it possibly could while relational bit stands for how data is stored in the database and how is it organized. In contrast all data is stored in tables within rational database precisely like spreadsheet and its relation between tables is what make it rational table.

2. Drawing on definition of Database from business point of view and perspective is an organizational structure of our crucial data by all means its entirely up to the user based on whatever content is in there and the way users are using it. Literally in today demanding market most businesses are facing a highly demanding challenge in terms of compliance, quality of assurance, traceability, etc, However these needs to overcome the situation more effectively and efficiently should we not be looking for a whooping cost structure with that say efficient database technology will certainly be the perfect answer to that question specially for a small business user whom manually input data from keyboards through large operations that comes with an automated data collection and processing. Please be informed that extracting data can certainly assist us in analyzing and making submission on our report info. On the other way around this will also be given as an easy access from spreadsheets and other software application. All info generated from our database use to empower and emphasize people in our business. More importantly as business user we must be able to provide an easy access to a fresh and timely accurate data to our team in a form where they are keen to receive them .

3. Further to my observation maintaining data quality within operational and business marketing application is a form of disciplinary which is frequently overlooked by many organizations. Most executives like myself would have thought that all of the company operational and analytical business process is definitely rely on a solid high quality data foundation. Unseeingly the quality of data use for marketing and boosting sales purposes involves assuring accuracy, time lines, completeness and consistency of data used by the company at the same time. Assuring each individual who use these data has a common understanding on what the data actually interprets and represents eg; the scope of data quality subjects are not limited to data generated by the company own operation on the other hand the data obtained and originated from the other external source must also be included. Most of the companies consider data as an absolute necessity that has its own initiative specially when it comes to overcome critical mission and mission and those who are required to meet the dateline of government reporting and disclosure requirement. From this factual usage and value the data will then escalates as one of the most critical aspect in the company. Above all when it comes to the accuracy and compliance data quality software does certainly provide an accuracy in the tax jurisdiction process in order to ensure clients and local municipalities are given a fair dinkum (Aussie slang for Fair play and treated equally) in terms of taxation and revenue apportionment. To be taken for granted that low quality of data will lead the company to be perceived negatively in the market place. For me personally clients first impression must be one of quality then the way company perceived by staff can be influence by the quality of its data. Back in Australia (land down under) Driver license number is frequently used as a primary identification on top of passport that symbolizes each person nationality. This means after the company deployed data quality software enabling to recognize the patterns of drivers license number itself was merge or retain the person records of its other company. That’s why I clearly stated on the practical scale the importance of having data quality process must be maintained and never to be underestimated. Please note that brand image, compliance, dispute, operational efficiency, etc are just some portions of an elements benefiting from an outstanding data quality and management.
4. Amazingly the beauty of database marketing I often use at the banking and hospitality industries are giving me a permission to get better and better at what I do by using test control. Cause I know that every single promotion to clients must be place into a test and hold for some reasons even though I consider on what I’ve done so far is brilliant the only proof of evidence given is when the clients respond, giving a feedback and make purchase on goods and services. I am thinking that success in the market is valid as a measure of my promotions as a serious marketer. By all means our clients database must be combined and riddles with control groups. Different individuals don’t get the same promotions which is being sent to thousand of others. I can be assure that by doing this we can slowly learn on whether promotion is worthwhile. Here are few questions I am hoping everyone to reflect and stick in their mind ; what have I learned from the latest strategy I’ve been arranging so far and how can I implement this towards the future in improving and accomplishing my marketing mission, who is in charge in the company , have I already sustain a reasonably good corporate governance alongside with the control group system in the company. Having said that here is the case studies from several banking

and hospitality industries which I’ve been working for so far. These organizations have many things in common when it comes to selecting clients based on their income, net worth, company or industry they privately owned or worked for, investment objectives, current type of credit or charge cards they do have at this stage, do they own their assets in their own rights, type of vehicle they drive, current residential premises, status of residency in a hope they could afford to purchase prominent villa in the upscale markets. These upfront assessment must be made to assess each individual ability as part of the company procedure from the automated database generate from sales force. After I made my evaluation and analysis I can then get to invite them to indulge their 7 nights free stay at the exclusive five star resorts and get them to come in at prestigious events like the gentlemen’s club in Great Britain or perhaps getting them to join into one of the world classiest cards programs. However one step ahead of my marketing strategic plan is that all of these clients must abide and bound by the company standard privacy act and acknowledgment that they must accept which is disclosed in their disclosure statement before they arrived and taking in the best the company has to offer.
By accepting our offers means I on behalf of the company may do certain things with information obtain from its clientele. On behalf of the company I collect personal info including client full name, address, and contact details to allow me to administer its clients relationship and provide its clients with the product and services they request as well as the info on the company product and services. If I have client email or cell phone details on me, I may provide info to them on the company products and services electronically . I collect info where its compulsory on individuals such as company directors and officers inclusive of clients agents and person dealing with us on a one of basis. Clients must provide me or us (the company) with accurate and relevant info otherwise I may not be able to provide them with the products and services they are seeking, In other words I am permitted by the privacy act to disclose any personal info to other members of the company as this will enable the company to have an integrated view of its clients, besides that clients personal info may also be accessed by our company staff in other countries should it becomes compulsory for transactional reasons or to enhance our relationship with clients. Furthermore clients must also aware of other disclosures on their personal info to the following parties such as; brokers, agents who refer their business to us, any person acting on their behalf inclusive of their financial advisor, solicitors, or accountant, executor, trustee, administrator, guardian or even attorney, and also organization that includes overseas one to whom I or we(the company) outsource certain function. Eventually clients confidentiality do apply where as in all circumstances the company contractors, agents, outsource service providers becoming aware on clients personal info, therefore personal info may only be used by the company agents, contractors, and any other outsourced service providers for the company purposes.
5. Here are a few samples of my database framework in words format despite I often place them in excel format based on the qualified that I had analyzed, assessed and proceed through internal proceedings;

Potential Clients name for Karma Resorts Grand cliff top luxury hills villa residence in Bali price tag: USD 3 Million – Karma Kandara, Jimbaran, and Agung Resorts

1. Prospective clients name: Mr. Dominic Stead
Nationality: British
Position retain: Chief Executive Officer
Company name: CB Richard Ellis, Hong Kong based
Type of Industry: Real Estate developer
Office address: 34/F central Plaza, 18 Harbour Road, WanChai, Hong Kong
Office Phone number(s): + 852 2820 2800, 2904 (if calling from overseas)
Facsimile Number(s): + 852 2810 0830
Mobile phone number(s) : I am not allowed to disclosed due to client privacy
E-mail addresses; dominic.stead@cbre.com.hk and angel.lui@cbre.com.hk (secretary in charge- Miss Angel Lui)
Type of credit or charge card(s) held: Unlimited Black American Express Charge Card (ending with 22008)
Annual income generate: Above USD 750,000 gross
Source of leads: St Patrick high socialite gala dinner in HongKong, charity auction ref no: #KR 1008981
Lead record type: Karma Resorts Bali
Lead owner: Harold Wiriadinata Wirawan
Type of inspection: Strictly by appointment and invitation only

2. Prospective clients name: Mr. Steven Yurisich and Mrs. Kimberley Yurisich
Nationality: Dual citizen – British and Australian
Position retain: Chairman
Residential Address: Flat 6, 13 Leinster Garden, London, W2 6DR, England
Type of inspection: By appointment and invitation only
Cell Phone number: + 44 7703 440 692 (If calling from overseas)
E-mail address: steven@nottinghilldesign.com
Type of industry: manufacturing and Retail
Company Name: Notting Hill Design Incorporated
Disposable annual income before taxes: Above USD 400,000 gross
Type of Credit card held: American express Platinum Charge card
Special Programs: Harbour club Tournament ref no: KJSY – 100808
Source of lead: Karma Resorts – special programs
Lead Owner: Harold Wiriadinata Wirawan

3. Client name: Mr. Michael Little
Position retain: Owner
Company name: Laut Bali
Type of industry: Villa resorts
Nationality: Australian
Residential address: Jalan Labuan sait, Padang Padang, Pecatu, bali, 80364
Phone Number: + 0361 – 769 900
Cell phone number: + 62 – 0815 – 58106600
Source of lead: PT Bali Super
Lead Owner: Harold Wiriadinata Wirawan
e-mail address: Michael@lautbali.com
Disposable income before taxes: Above USD 425,000 gross
Type of credit or charge card held: Citibank Platinum Visa and Master card
Type of inspection: By appointment only

These are the sample of data base which has not yet been classified from Karma Resorts;
1. Mr. Paul Anderson, c/o Barco and entertainment media, international Business Development manager sports, 5 Noordiaan Avenue, Kuurne, 8520 – Phone number; + 3256 368183, fax no; +3256 368836, cell phone no: + 324 78781193- email address; paul.vanopdenbosch @barco.com

2. Mr. Sim Teck Soon Collin- DOB- 25-June1970, c/o Flash X couriers, managing Director, Cell; +65 96799722, Office; +65 62221191, Home; +65 62892590, e-mail; csts1188@yahoo.com address; 141 Jalan Pelikat, Singapore.

3. Mr. Tee Tiong Guan, c/o Chip Seng Transport. 6 October 1964, managing Director, Cell; + 65 9011 2633, office; + 65 64738112, fax; +65 65652633, e-mail; jithemg@singnet.com , address; 470 Jurong West Street, # 10 – 437 No 41, Singapore.

There are still plenty more of prospective leads or database to be revealed up here its just too many to get written down here, those are just some sample that is available for viewing whilst the remaining 3 here are the ones which haven’t been assessed and processed by me individually meanwhile the first 3 have all met the criteria and requirement for the company.

End of 5th week assignment

Written and composed by,
HAROLD WIRIADINATA WIRAWAN

This entry was posted on Sunday, March 21st, 2010 at 12:53 pm and is filed under Binusian Blog. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.