How do we design a database for interacting with an ASP.Net web page with ADO.Net?

Question

Suppose we want to design a web page using ASP.Net, ADO.Net and C#/VB.Net. How do we design a database that would be needed for the web page to interact with, that is to either get data from, or to store data in the database. What are the things that we would need to consider while designing the database?


Please be as detailed as you can...

One of the things that I was wondering about was if the database needed to be normalized. Because isn't normalization usually very important when it comes to databases. Or if there was anything else that we need to consider while designing it.

I'm not really good with databases and so that's why I'm asking.

Answer 1

the database design depends on what your webpage does, if your page collect user info, then design a table to store those info specifically, usually table fields reflects webpage form fields...

that's really all there is to it.

Answer 2

From a database perspective, there's nothing you need consider. Whether you have one table with only one data field or 100 tables with several columns in each, the web page interacts with the database through a query.

So design your database to store the data you want, as much or as little. Then design the queries to SELECT that data, UPDATE it or DELETE it.

Answer 3

asp.net supports all commonly used and popular the databases

i think u r asking about how to connect to a database using ado.net

all u need is to use proper connection string ,
which depends on the database u are using , it will be different for different databases

u can search on google about connection string for your database name

hope it helps u

Answer 4

if u design a database u will know abt manditory fieds and optional fields..!!!!
for example in music upload table name is xUploadMusic
have xmpMusicName,xmpMusicType,xmpMusicID,xmpMusicOwner......(it will be primarykey and auto incriment)
do u know mor please mail me [e-mail]