Need help with a web designer's database

njchopper87 · 03-14-2011, 04:48 PM

I'm pretty sure we have a couple web designers in here.. The plan was to ask my cousin about this, but he doesn't seem interesting in lending a hand.

A little background. My class project for database is to build a database using the entity relationship model. It will be assembled in Microsoft Access. I chose to build a database for a theoretical web design company because I have some experience with it. The problem is, I found I don't have enough professional experience.

So, my questions are to you: What is the information you need to record about the creation of a website? Can you give a very brief description of going from customer to finished product?

Google only returns broad results that, while helpful, are not what I need.

Thanks in advance for any willing to help.

pauldun170 · 03-14-2011, 04:59 PM

Quote:

Originally Posted by njchopper87

I'm pretty sure we have a couple web designers in here.. The plan was to ask my cousin about this, but he doesn't seem interesting in lending a hand.

A little background. My class project for database is to build a database using the entity relationship model. It will be assembled in Microsoft Access. I chose to build a database for a theoretical web design company because I have some experience with it. The problem is, I found I don't have enough professional experience.

So, my questions are to you: What is the information you need to record about the creation of a website? Can you give a very brief description of going from customer to finished product?

Google only returns broad results that, while helpful, are not what I need.

Thanks in advance for any willing to help.

You damn kids and not doing your own damn work.

I will watch this thread and scowl for abit while I get work done.
I will then return to make rude comments mixed with helpful pointers.

I say this with hopes that someone else steps in and save me the fucking typing.

Damn kids

Particle Man · 03-14-2011, 05:05 PM

Quote:

Originally Posted by pauldun170

Get off my lawn!

Fixed.

pauldun170 · 03-14-2011, 05:07 PM

Quote:

Originally Posted by Particle Man

Fixed.

I was just about to post this:

Quote:

I'll start you off...
Can i haz company?
Can i haz employeez?
Can i haz clientz?
Can i haz projectz?
Can i haz billingz\accountzz?

but then I stopped top see if anyone posted anything first and refreshed

lo and behold

pauldun170 · 03-14-2011, 05:02 PM

FYI: Layoff the google crack pipe for a second and think entities. Get a piece of paper and right it down (piece of paper...not an ipad...not fucking visio...not some stupid utility)

udman · 03-14-2011, 05:13 PM

Quote:

Originally Posted by njchopper87

So, my questions are to you: What is the information you need to record about the creation of a website? Can you give a very brief description of going from customer to finished product?

1. Find a customer
2. Talk to customer
3. ????
4. PROFIT!!!

pauldun170 · 03-14-2011, 05:15 PM

Errrbody just slow down a second.....

njchopper87
What does a web design company do besides go out business within 2 years?

udman · 03-14-2011, 05:23 PM

Quote:

Originally Posted by pauldun170

Errrbody just slow down a second.....

njchopper87
What does a web design company do besides go out business within 2 years?

Zakly....

Every car salesman I know used to be a web designer.

njchopper87 · 03-14-2011, 05:59 PM

I was with holding posting anymore info because I wasn't sure if anyone was interested in helping. Thanks for making this interesting.

I wouldn't have posted here if I was not willing to take a verbal beating.

These are the entities I have

Employee
Customer
Project
Website
Application (probably taking this off the list)
Host (not sure if I need this with Vendor)
Vendor
Transaction

I have a rough draft of a data dictionary that I'm still making major changes to still. This project has been in the works for weeks. I can figure out the relations between the entities myself with a bit of thought. See, I feel I understand where I'm going with this, but I'm missing something blatantly obvious..

Quote:

Originally Posted by pauldun170

Errrbody just slow down a second.....

njchopper87
What does a web design company do besides go out business within 2 years?

Web design companies interact with customers, find out business rules, construct site based on said rules, and potentially host it.

Quote:

Originally Posted by pauldun170

How big does this have to be?
How many tables does your professor want you to create?

What the fuck is the scope of your project you lazy motherfucking slacker?

It is supposed to be a very small database. I understand this can be dragged out into many different entities, but he said to consolidate as much as possible. That said, what I have is enough entities. Whether they are the right ones or not is up for debate. The only restrictions he placed on tables is to try and avoid M:N.

pauldun170 · 03-14-2011, 05:23 PM

How big does this have to be?
How many tables does your professor want you to create?

What the fuck is the scope of your project you lazy motherfucking slacker?