Terminology Question
Sep 5, 2007
This is an easy one, I hope. Terminology has changed over the years, and I'm not sure what the current nomenclature is with regards to ...
I have a table contains State names and State codes. I have another that contains Product names and Product codes. I have another that contains Collateral type names, and Collateral type codes.
At one time, I heard these referred to as domain tables, but I don't believe that was a correct label today. We do want to differentiate these tables from other tables that might refer to them. Other tables might be transaction tables, or represent data that will eventually be purged. However, Collateral types are somewhat static in a business environment. So are the names and number of states. Likewise with Countries. Even Products are somewhat static, and certain ProductTypes (or category) might be static.
So what is the name that refers to these types of data tables, as opposed to the more transactional data?
View 2 Replies
Jul 20, 2005
Terminology question:Is there a term for a set of records related directly or indirectly by keyvalue in several tables? For example, a single invoice record and its lineitem records -or- a single customer, the customer's orders, the order linesfor those orders, the customer's invoices, and the invoice lines for thoseinvoices.I'm thinking the term might be graph, but I'm not at all certain of this.Thanks,Steve J
View 17 Replies
View Related
Dec 22, 2007
I am a non-technician and have had an .asp site with an SQL database on a shared server for several years. I now need to move to a new shared server and want to understand as much as possible and to be able to continue accessing my data directly. I have used Enterprise Manager in the past, withut really even knowing what it was or what it was a part of, to pull lists, etc. I am now using Vista and the new hosting company says I can download Enterprise Manager from Microsoft.com. I tried and found only the ability to download SQL Server 2005 Express. This seemed to imply I would get Enterprise Manager as a result. I attempted to download SQL Server 2005 Express, following all the instructions. When it said I had sucessfully finished, I went to All Programs to find it and found "MS SQL Server 2005" listed. Under the lising I found "Configuration Tools" .
Under Configuration Tools I find three more options: "SQL ServerConfiguration Manager", SQL Error and Usage Reporting" and SQL Server Surface Area Configuration"
These are all Greek to me and I am uncertain if I even got the "SQL Server 2005 Express" program downloaded.
Please give me whatever guidance you can.
Thank you.
View 10 Replies
View Related
