Database Development

Closed Posted Oct 24, 2011 Paid on delivery
Closed Paid on delivery

INTERNATIONAL PRODUCTION COMPANY

An International Production Company (IPC) manufactures goods for customers. The IPC wants a computer based information system to store the data necessary to manage the customers, products and employees.

The operations of IPC are along the following lines.

IPC has many customers who are located internationally in a specific sales area. These sales areas (identified simply by an ID number) are services by a number of salespeople. Each salesperson has their name, telephone number and a special salesperson number recorded so they can be uniquely identified. The customer on the other hand is uniquely identified by a number, and also has their name, address, email address and telephone number recorded. Email address is used to send details of any special offers for loyal customers.

Each customer can place many orders. Currently the salesperson records the details about the order number and the date it was created. The salesperson also writes down the number of a particular product required. The customer identifies the product by a product number. Each product has a description, and will have a particular finish and an associated price. Each product must have a minimum quantity on hand, which is decided by the manager. Whenever, the quantity on hand falls below the minimum level, it must be notified to the concerned staff so that they can start production, there by requesting for more raw materials from vendors

Each product is manufactured from multiple raw material components. IPC records details of the raw material’s cost, name and the minimum unit of manufacture. It would also be appropriate to record a raw material identification number as well. IPC sources these raw materials from many vendor organisations that are often able to supply the same raw material. In this way IPC is able to select the cheapest price for the raw materials which assists them in their overall profit. Details of the vendor must be recorded including their name and address.

Finally IPC wants to keep track of their employees who work on putting each particular product together from the various raw materials. Each employee has a particular skill and this is recorded against their employee number and their name. Employees are assigned to a particular work area in a particular location of the plant. These work areas are responsible for putting together the final products and typically they contain up to ten people. Every month an employee can be expected to be transferred to another work area.

In addition, IPC needs the following reports to be produced.

1. List of all salesperson’s details like address, contact phone number etc

2. Report showing all the products sold by all salespersons.

3. List of all raw materials details needed for each product.

4. A report showing employee details and their history of work assigned.

An XML document showing details of products and their raw materials. This XML document can be sent to raw materials vendor. In order to do this you must be familiar with XQuery and you need to have Oracle DBMS installed.

Oracle

Project ID: #1261673

About the project

11 proposals Remote project Active Nov 28, 2011

11 freelancers are bidding on average £179 for this job

hitgon

DBA and Developer More then 4.7 Year Production DBA Experience Oracle9i/10g/11g OCP Certified DBA

£100 GBP in 1 day
(1 Review)
1.0
kyigin

With more than 10 years experince on Oracle database and development tools , i can prepare a good system on Oracle APEX. APEX is a new web based development environment framework which works on oracle Database. I'm c More

£500 GBP in 30 days
(0 Reviews)
0.0
gajera

I am Oracle certified Programmer. Along with I have plenty of skill to complete this project. because working as a oracle developer since many years. Hoping for the early and positive response from your side. I go thro More

£100 GBP in 5 days
(0 Reviews)
0.0
roopamumbai

Hi, I hereby submit my bid for the Project. I have very strong experience building application using .Net Technologies with ORACLE Back end database. I have 10+ years experience in software development. If s More

£200 GBP in 10 days
(0 Reviews)
0.0
jitendersingh28

Hi, I am a Oracle10g Certified DBA and Developer, working with an IT company on production servers. I believe that my interests and credentials will match with your requirement. I am the best Freelancer for this proj More

£120 GBP in 10 days
(0 Reviews)
0.0
kala2011

I understood your requirement fairly. I am a Technical lead works in Oracle technologies (Oracle PLSQL, Pro*c, Oracle Forms). Working in Telecom / Financial domain. I have worked on similar projects before. I.e. Point More

£170 GBP in 15 days
(0 Reviews)
0.0
suy123

I'm working as a Software Engineer in leading company in Sri Lanka. I'm having confidence to go ahead with this project. I'm doing Oracle forms, Reports, PL/SQL 9i, 10 g and 11g in last five years.

£250 GBP in 15 days
(0 Reviews)
0.0
manojbansallx

HI I am pretty sure that i can very easily accomplish this project within the required time.I have already handled such kind of project .

£200 GBP in 45 days
(0 Reviews)
0.0
lxeitprofes

Hello, I looked at the job detail. My expertise is in Oracle 7/8/9i/10g/11g, SQL Server 2000/2005/2008, database design etc. I have developed several ERP applications from scratch for various clients. - My ex More

£100 GBP in 7 days
(0 Reviews)
0.0
rosdidier

I am Oracle certified Programmer (10gR2 OCP + 10gR2 RAC).I work as a oracle DBA since many years in a leading company in France. I can build your own web site with all the functionalities you want.

£150 GBP in 10 days
(0 Reviews)
0.0