Question

Database Analysis of clothing ordering
ai)Build the tables for your database on clothing ordering
aii) Show by a diagram how these tables would be linked together
aii)Identify the parent/primary table and justify why you are selecting that as the parent table

Answer 1

Ans thl Product Colors Product ColorID the Product Location pe Procluct location 어 Key thl Products Product ID Patem ID PstyleID perice p Description M tol Color Sizes cs ColorSizelo cs Product Colored cs Size ID Quantity csRcorded pc Pc Product ID Pc ColorID pc Image po Sost Orderem PC Active امتار ml pestoreID pe Inventorykio CS the stores s storeID s store. No s Name s Address sspalte s Country s Phone No. pc Color sizeID/m pe Quantity M M s city tbl Vendor Profile Vp Vendor ID the Purchase orders po purchase Ordeeld poReference ID po Date po Vendorld po Orded By M po Receive date po Promise Date po Completed Paid polaid Type po confirmed ponotes the sizes Up Approved up company Name the Styles Style CD sstyle S Description ssortordare sActive the Colors cColorID cColor Sortodoket cActive Stax No: s website S Mail Add. ssizeit s Size SSostboder SActive po Tad Ро M Name Ip Address up state up country Up Phone No. Up Faxe No us website ce On Account Account cloel Up Date created Po Concelled M 3 - il Inventory loded il Vendor ID il cost ie Cabineta e Shelf ID il Binko Vo Date med! This date bluse includes all clothing them to attenbaules with poimary key among il Bay ID tollurchase Orda del podi lood Purchase Orfulo pod Quantity pod Producted top pod Description pod Cost attribute and card relation tables. and also show cardinality