MatePorcupineMaster1040
CASE Stuyd Some of your friends want to set up a new web site to…
Image transcription text
Type: Standard Shirt_Material: Cotton Sleeve: Short Shirt_Colour: White Extras: Text “YOUR DESIGN HERE”
Extras_Material: Ink Extras_Font 48 Time New Roman Extras_colour Orange Size: XL Type: Standard
Shirt_Material: Leather Sleeve: Short Shirt_Colour: Black Extras: Extras_Material: Extras_Font Extr…
Show more
CASE Stuyd
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 t-shirt 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.
– 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.
Customers will be required to pay before the products are sent so details will need to
be kept of the payment. Your friends are planning to accept payment by credit card,
direct bank deposit and PayPal. For credit cards they need to store the credit card
number and expiry date, for direct deposit they need a field to tick off that the
payment has appeared in their bank account and for PayPal they again need a field to
tick off plus the PayPal user id of the payer
We would like to base an ER diagram, relational model and any business rules or assumptions made from the case study
