O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Entities and attributes

After creating the new model, we are now in a position to create all the entities and attributes that we need to manage our store data. However, before doing this, we need to plan what entities and attributes are needed. This can be summarized by the following table:

Entity name

Attribute name

Domain attribute

Description

Store

Name

N

The name of a store, for example, "Adventure Works Seattle"

Code

N

The unique identifier for each Store member

 

SquareFootage

N

The total floor space of a store

 

StoreType

Y

The type of store, such as Retail or Outlet

 

City

Y

The city where the store is located

 

PostalCode

N

The zip code of the store

 

TelephoneNumber

N

The store's central telephone number

 

FaxNumber ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required