是否有由 < em> Oracle数据模型 < /em > 生成的关系模型图表的 < 坚固 > 详细符号指南 ?
我使用甲骨文数据建模器来为现有数据库 < / 坚固> 创建 < 坚固 > 的generate 关系模型。 它生成了一个图表, 但我无法解码图表中的所有符号 。
某些“强度”注释
- arrows
- asterisks (red)
- Aphabetical notations (like P, F)
- Symbols (like diamond, key)
- Abbreviations (like IX)
上述“强势”与“/强”相对应:
- foreign key references
- ??
- P - Private key; F - Foreign key
- key - Private key
- ??
然而,我想知道是否有关于“甲骨文数据建模者”的详细符号指南?
我在网上找了 但找不到
红色星号通常都是强制性的, 大多数 ERD 中钻石表示与. pk 和 fk 是私人和外国密钥的关系, 如果我记错的话。 我不知道箭是什么意思, 你是说乌鸦脚符号吗?
I think data modeler has a section in the settings to show which ER notation it is using. One can change or see the notation there. for my mac;
Preferences -> Data Modeler -> Diagram -> Logical Model
您可以在网上查看箭头等的更多信息。
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
I ve got the following objects: CREATE FUNCTION CONSTFUNC RETURN INT DETERMINISTIC AS BEGIN RETURN 1; END; CREATE TABLE "FUNCTABLE" ( "ID" NUMBER(*,0) NOT NULL, "VIRT" NUMBER GENERATED ALWAYS AS ...
The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes ...
I was wondering, is there a way to make a kind of one to one left outer join: I need a join that matches say table A with table B, for each record on table A it must search for its pair on table B, ...
I need to be able to run an Oracle query which goes to insert a number of rows, but it also checks to see if a primary key exists and if it does, then it skips that insert. Something like: INSERT ALL ...
I just came across NULL values in NOT-NULL fields in our test database. How could they get there? I know that NOT-NULL constraints can be altered with NOVALIDATE clause, but that would change table s ...
I m studying databases and am currently working on a object-relational DB project and I ve encountered a small problem with the number of possible constraints in an object table. I m using "Database ...
we have a table in an Oracle Database which contains a column with the type Char(3 Byte). Now we use a parameterized sql to select some rows with a DBNull.Value and it doesn t work: OracleCommand ...