Business Data Management and Analytic - IT Assignment Help

Assignment Task:

Task:

SPECIFICATIONS

Read the following Case study carefully. You will be asked to create a data model, that is free from anomalies and therefore complies with being in third normal form.

CASE STUDY

Some of your friends want to set up a new web site to sell custom made T-Shirts to the public. Rather than stock a range of pre-made t-shirts, they will make the t-shirts individually to order and hopefully fill a special demand in the clothing market that is not currently met. Their competitive advantage will be the use of automated machines and 3D printers to create these custom made T-Shirts. The business will be called myTShirt. They have asked you to design a database to be used by the website to keep details of the products and options available, and to record orders that are received from customers via the web site. The basic product they will sell will be, obviously, t-shirts. They will have different styles of t-shirts – some styles will be tight, others loose and they may also sell polo tops as another type (The intend to add more tshirt types in future). As well as different styles of t-shirts there will also be different colours that customers can choose from. The t-shirts come with various type of sleeve, but mainly long or short. They will have a large range of images, logos etc that can be printed on the t-shirts. The images/logos can be custom uploaded and the customer can decide what sort of material to use to print it onto t-shirt, this may include various inks (colour) - sprayed, plastic – 3D printed, cotton – embroidered. If text is chosen to be placed on t-shirt, the material required is important, but will need the colour, font, size and text to be recorded. The database will need to store all these details so customers can be presented with all the choices when placing an order. When customers place an order, the order details will need to be stored into the database, as well as details of the customer. Naturally this will include details such as name, address and phone number. For each order they can order multiple t-shirts.

For each t-shirt, they will be allowed to choose:

- The style of the t-shirt - The sleeve configuration School of Accounting, Information Systems and Supply Chain Semester 2 - 2021 Business Data Management and Analytics Page 2 of 3 - The colour of the t-shirt - The size of the t-shirt - The text/image/logo to be printed - The material used for t-shirt - The material used for the text/image/logo It is extremely important to store the data in a structured format, because it will be used to send directly to the automated T-Shirt create equipment to be instantly created and shipped.

The above IT Assignment has been solved by our  IT Assignment  Experts at My Uni Paper. 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 considered worthy of the highest distinction.