I need to create an SQL database for my work, and use visual c# to build the application. I work for a college and we have just opened up an IT support shop that is run by the students. They need a database created, but I am unsure where to start with the process.
I need a databse that will hold both the customer details and all the repair jobs related to that customer. Am i right in saying that i would need two tables. one for the the customer, giving them a reference number set as a primary key and the other table with the job details, with the repair number as a primary key (foregin key in customer data)
any advice where to start will be great. i understand this may be a long project but i have untill summer nexy year to get it done