Introduction to PowerBuilder

Database Painter Exercises

You need to create the following objects. The left most column in the following table lists the object that you need to create and also has the link to the deatil list of those objects. The second column lists the files that have SQL statements to create those objects. You can use these files in two different ways. One, you can execute them in the database administration painter and objects will be created for you. We don't recommend this way. Instead we would like you to create those objects and export those object definitions and compare with the SQL that is listed in the files(second column). The thid column lists the files that inserts sample data into those tables. The data is also displayed in the picture for each table.

	Tables:   Table Name SQL to create table, index SQL to create Data units units.sql units-data.sql product_master product_master.sql product_master-data.sql trans trans.sql trans-data.sql product_images product_images.sql None
	Edit Styles e_tran_type
	Validation Rules v_no_empty_column v_no_zero_column

Create the 'units' table as shown in the following picture and enter the data as shown.

Create dialog box for the table	Data

Create 'product_master' table as shown in the picture and enter the data as shown.

Data

Create 'trans' table as shown in the picture and enter the data as shown.

Data

Create 'product_images' table as shown in the picture. This table doesn't have any sample data. The reason is that, you need to follow special procedure to insert images into the table, which is not explained and is too advanced at this stage. We will explain this in the OLE session.

Once you define all the above tables, it should look like in the following picture:

After defining, assign it to "tran_type" column in "trans" table.

After defining, assign this rule to "product_description" in "product_master" and "unit-description" in "units" table and "unit" column in "units" table.

After defining, assign this rule to "product_reorder_level" column in "product_master" and "tran_qty", "tran_serial_no", "tran_no", "tran_item_no" in "trans" table.

Home	Previous Lesson: Database Painter - Questions & Answers Next Lesson: DataWindow Painter