Questions tagged [naming-convention]

The tag has no usage guidance.

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
0answers
179 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 ...
1
vote
0answers
535 views

How to properly name a database table

First of all, I understand this question may seem opinion-based, but I know there are some standards for naming conventions and I would like to know which is the best and why. It's not so complex ...
1
vote
0answers
32 views

Redundancy in table names / Table naming convensions

I am creating some templates in my database that users would be able to use to help set up some of their data. For example, I have the following tables (simplified of course): store (id, store_name)...
1
vote
0answers
110 views

ERD mostly in text

In LaTeX I can replicate database tables similar to the ones in the diagram below, but I do not want to deal with figuring out how to nicely draw the relation diagrams between the tables. Is there an ...
1
vote
0answers
134 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
89 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: ...
0
votes
1answer
31 views

How to name tables which are responsible for storing dictionaries and configuration?

Below I attached diagram which corresponds to part of my database : My questions: In your opininon Do I have to divide ServiceInsance and ConfServiceInstance ? I did it like that because I would ...
0
votes
0answers
64 views

Schema Master, Schema, Scheme - table name/design help

I’m stuck! 3 table names. Schema Master, Schema, Scheme. They are too confusing for me I always get them mixed up.... Any ideas on how to name better? I also maybe designing this database ...
0
votes
0answers
28 views

What is the naming convention where column names are prefixed by chars indicating the data type?

I work on a database where column names are prefixed by a character representing the datatype of the column. I quite like this, because it's easy to see at a glance what type of data each column holds....
0
votes
0answers
16 views

Name of attributes that are indirectly related to entity

If I have a set of data that relate to an entity directly and some that do not, is there a standard name for these two types of attributes? example, Employee: employeeID firstname lastname manager ...
0
votes
1answer
38 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, ...