Question: Using SQL Server Management Studio (SSMS), create a database called TestDB) and place the following tables described below in this database. Use appropriate table

Using SQL Server Management Studio (SSMS), create a database called TestDB) and place the following tables described below in this database. Use appropriate table names, primary keys, and appropriate data types. b) You and your friend are going to establish a mail order business out of your home. You want to keep track of your current and potential customers. Create a table containing the information you feel is necessary. Add 5 records to the table. c) You are trying to keep track of the mileage you put on your car for business. Your boss will ask you to justify each trip you make, i.e. who you visited, when you traveled, number of miles, etc. Create a table containing the information you feel is necessary. Add 5 records to the table. d) You want to keep track of your courses, when you took them, who your instructor was, how you did, etc. Create a table containing the information you feel is necessary. Add 5 records to the table. e) Script the database using "Generate scripts" including all three tables with the data included..
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
