2.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 here to see the solution for this challenge. Then, continue to Part 2.9: Diagramming Notation.
Last updated