The human resources department has requested that you create a table that can be used to store birthdays in the database. This table will be used to support a newsletter that is distributed internally to report on office events.

1. Create a new table called Birthday with the following columns: BusinessEntityID column as an integer, and a DoB (Date of Birth) column in as date.
2. Add a constraint to make BusinessEntityID a primary key.
3. Insert one record for BusinessEntityID 1 and include 1990/01/01 as the birthday.
4. Once added, query your new table showing the new record.

using adventureworks