Has anyone had to do any entity/attribute definitions?

In particular with regard to financial MI.
i.e. Region area, emp no, illustration, campaign code, campaign desc?

Thanks

Just run a create table query to build your financial MI table with the fields you listed?

Here is the wiki on this subject. http://en.wikipedia.org/wiki/Entity-relationship_model

I would have to disagree with "learning newbie", you should always draw out your database design structure before you ever create a table. Using this method, you'll be able to spot things such as redundancy. It takes time to develop the ability to draw these out, start by getting as much information about your data as possible. Understand what data relates to each other and then get yourself a really big white board and draw out your ER Diagram.

You have a valid point, but I'd argue a person doesn't need to draw a design structure on paper first. A person who's trained themselves to think in these terms, in the relational model. You don't have to look at redundancy to be aware of it.

think we are on crossed wires.

i meant entity definition... i.e. an explanation of what the attributes mean!

i.e. Region area, emp no, illustration, campaign code, campaign desc.

illustration:
an illustration is defined as a ........

sounds like coursework.

huh!? no its not...

im a trainee analyst- and ive been asked to do some attribute naming for the first time- and im looking for pointers.


can anyone assist or not?!

define:illustration

Wouldn't you be better looking at how it has been done previously by fellow employees as there may be a company standard to follow.

Other than that, given your example it's simply a description of the data in each field.

yes you are right.
i was looking for something "extra" if available though

thread closed..

cheers

Well, an illustration is some kind of graphic visualization of a concept.

thanks for replying....
not in financial terminology it isnt though!

Ah, I see. So it's not the database or schema or whatever you're looking for info on, it's the finance side of things? 'Cause knowing that we'll be able to patch together a useful answer.

yes i need to define entities/attributes for a financial database.
i.e. application, illustration, premium frequency... that kind of thing...

thanks

no ideas?

not really, because as previously noted you need to be asking someone who is in the same field