I want to know if there are special names for tables, for example if i had an employee table and a country table

Its gonna be a many to one relation ship, Since the Country table is gonna be exhaustive tht is finite and not growing table does it have some other name....

Do we call the static and dynamic tables??? Employee records will keep growing.....so does tht come under different categories.

I am not sure if i can make my simple point clear, hope u understand what i'm try ing to say.

Typically no. Employees and Country would be good for the table names. There should be no difference whether the you have a 'fixed' set or not.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.