Find Jobs
Hire Freelancers

Draw an ERD " Entity-Relation Diagram"

$10-30 USD

Closed
Posted about 10 years ago

$10-30 USD

Paid on delivery
I have a homework that's due at 11 pm. EST I would like to have someone help me with it. Swamp Things (ST) is a company that sells exclusive swamp-related items over the Internet. Customers go to ST's web site and select items from an online catalogue (much like [login to view URL]). Once they have selected the items that they wish to purchase, they enter in their Customer information (if they are a returning customer, they can just enter in their Customer Num). The customer pays by credit card, via an online checkout process run by an independent entity (ST does not need to track the credit card information). The system creates an invoice like that shown below - this is mailed to the customer with their products. At the end of each month, ST's management generates a report showing total sales for the month (broken down by Product). Also at the end of each month, the management needs a printout of each Customer's purchases for the month. When a sale is made, ST's employees take the items out of inventory and send them to the customer. Products are one of two types - perishable and non-perishable. For all perishable products, ST needs to track the expiration date for the product. The Product Number is on a bar code that is read into the system. The program automatically updates the inventory numbers when a product is sold. When a product reaches an inventory level of less than five items in stock, the program automatically contacts a supplier of that product via EDI. Multiple suppliers provide each product, but each supplier only provides one product. ST keeps track of each supplier's name and all phone numbers. When the products arrive at ST, the bar codes are scanned in and the program updates the inventory levels. Invoice Invoice Number: 1234 Order Date: September 1, 2014 Customer Name: Adam Lefondre Customer Number: 330 Product Num Product Desc. Price Quantity Total Cost ST22 Slime $8.00 3 $24.00 ST44 Leaves $10.00 4 $40.00 Total Due: $64.00 Questions: *Draw an ERD that shows the necessary data components for the database in ST's new system. *If you make assumptions (which you should keep to an absolute minimum!), make sure to list them in detail. *Include all calculated fields needed to create the Invoice shown above. I will only pay $7 that's include the freelancer.com fees! "No more, No less"!!
Project ID: 5441778

About the project

8 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $73 USD for this job
User Avatar
Aucune proposition n'a encore été fournie.
$100 USD in 1 day
4.9 (20 reviews)
4.9
4.9
User Avatar
Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database and Design skills. I am focused mostly on doing computer science homework here in freelancer.com and I would like to help you get this project done if you would give me the opportunity. I am a computer science professor and practitioner and this assignment is one of the fields that I teach very well so I can assure you an accurate result. Let me know if you are interested so I can have further details. Thanks.
$10 USD in 0 day
5.0 (26 reviews)
4.4
4.4
User Avatar
Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 7 years of experience. I am expert in database design. ERD, DFD, Physical schema, normalization etc. I did lots of similar projects in freelancer. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/nibiranijum.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq
$25 USD in 1 day
4.8 (14 reviews)
4.7
4.7
User Avatar
Hi, I am database expert and can surely help you here with this project, Please communicate to discuss further. Thank you
$69 USD in 2 days
4.5 (18 reviews)
4.0
4.0
User Avatar
Hi, I'm very interested helping you creating and designing your database,I have more then 7 years of experience in SQL and database administration, modeling, optimizing and manipulating, I've checked your requirement I can do this job in the deadline without a problem, because I've done many projects like this. I'm available, and can start immediately. Looking forward to working with you. Thank you for your consideration. Regards
$80 USD in 1 day
5.0 (3 reviews)
1.8
1.8
User Avatar
La propuesta todavía no ha sido proveída
$222 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
dude seriously only 7$ for this project??? no body will do it for just 7$... its an ERD the design... you know that thinking and making it ... its a little bit tough job...and you need it tomorrow... okey if you can pay me 25$ then i can do it for you...
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey! i will apply all of my expertise to satisfy your desire in the given time. I ensure that your work would be sound quality wise. I hope i get this!
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
riyadh, United States
5.0
27
Payment method verified
Member since Feb 8, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.