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

1) You should normalise the above table, stepping through 1st normal form, 2nd normal form and 3rd normal form, explaining in deta



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

ASSIGNMENT TOPSHEET                                                          

COMPUTER SCIENCE AND TECHNOLOGY

 

 

Unit Code: CIS020-2

 

 

 

Submission Date:

 

Unit Name :  

Systems Development and Modern Database Practices

 

Student’s Full names:

 

 

Student ID

 

 

Unit Co-ordinator’s Name:           

Assignment Leader Name:         

 

Assignment Title:

 

Resit Assignment 2 all parts - Written report: Scenario-based Database System including SQL implementation

 


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

Price: £ 199

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

Details

  • Title: 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
  • Price: £ 199
  • Post Date: 2018-11-06T11:03:12+00:00
  • Category: Assignment Requirements
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

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 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
Reviews: 5

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

I was worried about the plagiarism ration in my dissertation. But thanks to my dedicated writer, I received 0% plagiarism in all the chapters. I owe my writer a million thanks..!
Reviews: 5

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

I ordered the literature review for my research project in rush delivery. I was not expecting that they would complete my order 2 hours before my chosen time. The quality is also nice. Thank you for help.

Write your Feedback

Your email address will not be published. Required fields are marked *