Beautify Inc. is a multinational retail company that operates various chains of boutiques and jewelry shops and stores. The company operates in the U.S and other nations (approximately 4769 stores worldwide) and primarily produces and sells goods to targeted customers. It is managed from the national headquarter and all the local stores aim to satisfy the customers.
Four major suppliers supply all goods unless there is a deficit or scarcity in all the suppliers. They also outsource raw materials and produce their own jewelry products such as beads and necklaces. All products received are documented in the main database with each item given a unique bar code for identification and sales tracking. The products are sold either via cash or credit card. Suppliers are allowed to pay in credit cards or bank cheques.
Whenever there is deficit in an item or set of items, the orders are collected by the central computer located at the headquarters and then transmitted to the vendors, suppliers, and the distribution centers. The company prioritizes on recycling and vendors are encouraged to minimize packaging.
Registered customers are given special discounts, and this allows the company to perform predictions and also help in the decision-making process. The customer details are recorded into the database and points awarded on each purchase. Customers can also refer other customers and earn extra points or gift vouchers. This is a marketing strategy beautify Inc. uses because discounts and vouchers causes less financial strain.
Entities and relationships
The following entities are needed to complete the database; employees, customers, suppliers, products, sales and admin. The products and suppliers’ tables are related in a many-to-many relationship in that a product can be supplied by many suppliers and a supplier can supply many products. As Letkowski (1) explains the sales and products’ tables are related in a many-to-many relationship in that a sale can contain multiple product and a product can be contained in many sales.The sales and employees’ tables are related in a one-to-many relationship in that a sale can only be made by one employee while an employee can make many sales. Customers and sales’ tables are related in a one-to-many relationship in that a customer can make many sales while a sale can be made by only one customer.
Write an SQL query to identify the name and address of all suppliers located in Jeddah.
SELECT Suppliers.Name, Suppliers.Address FROM Suppliers WHERE (((Suppliers.Location) ="Jeddah"));
Write an SQL query to identify the names and addresses of all employees.
SELECT Employees.Name, Employees.Address FROM Employees;
Letkowski, Jerzy. "Doing database design with MySQL." Journal of Technology Research 6 (2015): 1.