ASSIGNMENT TOPSHEET                                                          

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 ……………………………………………….

2^nd Marker’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 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 data  below, stepping through 1^st normal form, 2^nd normal form and 3^rd 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%)

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

o 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. Salespeople can work for more than one supplier

4. Each Salesperson has a unique phone number

5. Supplier ID, Serial Number, Store ID and Category Code are all unique

Supplier Form

Supplier ID: S1246 Owner Name: Jedra Alo

Supplier Name: Kitchen Inc. Owner Telephone No.: 02387 382931

Street Address: 234 Reqdeam Road           Category Code: K

Town: Birmingham             Category Name: Kitchens

PostCode:  BR2 6TY

Products

1. 

2. Salespeople

Marking Scheme – Individual Assignment 1 all parts

A Range: A sufficiently complex and excellent Entity Relationship (ER) model and conceptual schema which very clearly reflects the textual table presented earlier. The Normalisation process is carried out in a very logical and clear manner, very clearly and logically showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model clearly shows the logically presented tables including accurate optionality and all cardinality for all entities and relationships. Excellent SQL code for creating tables is included.

B Range: A sufficiently complex and excellent Entity Relationship (ER) model and conceptual schema which very clearly reflects the table presented earlier. The Normalisation process is carried out in a logical and clear manner, clearly showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model clearly shows the logically presented tables including  optionality and all cardinality for all entities and relationships. Good SQL code for creating tables

C Range: A reasonable Entity Relationship (ER) model and conceptual schema which reflects the table presented earlier. The Normalisation process is carried out in a logical manner, showing 1NF, 2NF and 3NF in logical steps. A final Normalised ER model shows the resulting tables including some optionality and cardinality for entities and relationships. SQL code for creating tables

D Range: An Entity Relationship (ER) model which to some extent reflects the table presented earlier. The Normalisation process is carried out, showing a progression through the logical steps of normalisation. Some optionality and cardinality for entities and relationships may also be included. SQL code for creating tables

E Range: The Entity Relationship (ER) model does not sufficiently reflect the table presented earlier. The Normalisation process is not carried out to an adequate level, and does not show a clear logical progression through the steps of normalisation. Optionality and cardinality for entities and relationships may also be included but are in the majority of cases inaccurate

代写CS&Finance|建模|代码|系统|报告|考试

编程类：C代写,JAVA代写 ,数据库代写,WEB代写,Python代写,Matlab代写,GO语言,R代写

金融类：统计，计量，风险投资，金融工程，R语言，Python语言，Matlab，建立模型，数据分析，数据处理

服务类：Lab/Assignment/Project/Course/Qzui/Midterm/Final/Exam/Test帮助代写代考辅导

天才写手,代写CS,代写finance,代写statistics,考试助攻

E-mail:850190831@qq.com   微信：BadGeniuscs  工作时间：无休息工作日-早上8点到凌晨3点

---

如果您用的手机请先保存二维码到手机里面，识别图中二维码。如果用电脑，直接掏出手机果断扫描。