Software Testing

Testing Levels

• Unit testing
• done in local/DEV
• testing fixes individually
• Integration testing
• done in SIT
• testing integrated modules
• deals with integration of a process in the system, not the integration of the whole system
• System testing
• done in SIT
• testing the system as a whole
• Types of system testing:
• Usability testing – this is how well the user can access the different features in the system and how easy it is to use.
• GUI software testing – this is to check if graphically that the program looks how was intended and the GUI works as intended.
• Security testing – this would be to check if important information is secure and if there are certain access restriction that they work.
• Accessibility – how easy is it for various users including users with disability to use the system.
• Reliability testing – to check that the system works for long period of time and does not constantly crash.
• User acceptance testing
• done in UAT
• obtain confirmation that a system meets mutually agreed-upon requirements

Outline: Warren Buffett's Management Secrets

by Mary Buffett and David Clark

Step 1. Pick the right business to work for (business that offers greatest career opportunities)

Chapter 1. how to find companies that offer greatest career opportunities (w/ durable competitive advantage)

have products that:
- never really change
- easy to sell
- own a piece of consumer's mind

come in 3 basic business models:
- sell unique product, e.g. Coca Cola, Hershey
- sell unique service, sell what people need
- low cost buyer and seller of product/service that the public is consistently in need of - offer low cost through high volum, e.g. Walmart, Costco, Burlington

Chapter 2. quick test for identifying the best company to work for 

- per share earnings test (10 year period) - consistent and has upward trend
- debt test - long term debt must be low, debt load should be < 5*net earnings
- gross margin test - must be higher
      gross profit = revenue - cost of good sold
      gross margin = gross profit/revenue

Step 2. Delegate

Chapter 3. rules for delegating authority 

- every business culture is unique
- leave managers alone - let them continue to think their business as their own
- managers must have a GREAT deal of INTEGRITY

Step 3. Find the right manager for the job

Chapter 4. where to start search for manager 

- change manager only when necessary
- promote from within if possible
- look for talent w/ proven talent record

Chapter 5. victor or victim

- must have an internal locus of control
- victor = with internal locus of control - in control of themselves, take responsibility for their failures
- victim = with external locus of control - don't believe that they have power to solve their problems

Chapter 6. work at a job you like

- do what you love/love what you do, must not be driven by money

Chapter 7. put a winning sales team together

- find people who believe in the product

Chapter 8. obsession

- sd

Useful Maven Commands

• mvn --version - displays the Maven version in use
• mvn dependency:tree - displays the dependency tree for this project
• mvn eclipse:eclipse - creates/updates Java eclipse project settings (.project, .classpath, .setting/org.eclipse.jdt.core.prefs, & other config files)
• mvn eclipse:clean - cleans/removes Java eclipse project settings (.project, .classpath, .setting/org.eclipse.jdt.core.prefs, & other config files)

Useful DB2 Queries

ALL TABLES:
select * from sysibm.systables

TABLE DESCRIPTION:
select * from sysibm.syscolumns where tbname = 'tableName'
- NOT VERY RELIABLE, SOME COLs MIGHT BE MISSING

or

select colname, typename, length, scale from syscat.columns
where tabschema = 'schemaName' and tabname = 'tableName'
- NOT VERY RELIABLE, SOME COLs MIGHT BE MISSING

or

describe table tableName - DOES NOT WORK :(

Note: Use SYSCAT views rather than the SYSIBM tables. Reason being is that from release to release the tables are being revised while DB2 development tries hard to keep the SYSCAT view signatures compatible. For this reason SYSCAT is being described in the SQL Reference while SYSIBM is not.

GET CURRENT DATE/TIME:
select current date from sysibm.sysdummy1
select current time from sysibm.sysdummy1
select current timestamp from sysibm.sysdummy1

Note: sysibm.sysdummy1 table is a special in-memory table that can be used to discover the value of DB2 registers

Sources:
http://www.databaseteam.org/9-db2/b4ac3f33bec9fb23.htm#.UfdJQ41OS6M
http://www.ibm.com/developerworks/data/library/techarticle/0211yip/0211yip3.html

Database Normalization

First Normal Form (1NF)
- no duplicate columns, e.g. teacher, student1, student2, student3
- no non-atomic columns, e.g. teacher, students
- rows must be have unique identifier (primary key), e.g. teacher, studentID, studentName

 Second Normal Form (2NF)
- satisfied 1NF
use foreign key (move subset of data/column that apply to multiple rows of a table to another table and connect them through the foreign key)
e.g.
studentID, studentName, courseID, courseName to
studentID, studentName, courseID and courseID, courseName

Third Normal Form (3NF)
- 2NF
- remove columns that are not dependent upon primary key
e.g.

Boyce-Codd Normal Form (BCNF or 3.5NF)

Fourth Normal Form

Apache log4j

DEBUG < INFO < WARN < ERROR < FATAL

HTML

Complete list of HTML tags: http://www.w3schools.com/tags/default.asp

- HTML stands for Hyper Text Markup Language
- HTML is not a programming language, it is a markup language
- Practically speaking, there is no difference between the htm and html extensions
- In XHTML, all elements must be closed. Adding a slash inside the start tag, like
, is the proper way of closing empty elements in XHTML (and XML)
- HTML tags, attribute names and attribute values are not case sensitive but World Wide Web Consortium (W3C) recommends lowercase in HTML 4, and demands lowercase tags in XHTML. Newer versions of (X)HTML will demand lowercase attributes
- In XHTML, XML, elements with no end tag (closing tag) are not allowed
- attribute id vs name: id must be unique and is used as an identifier of an HTML element while name is used for form elements and form elements can share the same name
- HTML comment sample:

 <!-- This is a comment --> 

- The <center>, <font>, <basefont>, <s>, <strike> and <u> tags and align, bgcolor and color attributes are deprecated in HTML 4, and removed from HTML5. Style sheets (CSS) should be used to define the layout and display properties for many HTML element
- Always add a trailing slash to subfolder references. If you link like this: href="http://www.w3schools.com/html", you will generate two requests to the server, the server will first add a slash to the address, and then create a new request like this: href="http://www.w3schools.com/html/"
- HTML frames are obsolete in HTML5. Cons: http://webdesign.about.com/od/framesprosandcons/a/aaframesyuck_2.htm
- The doctype declaration refers to a Document Type Definition (DTD). The DTD specifies the rules for the markup language, so that the browsers render the content correctly. 

 <!-- This is a comment --> 

Reference: http://www.w3schools.com