Hi my name is Kirk. I just graduated from college with a degree in Computer Science. I have a broad range of knowledge of computers and programming, but not much knowledge specific to databases that will ultimately be used in a project I am working on.
I am building a website that is mainly database driven. I am trying to define a few variables before I hire someone to help me build it. I need some guidance and understanding of database design principles so I can better communicate my design to the eventual builder.
The website database contains four major categories. Each of these four unique categories has around a 100 fields that characterize it. A lot of the fields over lap for example first name, last name, zip code, phone number, etc. While there are some that are unique to only one or two of the four categories.
Initially, I thought it made sense to create four databases for each of these four categories. However, my partner suggests simply creating one large database with all fields in it and simply but NA in fields that do not apply to curtain categories.
General Overview and Parameters:
The data in this database will constantly be getting parsed depending on who is logged in and the rights that have been assigned to their account. Also, these users will be using documents that pull information from fields within the database to fill out letters such as:
From: <Field_31 >
I need a database language that allows information from fields to be pulled from it and inserted into documents such as the header above.
The database will be entirely web driven and thus accessed only from the web with multiple users concurrently accessing data, inputting data and editing data.
I need to be able to get to the database from the backend so that I can add fields and edit fields as an administrator.
I would also like to be able to create simple queries on the fly with little training.
In short we are building a database driven website with a database that we will be able to add, delete, edit and modify in all forms and fashion. All the layers of web pages in our website will be pulling different data fields from the database for different user's tasks depending on and determined by who is logged in.
1) With this in mind, what database language should this be written in and why?
2)How many databases should be created for this project?
3)On a 1-10 scale, how easy would it be to modify the database you are suggesting I use?
If anyone has some time, I would really appreciate input and advice on this topic.