Primark is part of Associated British Foods (ABF), a diversified international food, ingredients and retail group. Primark has almost 200 stores across Ireland, the UK, Spain, Netherlands, Germany, Belgium and Portugal. Primark’s annual turnover accounts for a significant proportion of ABF’s revenues and profit. Today, Primark specializes in clothing, while marketing primarily to fashion-conscious customers that want value for their money. Important business principles for Primark include respecting human rights and setting guidelines for appropriate conditions of employment in its suppliers' factories. Primark has over 600 major suppliers in 16 countries. These companies provide employment for over 700,000 workers in three continents. Primark is committed to making sure that its partners, both factories and suppliers, also act responsibly towards their employees. The following system we designed deals with the importance of ethical standards in Primark’s industry. The output represents which factories under Primark’s watch have appropriate ethical standards according to the Ethical Trading Initiative.
The following tables contain information regarding each of Primark’s factories in numerous different countries. Certain information is provided and will be updated once an auditor has processed whether the factories meet ethical standards.
The above table contains important information about each of the manufacturing sites Primark has in its corporation. Each site has been assigned a manufacturing ID, country of location, site size in square ft (thousands). The approval status of these manufacturing sites is listed and will be the focus for our queries.
The auditor table simply lists each auditor, which is assigned by a unique ID to aid in simplifying our data lookups. This table also shows which...