Connoisseur

Additional codes

I remember that BUD once told us how to view all the created tables in our sql account, but I do not remember the command. The command I did write was not the right one - so does anyone remember which entry is needed to retrieve that information?

Also, during our project, we did not know how to alter the name of the actual table as well as altering the names of attributes (columns) after the table has been successfully created.

Derived Data?

In normalization, does anyone know why derived data is not allowed? Is it merely because the data would be inefficient to store because it can be calculated using a query?

In my purposes, I use an access database to interface directly with word in order to populate fields and generate customized templates. Derived data would be useful to have in that case so that I can easily interface the information seamlessly and not have to run a separate query. Using it in this manner, would derived data still be a bad idea for a database?

Test Post

Test Post