Database Development and Design Course Work – Black Country Bespoke Furniture

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.

Skills: Database Programming, SQL

See more: furniture design course, design layout template case study, website design development online course cebu, 100 work mousepad design, work 100 work mousepad design, gds integration development design price, folded sample work graphic design, open university graphic design course gujarat, black white logo design, web design course thiruvalla, web design course trivandrum, website design course belgrade, instructional design course philippines, black white vector design, development design, excel work sheet design

About the Employer:
( 0 reviews ) Birmingham, United Kingdom

Project ID: #13858654

20 freelancers are bidding on average £175 for this job


Hello there, i'm expert on database designing also implementation, with your description, i've done many project like this before, design the database, implement it on oracle, populate data, queries and with the screen More

£180 GBP in 3 days
(133 Reviews)

HI Hello Sir, We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us More

£150 GBP in 3 days
(4 Reviews)

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 simil More

£300 GBP in 5 days
(7 Reviews)
£150 GBP in 3 days
(9 Reviews)

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 o More

£250 GBP in 3 days
(3 Reviews)

we have expertise in sql,dba,data processing. clients satisfaction is our main motto for long term relationship.

£100 GBP in 3 days
(13 Reviews)

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 More

£177 GBP in 3 days
(4 Reviews)
£96 GBP in 3 days
(4 Reviews)

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 Reviews)

HI. I am Softwares engineer and programmer. I had completed more than 60+ projects. I had completed desktop and webbased [login to view URL] can review my profile page for more info. I am ready to start that project. If you h More

£277 GBP in 3 days
(1 Review)

A proposal has not yet been provided

£44 GBP in 3 days
(1 Review)

- 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 Or More

£250 GBP in 7 days
(0 Reviews)
£150 GBP in 3 days
(0 Reviews)

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 More

£150 GBP in 3 days
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have c More

£221 GBP in 6 days
(0 Reviews)

Hi, We are a team of Moodle experts having combined experience of more than 7-8 years in E-learning platform :- Moodle , SuiteCRM, Joomoodle, Mahara, Blackboard, custom LMS, WebCT, "SCORM", Salesforce, SugarCRM etc. More

£315 GBP in 5 days
(0 Reviews)
£150 GBP in 3 days
(0 Reviews)

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 resu More

£207 GBP in 6 days
(0 Reviews)

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 Reviews)

Hello, I am very interested in the project and you would like to apply to it. I'm a web developer with 7 years experience in PHP, MYSQL, CSS3, HTML5 and deep knowledge Wordpress, WP pluggin, development issues More

£150 GBP in 3 days
(0 Reviews)