The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
218 views

Multiple relationships between the same entities

Is there a name for when 2 entities can have multiple relationships between them?
0
votes
2answers
101 views

about giving same column name in every table of database

I have a database with 5 tables. In every table there is a column for checking status. If i give the name to that column which is same in all the 5 tables; What will happen? Is it correct according ...
0
votes
1answer
22 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
30 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
129 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
7 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
89 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
52 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: ...