Search the web
Sign In
New User? Sign Up
phpexperts
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Message search is now enhanced, find messages faster. Take it for a spin.

Best of Y! Groups

   Check them out and nominate your group.

Messages

  Messages Help
Advanced
Help regarding a project (please read)   Message List  
Reply Message #13273 of 13397 |
Re: Help regarding a project (please read)

So, is this like a school project or something? This study is assuming that
there is an existing system, and therefore database it relies on, in place. If
that is true then it doesn't make sense to design a new database from scratch
without at least looking at the existing one. Anyway it seems that at the very
least you should have a table for your inventory with

id : int Primary Key
price : decimal // or float if you prefer
item number : int //though they may have letters, spaces, or dashes so you may
have to instead use varchar
color: varchar
size : varchar
misc_info : blob

I can't say I'm really sure what belongs in the retail transaction file. I would
assume a simple log of transactions in which case every transaction would have
it's own ID in order to facilitate returns and invoices. As for the department
number it's not clear where that goes. I also have a problem with

--"items that are either too small or too bulky to carry price tickets are
assigned article numbers. Goods sold or returned must bear an article number in
order to be properly processed."

As it implies that items sold may, or may not have an article number, but only
items with article numbers can be returned.




Tue Nov 24, 2009 3:34 am

se_lain
Offline Offline
Send Email Send Email

Message #13273 of 13397 |
Expand Messages Author Sort by Date

i have a vague project.. and im just laughing everytime i read it..:)) i've already consulted some programmers and DBMS experts and they just tease the author...
Richard Navarro
xintellysaiv
Online Now Send Email
Nov 10, 2009
5:02 am

Richard, I've read through the project and it reads like one of my masters class projects. You asked for suggestions, comments, conclusions .. but in reading...
Michael
enetarch
Online Now Send Email
Nov 10, 2009
4:26 pm

... ahh ok.. because i cant really understand the problem.. some transactions are indirect to the point... and the complaints are quite impossible to happen.....
xintellysaiv
Online Now Send Email
Nov 13, 2009
6:09 am

So, is this like a school project or something? This study is assuming that there is an existing system, and therefore database it relies on, in place. If that...
se_lain
Offline Send Email
Nov 24, 2009
11:28 am
Advanced

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help