My fault, I should have been more specific. The steps outlined above are assuming I know what the model will look (so after I've done the normalization on paper). Out...

Thank you for your detailed reply. I've only just noticed some of the things you mentioned from a previous reply, I totally missed it earlier. You wrote:

"Names at the logical...

@ratbak Just curious if I did follow an ETL in SQL would I import the table, transform it using SQL and then create a new table/s to insert the values...

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

Nice. I really like the way you broke it down. I've tried assigning the attributes so far. I've not thought about the keys yet though. Here it is:

Ticket

TicketNumber, Received, Type,...

Yes CPZ and CPZCode have a one to one relationship. Regarding the naming method you suggested, it is good practise and I will implement that in future. Thanks for the...

You're right I should have given more detailed. Below please find attached some more information I've included. Please note, its a struggle getting all the information as I need to...

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