Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype.

Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype. 1) Create 2 tables to store DNS info 2) Create a simple asp.net administrative screen 3) Setup Simple DNS Plus in your development environment (<[login to view URL]>) 4) Setup MS SQL Server "Plus" Plugin-in (<[login to view URL]>) in your local environment 5) Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup) ## Deliverables **Summary:** Create a web configurable dns administrative interface using asp/vb.net, Simple DNS and SQL Server. This is only a prototype. See attached details. 1) Create 2 tables to store DNS info 2) Create a simple asp.net administrative screen 3) Setup Simple DNS Plus in your development environment (<[login to view URL]>) 4) Setup MS SQL Server "Plus" Plugin-in (<[login to view URL]>) in your local environment 5) Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup) **Detailed:** *Create 2 tables to store DNS info* I have created two tables to be used for this project called ctm_domains and ctm_domainrecords. The schema is shown below: CREATE TABLE [ctm_domains]( [hMy] [int] IDENTITY(1,1) NOT NULL, [sDomainName] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [sDesc] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_ctm_domains] PRIMARY KEY CLUSTERED ( [hMy] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [ctm_domainrecords]( [hMy] [int] IDENTITY(1,1) NOT NULL, [hDomain] [int] NOT NULL, [iRecordType] [int] NOT NULL, [sHost] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [sPointsTo] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [iMXPriority] [int] NULL, [iTTL] [int] NULL, CONSTRAINT [PK_ctm_domainrecords] PRIMARY KEY CLUSTERED ( [hMy] ASC )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] ctm_domains = Master table to store main domain (i.e. [login to view URL]) [login to view URL] = ID column [login to view URL] = Domain name (i.e. [login to view URL]) [login to view URL] = Domain description (i.e. Microsoft main domain) ctm_domainrecords = Child table to store actual records [login to view URL] = ID column [login to view URL] = pointer to [login to view URL] [login to view URL] = type of record (a, cname, mx) [login to view URL] = the host that is being queried (i.e. [[login to view URL]][1] or [[login to view URL]][2], or [login to view URL]) [login to view URL] = the IP address of the target (i.e. [login to view URL]) [login to view URL] = for mx type records only (i.e. 10, 20, 30, 40) [login to view URL] = time to live for each record (i.e. 1hr, 1day, 1week) *Create a simple asp.net administrative screen* Create a simple web 2.0/ajax/jquery web interface that writes and reads to the two tables defined above. I've added some screenshots of suitable interfaces. This does not need to be fancy, just needs to work: *Setup Simple DNS Plus in your development environment AND Setup MS SQL Server "Plus" Plugin-in* This is fairly self explanatory. You will need to install and configure both, including defining the sql server to be used by Simple DNS plugin to get records. Create a very simple document (no more than a page or two) with some screenshots and description on how to set this up in our own environment. *Demonstrate the ability to create a record in administrative screen and query said record (i.e. from nslookup* This is self explanatory too.