Building data models

The goal is to learn how to build the Data Model for a shopping cart website you will create in assignment 7. Your Data Model will consist of 5 entities that store information about the customers, the products and the purchases. The entities will be related according to the Line-Item Pattern discussed in Chapter 5. You will create a Data Model diagram showing how the entities are related using MS Visio 2010 or MS Visio 2013. Your diagram should use Crows Foot Notation. The following are details describing the five entities of your database: Column Name Data Type Allow Nulls ID Firstname Lastname StreetAddress City State Zip Phone Email int nvarchar(30) nvarchar(30) nvarchar(50) nvarchar(30) nvarchar(20) nvarchar(10) nvarchar(15) nvarchar(30) The Customers Entity