University : King's Own Institute UniLearnO is not sponsored or endorsed by this college or university.
Subject Code : ICT200
Assignment Task -

 

Task 1: Introduction

 

  1. Introduce the important aspects of the case study. This section should include introduction to the case study in your own words and details of tasks that need to be completed for this report.

 

Task 2: Develop logical data model (ERD and Normalisation)

 

  1. Identify all entity types, attributes, relationships for above case study and develop an ERD to showing minimum and maximum cardinalities for each relationship. Resolve  many to many relationships, if any. 

  2. Convert the ERD in to tables with all attributes and keys.

  3. Identify anomalies in the tables and apply normalisation rules to convert tables into BCNF. Describe the process of normalising the tables at each stage for the given database.

 

Task 3 : SQL (DDL and DML Scripts)

 

  1. Write a database script with CREATE statements to create all tables identified in above tasks. Make sure primary key, foreign key, not null and other constraints are included in table creation scripts.

  2. Write a database script with INSERT statements to populate these tables with the sample data following the relational requirements. 

 

 

 

This (ICT200) IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : William
  • Posted on : January 27th, 2019

Whatsapp Tap to ChatGet instant assistance