The tag has no usage guidance.

learn more… | top users | synonyms

1
vote
2answers
238 views

Multiple relationships between the same entities

Is there a name for when 2 entities can have multiple relationships between them?
0
votes
1answer
24 views

How do I call a collection of tables with normalized (generic) information

In a database design there are many fields with information that needs to be normalized. For instance for an address record countries can be normalized but also the address type (i.e. private address, ...
1
vote
0answers
44 views

Named a table “order” in Microsoft Office Access database and the webapp now can't see the table (even after renaming it)

I am creating a web application in Dreamweaver using ASP VBScript. The web application is a store and I have to implement a database into it (which I did). I created a table in my database called ...
1
vote
0answers
134 views

Naming the parts of a supertype/subtype pattern

I am doing more extensive work with supertyping and subtyping as it solves some problems in a very useful way. In particular, I am enhancing a web application where many things need to be subject to ...
0
votes
0answers
11 views

Comparing the contents of 2 .nsm (naming standards) files

I have 2 naming standards files from ERwin (.nsm extension), and I want to compare them to see if they contain the same rules. Is there some sort of automated way to check this? If there isn't a way ...
0
votes
0answers
9 views

nomenclature for abstracting an instance of a class of data

Given three tables: TABLE FIELDS users user_id items item_id item_instance item_inst_id item_inst_qty ...
0
votes
0answers
93 views

Name for SELECT equivalent of UPSERT

UPSERT means INSERT and\or UPDATE, is there a standard name for a sproc that will INSERT if necessary and then SELECT? e.g. I want to get the IS of a row that matches fields and give me the ID, if ...
0
votes
0answers
54 views

Naming convention for columns with same name (but different logically)?

How do I name columns in my database tables which have the same name in outside world but are logically separated? Lets say an example Company Share: 100% of 50% Now I have two company shares: ...