Site Maintenance this evening The site will be offline for hosting changes. Time TBC

+ Post New Thread
Results 1 to 9 of 9
Group Project Thread, Purchasing database project in Coding and Web Development; Since we are a British Int'l School, most of our teachers are Brits but our support staff came from many ...
  1. #1
    artsaudi's Avatar
    Join Date
    Jan 2009
    Location
    Jeddah, Saudi Arabia
    Posts
    28
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Purchasing database project

    Since we are a British Int'l School, most of our teachers are Brits but our support staff came from many different countries. Our School purchasing dept purchased almost the same kind of stuff from stationaries to cleaning materials. A British teacher will request some kind of a stationary and the same kind of stationary was ordered also by a non British support staff but it was named it differently. Our purchaser who is American always get confused and most of time buy different kind of stationary.

    Now our SMT tasked me to create a database for the Purchasing Dept which will solve this problem. It has to contain a photo for each item and the detailed description with all the names it can be called and must be searchable either by description or name. The database will be published on the intranet and it has to contain a search bar, for searching the item. I know only MS Access but it has been a long time since I created a database.

    Does anyone has a suggestion on how to tackle this project? Or is there any existing database of the same kind you can recommend?

    Thanks in advance.

  2. #2
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Well there are a few things youneed to look at:

    1 - you need to have a method of uploading the photo and storing it, do this in a folder and have a colum in your product table with the path to the photo NEVER store the photo in the database it slows the whole thing right down.

    2 - You will be looking at having a table for the items, a table for suppliers linked to your items.

    3 - you are going to need a way to administer the database base, I would not advise editing the database directly, some sort of admin area to add all the details.

    4 - What programming langauge are you going to use ASP or PHP?

    5 - If it is going to be published on the intranet do you want all to have access or is it restricted?

    That should keep you going for a while, shout if you need anymore help.

  3. Thanks to ICTNUT from:

    artsaudi (27th May 2009)

  4. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,139
    Thank Post
    860
    Thanked 2,692 Times in 2,282 Posts
    Blog Entries
    9
    Rep Power
    771
    You could just use an opensource or cheap e-commerce site type settup as this would provide all the features that you are after. This should be able to generate a purchase list which can go to the supplier.

  5. Thanks to SYNACK from:

    artsaudi (27th May 2009)

  6. #4

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,457
    Thank Post
    645
    Thanked 1,612 Times in 1,443 Posts
    Rep Power
    419
    maybe a good idea as an addition to mlh oz. Having supplier info in makes it like a crm for schools.

  7. #5

    john's Avatar
    Join Date
    Sep 2005
    Location
    London
    Posts
    10,528
    Thank Post
    1,496
    Thanked 1,050 Times in 919 Posts
    Rep Power
    303
    I would go for the ecommerce shop Idea. Set a server up with Joomla on it and put an e-commerce system on that (free ones are out there) and that should be a good solution for you,

  8. #6
    artsaudi's Avatar
    Join Date
    Jan 2009
    Location
    Jeddah, Saudi Arabia
    Posts
    28
    Thank Post
    6
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Quote Originally Posted by SYNACK View Post
    You could just use an opensource or cheap e-commerce site type settup as this would provide all the features that you are after. This should be able to generate a purchase list which can go to the supplier.

    Its a good idea, thank you. I will try to find one or do you have one to recommend?

  9. #7
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62
    Quote Originally Posted by plexer View Post
    maybe a good idea as an addition to mlh oz. Having supplier info in makes it like a crm for schools.
    Its a requirement of the Asset Management addon

  10. #8

    Join Date
    Nov 2010
    Location
    kellyj994
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by ICTNUT View Post
    Well there are a few things youneed to look at:

    1 - you need to have a method of uploading the photo and storing it, do this in a folder and have a colum in your product table with the path to the photo NEVER store the photo in the database it slows the whole thing right down.

    2 - You will be looking at having a table for the items, a table for suppliers linked to your items.

    3 - you are going to need a way to administer the database base, I would not advise editing the database directly, some sort of admin area to add all the details.

    4 - What programming langauge are you going to use ASP or PHP?

    5 - If it is going to be published on the intranet do you want all to have access or is it restricted?

    That should keep you going for a while, shout if you need anymore help.

    Thanks you for the post


    .

  11. #9

    Join Date
    Nov 2010
    Location
    kellyj994
    Posts
    2
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by john View Post
    I would go for the ecommerce shop Idea. Set a server up with Joomla on it and put an e-commerce system on that (free ones are out there) and that should be a good solution for you,

    Thanks you for the post.




    __________________
    Watch Love And Other Drugs Online Free

SHARE:
+ Post New Thread

Similar Threads

  1. Anyone have any experience with purchasing telecoms?
    By Disease in forum How do you do....it?
    Replies: 32
    Last Post: 16th May 2008, 10:37 PM
  2. Help With Purchasing An External Hard Drive
    By aliv25 in forum Windows
    Replies: 11
    Last Post: 27th September 2007, 02:39 PM
  3. Replies: 4
    Last Post: 28th February 2007, 09:37 AM
  4. Purchasing SSL Certificates
    By Dos_Box in forum Wireless Networks
    Replies: 3
    Last Post: 3rd January 2007, 03:33 PM
  5. Crescent Purchasing Consortium - edu discounts
    By pete in forum Budgets and Expenditure
    Replies: 0
    Last Post: 12th June 2006, 12:06 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •