Find Jobs
Hire Freelancers

Database Development and Design Course Work – Black Country Bespoke Furniture

£20-250 GBP

Closed
Posted almost 7 years ago

£20-250 GBP

Paid on delivery
1. Using the supplied case study and supplied set of relations, perform each of the specified programming tasks in order. The tasks are at the end of this assessment brief. You should attempt each task as follows: 2. Read the task with care – be sure what you are doing. 3. Using your Oracle/SQL*Plus account, write the code to satisfy the specified task. 4. Take a clear screenshot of the working code, the output or confirmation message (such as TABLE CREATED) and your user ID. You can display your user ide by typing the command: SHOW USER at the SQL> command line. 5. Each screenshot must contain your user ID to prove it is your own work. (see above) 6. Copy this screenshot into your assignment document. 7. Make sure you label all screenshots so that we know which task it refers to. 8. Then annotate each screenshot with a brief explanation of what it does. 9. Move onto the next task and repeat the above steps. 10. Once all tasks are complete, make sure the module name, assignment name, your name and ID are on the front page. 11. Submit the assignment through Moodle. Case Study – Black Country Bespoke Furniture (BCBFL) Black Country Bespoke Furniture Limited is a company based in Stourbridge in Worcestershire, which specialises in manufacturing and selling bespoke furniture to the domestic home market. It makes furniture such as tables, chairs, wardrobes, beds and so on, to order. A Customer places an order with the company for a particular product, such as a dining room table. The Customer Order consists of the customer’s name, the customer’s address, the product(s) ordered, the quantity of each product ordered, the order date, the order status (e.g. pending, confirmed, dispatched, paid), and the total cost of the order. It is identified by a unique Customer Order Number. The Customer Order is then sent to the manufacturing department which then makes the product from a Works Order, using standard stock items. A Works Order consists of what Product is required, how many are required, when they are required, when they have been completed, the individual Stock Items needed to make the Product (for example, a dining room table consists of a table top and four table legs, and a dining room chair consists of a chair back, a chair seat and four chair legs) and the instructions for making the Product. It is identified by a unique Works Order Number. To be able to process Customer Orders and Works Orders, BCBFL’s ordering system also needs to store information about Customers, Products and Stock Items.
Project ID: 13858654

About the project

19 proposals
Remote project
Active 7 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
19 freelancers are bidding on average £175 GBP for this job
User Avatar
we have expertise in sql,dba,data processing. clients satisfaction is our main motto for long term relationship.
£100 GBP in 3 days
4.9 (22 reviews)
5.3
5.3
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
£250 GBP in 3 days
5.0 (9 reviews)
5.4
5.4
User Avatar
Hi there, I have strong knowledge in database development. I have read the details and it must be an easy job for me as I have already done similar projects previously. Please have a look at my profile to view similar projects and reviews. Message me, we can discuss over chat.
£300 GBP in 5 days
5.0 (19 reviews)
5.0
5.0
User Avatar
Hi, i have over 7 years of experience as a database developer using oracle and mysql. i have completed several similar projects like this. I can create the database, create the sql queries, show the output using the sql plus screenshots. Furthermore, i can create the final assignment report with the description of each step involved. I can start this work right away. All my clients were 100% satisfied with my work as they gave me positive feedback.
£177 GBP in 3 days
5.0 (6 reviews)
3.9
3.9
User Avatar
A proposal has not yet been provided
£44 GBP in 3 days
4.8 (9 reviews)
4.0
4.0
User Avatar
Hi, I am expert in Databases, Oracle Certified Professional. Can design and model databases. Can do the task as per your requirements with complete accuracy.
£100 GBP in 5 days
3.6 (3 reviews)
2.6
2.6
User Avatar
Hi, I've worked as an Oracle DBA for years, very skilled at designing DB structure and development. I'm glad if I can help.
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the results that you have expected and we have already worked on a similar project before and can deliver as u have mentioned We are sure you will not be disappointed if you give us this opportunity. Our team is experienced, creative & efficient enough to get your job done well. We have an impeccable record and all our clients enjoy working with us, we are sure that you will too, our prices are cheapest in market. [Removed for encouraging offsite communication which is against our Terms and Conditions.] for further discussion about the project I am ready to discuss with you with best Regards
£207 GBP in 6 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 8 years of work experience working in a reputed MNC as a Database Lead, main skill set is Sql Server 2005/2008/2012, MYSQL Oracle (PL/SQL), MSBI, Data analytics using R-Programming and SAAS. I would be able to deliver your solution within the timeline with better quality
£150 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
- I have close to 20 years exp in database design using Erwin, ER Studio, Sybase Power Designer etc - Have designed closed to 100+ Data Models for various industries both for OLTP / OLAP systems - very proficient in Oracle Database
£250 GBP in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Birmingham, United Kingdom
0.0
0
Payment method verified
Member since Apr 19, 2016

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.