Solved: Coats Inc. Case Study
Case Study
Consider the following Case Study ONLY as an Example: Coats Inc. is an enterprise that produces coats and resells some accessories. Coats Inc. sells coats and accessories to a network of customers (dealers throughout the Middle East and some individual customers). The products are sold to the individual customers on cash only. However, the dealer may get the products on credit and sometimes on multiple instalments as well. Coats Inc. obtains raw materials for coats from a variety of suppliers and acquires ready-made accessories from a set of manufactures. It also has a network of investors and creditors that support it financially. Coats Inc. also provide services to its customers and selling coats is not the only source of revenue generation. This example is only for the students' understanding. The students are required to come-up with their own case study and then respond to the following requirements. Note:- The students must use some drawing tool e.g. Microsoft Visio to model the enterprise.
- SQL queries must be implemented using Microsoft Access or any other tool of their choice.
- All the original source files must be submitted as the final product.
- All four sections of case study must be completed and submitted in form of one report by the deadline, otherwise marks will be deducted from missing section.
- Value System Level Model
- Value Chain Level Model
- Business Process Level Model (Core Pattern)
- Identify all the exchange events, resources and agents (internal as well as external)
- Establish the relationships among various entities and their cardinalities
- Assign attributes to entities and relationships. [2 Marks]
- SQL queries
- Write an SQL query to identify the name and address of all suppliers located in Jeddah.
- Write an SQL query to identify the names and addresses of all employees.