> 1. Is there any way to just forward engineer a specific group of tables?
Create a blank .sql file and use compare and sync against this
file. You can then choose to export (generate code) only particular elements.
> 2. Is there any way to create a package within a schema for stored
> procedures to go into?
Oracle 8 packages are not supported in 2001, however package support
has been added to 2001A. For 2001 see,
Rational Rose - patches and upgrades
http://www.rational.com/support/downloadcenter/upgrades/rose.jsp
> 3. Is there any way to create a package for grouping tables or is the only
> way around this to create different schemas for the same database?
You can create different diagrams, but if you will notice there
is not package icon on the DM toolbar when looking at a Data Modeling
diagram. Right now I belive that the schema package is the best
you can do.
Patrick Kennedy
Rational Support
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Patrick Kennedy
> Sent: Friday, May 25, 2001 7:12 PM
> To: [EMAIL PROTECTED]; "Ales< Vrabic<" <
> Subject: Re: (ROSE) Rose Oracle8 Example
>
>
>
> >forward engineering Oracle8 with Rational Rose... example
>
> Below is a simple example of creating two tables and
> a Foreign Key between them.
>
> 1. Create a DataBase Component to match the database you
> are working with.
>
> a. Hightlight Component View in Rose browser, right click,
> Data Modeler:New:Database
>
> b. Double click on this Component icon in browser to open
> up specification.
> Set name = Database name
> Set Target = Database language
>
> 2. Create a new schema.
>
> a. Tools:Data Modeler:Add Schema
> -or-
> Hightlight Logical View in Rose browser, right click,
> Data Modeler:New:Schema
>
> (This will create 2 packages under the Logical View, one called
> Schemas and then within schemas another one called schema S_0)
>
> b. Double click on this Schema icon (S_0) in browser to open
> up specification.
> Set Name = your schema name
> Set Database = Database name you created in step 1.
>
> 3. Create a Data Model Diagram.
>
> a. Right click on the schema package in the Rose browser,
> Data Modeler:New:Data Model Diagram.
>
> This creates a Diagram under the Package Schema
>
> b. Double click on the Diagram to open.
>
> 4. Create a table.
>
> a. Now you can use the toolbar to add tables. After adding
> the table to the diagram, double click on the table to open
> table specification, go to column tab to add columns, right
> click, insert. Select PK check box if you wish to make this a
> Primary Key.
>
> b. Double click on column to open up column specification,
> set type and constraints.
>
> 5. Create another table following the same steps a #4.
>
> 6. Create a Foreign Key by adding a indentifying or
> non-identifing relationship from the toolbar and connect it
> between the two tables.
>
> Regarding Identifying and Non-identifying relationships:
>
> Identifying relationships represent composite aggregations,
>
> An Identifying relationship specifies that a child object cannot
> exist without the parent object. To enforce the rule, the foreign
> key in the child object also becomes part of that object�s primary
> key, thus creating a composite aggregation.
>
> Non-identifying relationships represent associations,
>
> A Non-identifying relationship specifies a regular association
> between objects. It uses a 1:1 or 1:n cardinality. Non-identifying
> relationships can be specified as optional where a parent is not
> required or mandatory where a parent is required by setting the
> parent table cardinality. To specify a relationship as optional
> set the parent cardinality to 0..1. To specify a relationship as
> mandatory set the parent cardinality to 1.
>
> Consider the following example,
>
> Two tables Parent and Child.
> Each contains one column; Parent_ID & Child_ID,
> which are their respective primary keys.
>
> Notice that with Identifying relation, the primary
> key in the child is a concatination of the two
> primary keys:
>
> //** Non-Identifying
>
> CREATE TABLE Parent (
> Parent_ID NUMBER ( 5 ) NOT NULL,
> CONSTRAINT PK_Parent2 PRIMARY KEY (Parent_ID)
> );
> CREATE TABLE Child (
> Parent_ID NUMBER ( 5 ) NOT NULL,
> Child_ID NUMBER ( 5 ) NOT NULL,
> CONSTRAINT PK_Child3 PRIMARY KEY (Child_ID)
> );
> ALTER TABLE Child ADD ( CONSTRAINT FK_T_14 FOREIGN KEY (Parent_ID)
> REFERENCES Parent (Parent_ID));
>
> //** Identifying
>
> CREATE TABLE Parent (
> Parent_ID NUMBER ( 5 ) NOT NULL,
> CONSTRAINT PK_Parent2 PRIMARY KEY (Parent_ID)
> );
> CREATE TABLE Child (
> Child_ID NUMBER ( 5 ) NOT NULL,
> Parent_ID NUMBER ( 5 ) NOT NULL,
> CONSTRAINT PK_Child3 PRIMARY KEY (Parent_ID, Child_ID)
> );
> ALTER TABLE Child ADD ( CONSTRAINT FK_Child5 FOREIGN KEY (Parent_ID)
> REFERENCES Parent (Parent_ID));
>
> To generate code, hightlight <<schema>> schema_name in Rose browser,
> right click, Data Modeler:Forward Engineer.
>
> For more help see on line help, contents tab, Rose Data Modeler,
> How to.
>
> Patrick Kennedy
> Rational Support
>
> ************************************************************************
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
> *
> * Admin.Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
> http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> *
> * To: [EMAIL PROTECTED]
> * Subject:<BLANK>
> * Body: unsubscribe rose_forum
> *
> *************************************************************************
>
> ************************************************************************
> * Rose Forum is a public venue for ideas and discussions.
> * For technical support, visit http://www.rational.com/support
> *
> * Admin.Subscription Requests: [EMAIL PROTECTED]
> * Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
> * Other Requests: [EMAIL PROTECTED]
> *
> * To unsubscribe from the list, please send email
> *
> * To: [EMAIL PROTECTED]
> * Subject:<BLANK>
> * Body: unsubscribe rose_forum
> *
> *************************************************************************
>-- End of excerpt from David P. Cunningham
************************************************************************
* Rose Forum is a public venue for ideas and discussions.
* For technical support, visit http://www.rational.com/support
*
* Admin.Subscription Requests: [EMAIL PROTECTED]
* Archive of messages:
http://www.rational.com/products/rose/usergroups/rose_forum.jtmpl
* Other Requests: [EMAIL PROTECTED]
*
* To unsubscribe from the list, please send email
*
* To: [EMAIL PROTECTED]
* Subject:<BLANK>
* Body: unsubscribe rose_forum
*
*************************************************************************
