We're Open
+44 7340 9595 39
+44 20 3239 6980

Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code

  100% Pass and No Plagiarism Guaranteed

Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure

ASSIGNMENT                                                    

COMPUTER SCIENCE AND TECHNOLOGY

 


Unit Code: CIS020-2

 

 

 

 


Unit Name :  

Systems Development and Modern Database Practices


Assignment Title:

Written report: Scenario-based Database System including SQL implementation

 


Note:  This grade is provisional until agreed by the Field Examination Board.

Work received after the date shown will not be marked and you will receive a fail grade for the unit.  The University will not accept responsibility for non-receipt of work unless the work has been returned by Recorded Delivery and proof of postage can be produced.

Please Note: Work presented in an assessment must be the student’s own. Plagiarism is where a student copies work from another source, published or unpublished (including the work of a fellow student) and fails to acknowledge the influence of another’s work or to attribute quotes to the author. Plagiarism is an academic offence.

CIS020-2: Systems Development and Modern Database practices
Referral Individual Assignment 2 Brief

CIS020-2: Individual Referral Assignment – 2 Brief

Task

Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure.

The following steps should be carried out and presented clearly in your report:

1)    You should normalise the above table, stepping through 1st normal form, 2nd normal form and 3rd normal form, explaining in detail each respective normalisation phase and justify why you have taken the steps you have. 

2)    Once you have normalised the tables, draw a full Entity Relationship (ER) diagram of the final normalised tables, using the notation specified during lectures.

3)    Write the Oracle SQL Code to create the tables and relationships identified in your normalisation (Note: There is no need to write the commands to insert the data)

Deliverables

-      Written report submission (100%)

  • Submit report using the TURNITIN in BREO and optionally a hard copy to the university assignments submissions office, adjacent to the main reception desk at Park Square.
  • Ensure an assignment top sheet is included at the start of both electronic and hard copies.

Notes:

  1. The client has requested that you do not add any additional codes/id numbers. Only use the data they have provided.
  2. You should be as efficient as possible, so only store data that you cannot calculate otherwise
  3. People can own more than one franchise
  4. VAT is a fixed tax percentage (20%) applied to all types of item
  5. The manager of a branch is always an employee of that branch
  6. Each Branch has different numbers of each item in stock
  7. An Item’s price will be the same in all branches

100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure
  • Price: £ 299
  • Post Date: 2021-01-06T04:38:14+00:00
  • Category: Research Paper Queries
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure Your task for this assessment is to write a report, which explains how the below data is normalised and create the Oracle SQL code to create the structure
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

Insta Research is a very helpful place to buy a resume in the first place. I gave them my details and did not expect that they would come up with such an exclusive design. My personality is professionally enhanced through the resume made by them. I am thankful for the depth of my heart as I would have never approached that level of excellence in my resume. Wish you good luck ahead and again thank you!
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I had wasted so much money for poor quality work on other sites that I became despair to find a reliable one. I landed on Insta Research and finally, I am fully satisfied after ages from their quality of the work and instant response. Also, the rates are handy. Great going guys!