0
There is no right or wrong way, however, there are some fairly common naming conventions and these are the ones I try to stick to.
Objects should be named in the singular rather than plural; Customer, Item, Vendor, Sales Order, instead of 'Customers', 'Items', etc.
CamelCaps naming with no spaces or punctuation except underscore; 'SalesOrderHeader' instead of 'SALES_ORDER_HEADER'. And please - NEVER use spaces - and I am looking at you, the Microsoft Navision development team!
Use the name to group related objects together; 'CustomerMaster', 'CustomerAddress', 'CustomerStatistics'.
Not strictly necessary but many developers like prefixing views with 'v' or 'v_' to denote that the object is a view and not a table; 'v_CustomerLimits', for example. In the same way, many like prefixing their trigger names with the actions of the trigger, so 'tIU_Customer_CreditCheck' would be an INSERT,UPDATE trigger on the Customer table - it saves having to check the code to see what conditions the trigger fires on.
Column names should not include the table name other than for key columns. On a customer table, for example, the telephone number and balance columns should be 'Telephone' and 'Balance', not 'CustomerTelephone' and CustomerBalance', whilst columns that will be used in foreign key references should include the table; 'CustomerCode' not just 'Code'. Where a column has a foreign key reference to another table, it should use the same name as the target column. If the customer table has a sales rep code that links to a reps table, then the column in both should be 'RepCode', the customer one shouldn't be 'CustomerRepCode'.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
How does a data base work?
A database is, simply put, an organized collection of data. The manner in which information is entered into a database makes it easy to retrieve, format and manipulate. All that is required is the knowledge of the proper language. When you know how to query a database in the correct manner, it will yield the specific data in the format you request. The most frequently used type of database is called a "relational databases." In a relational database, there are several tables containing various information. Each table contains data that all have attributes related to the subject of the table.
Who or what is responsible for maintaining database consistency?
The RDBMS (Relational Database Management System) is responsible for the control of the database however it requires appropriate planning and implementation of your design in order for this to work properly. Further proper maintenance of the Database environment is critical to its on-going operation. In short proper design by the database architect followed by proper implementation of this design by the DBA or SQL Developer coupled with proper SQL environment deployment is responsible for the healthy operation of a RDBMS.
What are the common nouns and proper nouns in 'Hurricanes hit the coast of Florida during August'?
Common nouns are the nouns that aren't specifically naming something. In this case, the following would be the common nouns: hurricanes and coast. Proper nouns are specifically naming something and are always capitalized because they are naming something. The following are the proper nouns: Florida and August.
What is the proper noun of beethoven?
Your question is already 50% proper because you're naming beethoven. To make it completley proper, simply capitalize his name and you have a proper noun. Beethoven.
Can you create a database in Microsoft Word 2007?
You can lay out data in a tabular format in Word and do things like sort it and even do some calculations. Using Word you can create data in a format that could later be used in a database application, such as comma separated text. When doing a mail merge, you can create your data with Word rather than sourcing it externally, and it will be stored in a file with fields to be used in you mail merge. So Word does have some limited databasing capabilities, but you would not use it to make a proper database as it does not have all the facilities to do so.
What are the advantages of planning PowerPoint presentation in outline format?
Visuals, multimedia, and other slide objects play important role within a presentation, but a proper outline is still the main skeleton on which the body of a presentation can be sustained.
What is a legal proper notice for 60 day eviction?
You'll have to get an attorney to draft the proper format for this.
Is the word amphibian a proper noun?
No, to be a proper noun it has to b naming a specific amphibian. A proper noun wouldn't be frog, or toad, either, it would be Jenny the frog, or Bert the toad.
How do you change date format?
go to the command prompt and give the date commandusing the proper format and then restart the computer
What is the proper format for an essay title?
the internet doesnt say
What is the purpose of database auditing?
Database auditing is used to observe the actions of the database users. It is commonly used for security purposes to ensure that information is only accessed by those with the proper authority to view it.
What are some factors to consider when saving naming and storing documents?
safetycleanlinesstemperature proper cooking proceduresstoring and controllingSome
