The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
173 views

Multiple relationships between the same entities

Is there a name for when 2 entities can have multiple relationships between them?
0
votes
2answers
55 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
21 views

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

I have hit a crisis in the development of my web application for my web development course and I need your help because I am all out of ideas. I am creating a web application in Dreamweaver using ASP ...
1
vote
0answers
127 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
85 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
51 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: ...