Thanks for clarifying. My understanding of database design is definitely improving. I have to say I thought database design was a small and easy task but the more I learn...

views/stored procedures to hide columns from some users --Sure, you wouldn't let just anyone see a patient's Social Security Number, for example. If you did, and someone misused it,...

Constraints may be things like are invoice numbers or accounting codes always start with specific sets of letters, or have to be in a specific range for a specific...

• This reply was modified 2 years, 5 months ago by  Mr_X.

...and/or the data is a mess. If there really are duplicate ticket numbers, can the data be fixed (merge, replace duplicate ticket numbers w/ new ticket numbers, and/or delete...

What is Ticket ID, and why is it a tinyint? The name implies it's a unique ID. A tinyint would only allow 256 tickets (0-255). If it's a type...

I would strongly recommend sticking with "integer" as the type.  Add a domain (or range_of_values) column to limit the size rather than a data type name.  Remember, the logical...

It's hard for me to say. Getting information from the people that supplied the data is very difficult. I've made some adjustments to the model. Here are the data types...

Thanks for getting back to me. I'll settle for the CASE statement I just found it easier for me.

Thank you for your reply.

Scott suggested putting...

• This reply was modified 2 years, 5 months ago by  Mr_X.

Thanks for your reply Scott. I played around with step 2 and did mange to get it to work, kind of. I was just wondering if I could make a...

Thank you for your reply Jeff and help. I'll be sure to implement these. I'd kindly like to ask what the differences are between SMALLINTs and TINYINTs are?.

So far we've...

Hi Scott. Thanks for your reply. I understood most of what you said. I'd kindly like to ask for some clarification on some parts. But here is what I understood...

Understood. Thank you very much for the clarification and your help.

Thanks for the help Phil. I'll be sure to do that. Does putting a lower varchar length equate to lower storage size and vice versa?. Just curious.

Also I'd kindly like...

• This reply was modified 2 years, 5 months ago by  Mr_X.
• This reply was modified 2 years, 5 months ago by  Mr_X.

I appreciate your help. You mentioned:

"The process which transforms your data should be kept separate from any scripts you use to build your database objects (tables, keys, foreign key relationships,...

• This reply was modified 2 years, 5 months ago by  Mr_X.