Click here to Skip to main content
15,893,564 members
Search within:


Articles / Web Development / HTML
 

Design and Develop a website using ASP.NET MVC 4, EF, Knockoutjs and Bootstrap : Part - 2

Rate me:
Please Sign up or sign in to vote.
4.92/5 (74 votes)
13 Jan 2013CPOL10 min read 218.8K   15.7K   168  
Design a website architecture that must be simple, easily understandable by any web designer using asp.net MVC, EF, Knockoutjs and Bootstrap
 
USE [master]
GO
/****** Object:  Database [Application_DB]    Script Date: 01/07/2013 12:54:41 ******/
CREATE DATABASE [Application_DB] ON  PRIMARY 
( NAME = N'Profile', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Application_DB.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Profile_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Application_DB.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [Application_DB] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Application_DB].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [Application_DB] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Application_DB] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Application_DB] SET ARITHABORT OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Application_DB] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Application_DB] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Application_DB] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Application_DB] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Application_DB] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Application_DB] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Application_DB] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Application_DB] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Application_DB] SET  DISABLE_BROKER
GO
ALTER DATABASE [Application_DB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [Application_DB] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Application_DB] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Application_DB] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Application_DB] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Application_DB] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [Application_DB] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [Application_DB] SET  READ_WRITE
GO
ALTER DATABASE [Application_DB] SET RECOVERY FULL
GO
ALTER DATABASE [Application_DB] SET  MULTI_USER
GO
ALTER DATABASE [Application_DB] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Application_DB] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'Application_DB', N'ON'
GO
USE [Application_DB]
GO
/****** Object:  Table [dbo].[Profile]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Profile](
	[ProfileId] [int] IDENTITY(1,1) NOT NULL,
	[FirstName] [nvarchar](50) NOT NULL,
	[LastName] [nvarchar](50) NOT NULL,
	[Email] [nvarchar](50) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Profile] PRIMARY KEY CLUSTERED 
(
	[ProfileId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PhoneType]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PhoneType](
	[PhoneTypeId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_PhoneType] PRIMARY KEY CLUSTERED 
(
	[PhoneTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Phone]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Phone](
	[PhoneId] [int] IDENTITY(1,1) NOT NULL,
	[Number] [nvarchar](25) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Phone] PRIMARY KEY CLUSTERED 
(
	[PhoneId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[AddressType]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AddressType](
	[AddressTypeId] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_AddressType] PRIMARY KEY CLUSTERED 
(
	[AddressTypeId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Address]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Address](
	[AddressId] [int] IDENTITY(1,1) NOT NULL,
	[AddressLine1] [nvarchar](100) NOT NULL,
	[AddressLine2] [nvarchar](100) NOT NULL,
	[Country] [nvarchar](50) NOT NULL,
	[State] [nvarchar](50) NOT NULL,
	[City] [nvarchar](50) NOT NULL,
	[ZipCode] [nvarchar](15) NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_Address] PRIMARY KEY CLUSTERED 
(
	[AddressId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProfilePhone]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfilePhone](
	[ProfilePhoneId] [int] IDENTITY(1,1) NOT NULL,
	[ProfileId] [int] NOT NULL,
	[PhoneId] [int] NOT NULL,
	[PhoneTypeId] [int] NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ProfilePhone] PRIMARY KEY CLUSTERED 
(
	[ProfilePhoneId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ProfileAddress]    Script Date: 01/07/2013 12:54:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProfileAddress](
	[ProfileAddressId] [int] IDENTITY(1,1) NOT NULL,
	[ProfileId] [int] NOT NULL,
	[AddressId] [int] NOT NULL,
	[AddressTypeId] [int] NOT NULL,
	[Created] [datetime] NOT NULL,
	[CreatedBy] [nvarchar](50) NOT NULL,
	[Updated] [datetime] NOT NULL,
	[UpdatedBy] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ProfileAddress] PRIMARY KEY CLUSTERED 
(
	[ProfileAddressId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF_Profile_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Profile_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Profile_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Profile_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Profile] ADD  CONSTRAINT [DF_Profile_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_Phone_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Phone_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Phone_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Phone_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Phone] ADD  CONSTRAINT [DF_Phone_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_Address_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_Address_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_Address_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_Address_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[Address] ADD  CONSTRAINT [DF_Address_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_ProfilePhone_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_ProfilePhone_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_ProfilePhone_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_ProfilePhone_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone] ADD  CONSTRAINT [DF_ProfilePhone_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  Default [DF_ProfileAddress_Created]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_ProfileAddress_CreatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_CreatedBy]  DEFAULT (suser_sname()) FOR [CreatedBy]
GO
/****** Object:  Default [DF_ProfileAddress_Updated]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_Updated]  DEFAULT (getdate()) FOR [Updated]
GO
/****** Object:  Default [DF_ProfileAddress_UpdatedBy]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress] ADD  CONSTRAINT [DF_ProfileAddress_UpdatedBy]  DEFAULT (suser_sname()) FOR [UpdatedBy]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_Phone]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_Phone] FOREIGN KEY([PhoneId])
REFERENCES [dbo].[Phone] ([PhoneId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_Phone]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_PhoneType]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_PhoneType] FOREIGN KEY([PhoneTypeId])
REFERENCES [dbo].[PhoneType] ([PhoneTypeId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_PhoneType]
GO
/****** Object:  ForeignKey [FK_ProfilePhone_Profile]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfilePhone]  WITH CHECK ADD  CONSTRAINT [FK_ProfilePhone_Profile] FOREIGN KEY([ProfileId])
REFERENCES [dbo].[Profile] ([ProfileId])
GO
ALTER TABLE [dbo].[ProfilePhone] CHECK CONSTRAINT [FK_ProfilePhone_Profile]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_Address]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_Address] FOREIGN KEY([AddressId])
REFERENCES [dbo].[Address] ([AddressId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_Address]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_AddressType]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_AddressType] FOREIGN KEY([AddressTypeId])
REFERENCES [dbo].[AddressType] ([AddressTypeId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_AddressType]
GO
/****** Object:  ForeignKey [FK_ProfileAddress_Profile]    Script Date: 01/07/2013 12:54:42 ******/
ALTER TABLE [dbo].[ProfileAddress]  WITH CHECK ADD  CONSTRAINT [FK_ProfileAddress_Profile] FOREIGN KEY([ProfileId])
REFERENCES [dbo].[Profile] ([ProfileId])
GO
ALTER TABLE [dbo].[ProfileAddress] CHECK CONSTRAINT [FK_ProfileAddress_Profile]
GO




/******Master Table Entry ******/

INSERT INTO [Application_DB].[dbo].[AddressType] ([Name])VALUES ('Billing Address')
INSERT INTO [Application_DB].[dbo].[AddressType] ([Name])VALUES ('Shipping Address')

INSERT INTO [Application_DB].[dbo].[PhoneType] ([Name]) VALUES ('Home Phone')
INSERT INTO [Application_DB].[dbo].[PhoneType] ([Name]) VALUES ('Work Phone')

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Anand Ranjan Pandey
Software Developer (Senior)
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

Permalink
Advertise
Privacy
Cookies
Terms of Use
Layout: fixed | fluid

Posted 13 Jan 2013

Article Copyright 2013 by Anand Ranjan Pandey
Everything else Copyright © CodeProject, 1999-2024

Web04 2.8:2024-04-02:1