Show Bid Request DATABASE NORMALISTION AND CREATION Bid Request Id: 42731 Bookmark in my 'To Do' list Posted by: BLUEEEYES (4 ratings) (Software buyer rating 10) Non-action Ratio: Very Good - 12.50% Buyer Security Verifications: Good Approved on: Jan 8, 2003 11:32:15 AM EDT Bidding Closes: Jan 10, 2003 EDT Viewed (by coders): 138 times Deadline: 1/13/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, Access Enter chat room for this bid request (0 active users at Jul 12, 2003 10:10:36 AM EDT) Description: Adams confectionary wholesalers supplies a range of products to 300 wholesalers in England. Currently orders are recieved by post. The data is then transfered hopefully to our new database. The database must be written in Ms Access and should contain the below fields. The fields are as yet un-normalised however they must firstly be normalised to third normal form and primary keys identified for each table. secondly create the database in Ms Access from the normalised data, ensure that referential integrity is applied allowing, update, insert and delete. Enter some sample data to get started! (coders may be adlib here..data will be removed later by me) UNNORMALISED FEILDS: Customer ID (Number), Customer Forename, Customer Surname, Street, Town, Postcode, Debit (currency), credit (currency), Assistant ID (number), surname, forename, Order ID (number), Order date, item ref (number), quantity, item decription, unit price (currency), Number in stock, Catalogue Page (number) Credit is set in £500 increments. Each assistant is resoponsible for many customer accounts. There are 10 assistants numbered 1-10. Deliverables: 1) Complete and fully-functional working database in Ms Access fulfilling all the parameters outlined above. Feilds must be normalised to third normal form. Database designer can make as many assumptions here as he or she wants. All curency values are in pounds remember! 2) Documentation showing the logical progression form un-normalised to third normal form. May be delivered as a word document for example. Platform: Must run on Windows XP Must be 100% finished and received by buyer on: Jan 13, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! CSRao (16 ratings) in Hyderabad, Andhra Pradesh India Bid id: 462,378   $75 (USD) Jan 8, 2003 12:00:25 PM EDT  10 (Excellent)     Hi I have gone through your requirement and I am very confident of giving you the right solution. I can provide you the complete database structure normalized to NF3 with in one day of bid acceptance. Thanks CSRao           See 2 private reply(ies) to/from CSRao.