Need help with a web designer's database

[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.

[pauldun170]

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

[pauldun170]

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)

[Particle Man]

Get off my lawn!Fixed.

[pauldun170]

Fixed.

I was just about to post this:
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

:lol:

[udman]

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]

Errrbody just slow down a second.....

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

[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?

[udman]

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.

[pauldun170]

Would you just look at this bullshit?

This jerkoff ask for help then just runs off, not posting a gatdamn thing as we try and help em out.
thats just f'n rude.

Ya gotta nod or something.
damn

[njchopper87]

I was with holding posting anymore info because I wasn't sure if anyone was interested in helping. Thanks for making this interesting. :p 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..

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.

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.

[njchopper87]

Would you just look at this bullshit?

This jerkoff ask for help then just runs off, not posting a gatdamn thing as we try and help em out.
thats just f'n rude.

Ya gotta nod or something.
damn

Haha sorry.. I wasn't expecting such a fast response and was struggling to get caught up.

As far as companies getting ousted fast.. the only programming I plan to do is on the side for fun and extra cash. I already learned that it's not a very stable career field. I'm more interested in the hardware aspect of computers.. we'll see where that takes me.

[njchopper87]

I guess to clarify more, what I really need is a basic understanding of the operations. From there I can figure out acceptable entities and attributes. I realized all too late that I should have chosen a different topic.. meh.

[pauldun170]

First
review...
http://www.scribd.com/doc/439258/5-Rules-of-Data-Normalization

basic crap but should keep in mind

# Eliminate repeating groups: Make a separate table for each set of related attributes and give each table a primary key.
# Eliminate redundant data: If an attribute depends on only part of a multivalued key, remove it to a separate table.
# Eliminate columns not dependent on the key: If attributes do not contribute to a description of the key, remove them to a separate table.
# Isolate independent multiple relationships: No table may contain two or more 1:n or n:m relationships that are not directly related.
# Isolate semantically related multiple relationships: There may be practical constraints on information that justify separating logically related many-to-many relationships.

blah blah blah blah





anywhooze

What you are trying to do is pretty straight forward.

A few things

1. A website is a product
2. Microsoft has a "bookstore" sample you can reference.

a website is one of the products you sell as a part of a suite of products\packages.
you can sell a product that contains many sub products (just like a generic sales application).
One of those sub products could be a "hosting package" or a "support package", each with its own sublist of little things.

just thinking out loud to get you thinking (and maybe getting some others to toss out ideas.)

[udman]

...and social media component? This guy will help with that:

http://www.youtube.com/watch?v=K1oRnEUAQj4&feature=player_embedded

[njchopper87]

Normalization is the next step that he's going to cover in class a couple days from now, but thank you. I can't really make out the words in that document. I don't think I have to worry though.. there's an entire chapter dedicated to it. Thanks for pointing out the microsoft site.

This is what he's having us do. Data Dictionary > Initial ERD > Normalization > Final ERD > Final Data Dictionary. Then there's the supporting documents.

I combined website and hosting package into one product table. I actually had it planned like that at first. I don't know what made me change my mind.

What you said helped a lot, I was able to walk myself through the process and I'm fairly confident in my data dictionary now. I also have a crude ERD drawn up. Done for today.. hopefully it still makes sense tomorrow.

Thanks for the help.. might have some more dumb questions later on yet. >.>

[pauldun170]

No problem. I barely even helped you. I was starting to feel guilty