Translation: Using ASP. NET MVC 4, EF, Knockoutjs and Bootstrap design and development site-5-Database design

The main functions we need in terms of database are as follows:

• The contact has a name and e-mail address.
• A contact can have more than one address.
• Contacts can have multiple phones.

In order to achieve the goal, we need to create the following tables in the database.

The table-to-table relationship is as follows:

The database script can be downloaded directly from here: Application_db.sql

Article posted: http://www.cnblogs.com/haogj/

Translation: Using ASP. NET MVC 4, EF, Knockoutjs and Bootstrap design and development site-5-Database design