Sym 400- Tables, Keys, and Constraints: Introduction to Database Structures.

To implement a new table with an auto-incremental BusinessEntityID as an integer and the DoB or the Date of Birth column, I used the following SQL query to select the data in the table, I ran the command SELECT * FROM DateofBirth though I expected this command to return no data since the table was just created. On execution of the system produced a message that at least one row has been changed which means at least one record has been updated. To make sure that the new table created is correct and the date of birth was incorporated correctly, I used the following query. It was possible to retrieve the record with BusinessEntityId as 1 and the corresponding date of birth as . Last of all, I copied the SQL query that I had written and pasted it in the folder created for it with an extension. sql file, to wrap up the assignment. Pictures below will dsee the steps.