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.I confirm this is my own work Student’s Signature ………………………….………………..Tutor’s Grade Tutor’s signature ……………………………………………….2ndMarker’s signature(where appropriate) ……………………………………… Note: This assignment must be submitted using the Turnitin electronic submission system. And a hard copy submitted along with a CD of the database system handed in to University submissions desk No other form of submission will be accepted.CIS020-2: Systems Development and Modern Database practicesReferral Individual Assignment 2 BriefCIS020-2: Individual Referral Assignment – 2 BriefTaskYour 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 data below, stepping through 1stnormal form, 2ndnormal form and 3rdnormal 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%)oSubmit 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.oEnsure 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 otherwise3.Salespeople can work for more than one supplier4.Each Salesperson has a unique phone number5.Supplier ID, Serial Number, Store ID and Category Code are all uniqueSupplier FormSupplier ID: S1246 Owner Name: Jedra AloSupplier Name: Kitchen Inc. Owner Telephone No.: 02387 382931Street Address: 234 Reqdeam Road Category Code: KTown: Birmingham Category Name: KitchensPostCode: BR2 6TYProducts


所有的编程代写范围：essayghost为美国、加拿大、英国、澳洲的留学生提供C语言代写、代写C语言、C语言代做、代做C语言、数据库代写、代写数据库、数据库代做、代做数据库、Web作业代写、代写Web作业、Web作业代做、代做Web作业、Java代写、代写Java、Java代做、代做Java、Python代写、代写Python、Python代做、代做Python、C/C++代写、代写C/C++、C/C++代做、代做C/C++、数据结构代写、代写数据结构、数据结构代做、代做数据结构等留学生编程作业代写服务。