1.8: Customer Table

Without looking back at the previous lessons, create a Customer table with the following criteria:

Name	Type	Null?
CustomerID	int/Primary Key	No
LastName	varchar(25)	No
FirstName	varchar(25)	No
LastPurchase	Datetime	No

Now, insert this data into the table:

CustomerID	LastName	FirstName	LastPurchase
1	Tinney	Zach	5/1/2017 10:17:00
2	Wainscott	Chris	6/2/2017 8:12:00
3	Williams	Jenn	6/5/2017 9:23:00
4	O'Connor	Paul	7/12/2017 11:48:00
5	Rahimzadeh	Auri	1/8/2018 14:34:00
6	Fancher	Dave	3/16/2017 20:56:00
7	Handshoe	James	4/24/2017 19:09:00

Click on 1.12 Solutions to see the solution for this challenge. Then, continue to Part 1.9: Diagramming Notation.