Sunday, September 7, 2008

CSC As i See it 009

How to generate data in the tables using the following database
Oracle
Firebird
SQLite
FileMaker
1. Firebird
Start database then click Create Database Wizard.
To run the Create Database Wizard, select the Database Create New Database... main menu item or click the Create New Database button on the main toolbar.
The first wizard step allows you to set a name of the new database.
Database Editor allows you to browse all the database objects and its main properties. There is possible to create, edit and drop database sub-items.
2. Oracle
Start Oracle Database Maestro. Select the Create Database Profiles main menu item to create profiles for the existing databases.
After you have created the required database profiles Create Database Profile Wizard they appear in the explorer tree on the left. Now you can establish connection to the database. If connection succeeds, the database node expands displaying the tree of its objects.
New tables are created within Create Table Wizard. In order to run the wizard you should either

select the Object Create Database Object... main menu item;

select the Table icon in the Create Database Object dialog
3. FileMaker
Start the software.
You select from a palette of files, fields, and graphic tools to create a structure.
The first step in designing a database is choosing what information you want to store in a database.
The second step is to create fields in your file. This requires deciding what types of fields you want. For example, fields can store text, numbers, pictures, or other kinds of data.
The third step is to create layouts. Layouts are computer screens that present information to you. Usually a database provides graphic tools that can enhance the appearance of the layout. For example, you can add boxes, lines, and fill patterns by using the tool palette.
4. SQLite
Start the Database.
Just click the Create New Database button from the main menu item. This will lead you to the Wizard.
Once you have accomplish filling up some informations in the wizard window,you have now your database.
in making tables, you must first connect to a database.
Once you have connected, just right-click the database item in the explorer tree. Then, click "Create New Table".