Thursday, September 4, 2008

CSC 121 As I see it 009

Oracle Database

Making database in Oracle Database:

1. Select the Database Create Database Profiles main menu item to create profiles for the existing databases.

2. 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.

Creation of Oracle Tables:

1. 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;

2. Select the Table icon in the Create Database Object dialog or select the Tables list or any object from that list in the explorer tree;

3. Select the Create New Table... item from the popup menu or open and the Tables tab there;

4. Press the Insert key or select the Create New Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

Note: In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace. So, if you want all the tables in a tablespace to be read-only, use the following command:

ALTER TABLESPACE READ ONLY;
To reverse the change and set all the tables in the tablespace back to read-write mode, use this code:

ALTER TABLESPACE READ WRITE;
Despite that limitation, you can simulate a read-only table by simply preventing all table modifications using a trigger. To do that, create a trigger as follows.

SQL> create or replace trigger emp_sal_read_only
2 before insert or update or delete
3 on emp_sal_tbl
4 begin
5 raise_application_error (-20001, 'Table EMP_SAL_TBL is read only,
You cannot make changes to the data.');
6 end;
7 /
Trigger created.
FileMaker Pro
Making database in FileMaker Pro Database:
Note: Plan the database. Determine the purpose of the database and the information to be input into the database. 
Decide what specific fields are needed, what types of fields and how the database should look. 
Think about how the database may be used in the future and who should have access to the layouts, scripts and field definitions. 

1. Select the "File" menu and choose "New Database." If the "FileMaker Quick Start" screen appears, choose "Create Empty Database" and click "OK." Otherwise, the "New File" dialog box will appear.

2. Type a file name in the "New File" box. Be certain to give it a unique name; otherwise, the file name could overwrite another database. Navigate to the folder where the file will reside. Click "Save." The "Manage Database" box will appear.

3. Define a field by giving the field a name and determining any applicable options. Specify the field type, such as text or number. While FileMaker Pro will allow changing the type of field at a later date, there are restrictions on the type of information it will retain in the changed field. Continue defining the fields until all fields are entered.

4. Click "Done" when all fields have been defined. A basic layout with all the fields will appear.

Making tables in FileMaker Pro:

1. Open Database Editor and the Tables tab there;

2. Press the Insert key or select the Create New Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

3. Type a table name in the pop up menu box. Be certain to give it a unique name; otherwise, the name could overwrite another table. Navigate to the folder where the file will reside. Click "Save." The table you've just created will appear.

SQLite

Making database in SQLite Database:

1. Just click the "Create New Database" button from the main menu item.

2. This will lead you to the Create Database Wizard

3. Once you have accomplish filling up some informations in the Wizard window, you have now your database.

Making tables in SQLite Database:

Note: In making tables, you must first connect to a database.

To be conected just;

1. Open the DB by simply double clicking it. For an example ill use TFS/Forgotten.
2. Click on "Accounts" and make sure your in the "Edit Data" Tab which is in the window to the right.
3. Double click in each window under.. Ex, Account, Password Etc... This image has been resized.
4. After you have entered all the information , you will see blue icons like arrows or checks. Click on the "Check" which will say post if you leave your mouse icon on it. After that click on the account table and press F5 to refresh.


*Once you have connected, just right-click the database item in the explorer tree. Then, click "Create New Table".

Another way is to:

select the Tables list or any object from that list in the explorer tree;

• select the Create New Table... item from the popup menu

FIREBIRD MAESTRO

Making database in Firebird Database:


1. Database are made in the Create Database Wizard.
2. 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.
3. The first wizard step allows you to set a name of the new database.
4. 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.

5. You should accomplish filling up some informations in the Wizard window and set the server into an embedded one for you to be connected to the database.

6. Click ready and you have now your database.

Making tables in Firebird database:

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
or

select the Tables list or any object from that list in the explorer tree;

select the Create New Table... item from the popup menu
or

open Database Editor and the Tables tab there;

press the Insert key or select the Create New Table item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To create a new table with the same properties as one of the existing tables has:


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

follow the instructions of Duplicate Object Wizard.

No comments: