I just need to double check with my answers. Your help is appreciated. Thanks Br
ID: 3666029 • Letter: I
Question
I just need to double check with my answers. Your help is appreciated. Thanks
Brick City Widgets is an up and coining company which manufactures and sells a unique line of widgets. Widgets are organized by widget product lines. For example, the Way Too Cool product line includes the Low-Tone, High-Tone and No-Tone widget products. Widgets are designed and manufactured at work centers by Brick City employees. Each employee is identified by their employee ID, name and address. Employees also have one or more skills associated with them such as Widget Welder, Widget Designer I, etc. Employees are supervised by another employee designated to be a supervisor. Employees report to exactly one supervisor. There is one supervisor per work area. The material used to build widgets is supplied by approved vendors. Vendors are identified by a vendor ID and vendor name. The supplied material has a material identifier, material name, unit cost of the material and number of units supplied. Brick City tracks each vendor delivered order by the total cost of that unit and the order date. Widget products are manufactured at work centers from the materials acquired from supply vendors. The composition of a product includes the name and quantity of material needed in the manufacturing process. As mentioned above products are organized into product lines. Each product has a unique product identifier, product name and price. Widgets are purchased by customers identified by a customer ID, name, email and zip code. Customers submit orders directly to Brick City. Orders may include one or more different widget products referenced as a line item of the order. An order is identified by an order ID, the date it was received and the date it shipped. Brick City outsources its customer assistance services to a group of sales representatives that are responsible for sales territories based on zip code. Each territory is assigned to a single salesperson that is identified by a salesperson ID, name and email. Territories are identified by a territory ID and name.Explanation / Answer
1)Entities are: Widgets, Employees, Vendor, Product, Customer, Orders,Materials, SalesPerson, Territories.
2)
-------------- * indicates primary key
Employees --> *Employee ID, name, address.
Widget --> name
Vendor --> *vendor ID, name
Product --> *product Identifier, name, price
Customer --> *customer ID, name, email, zip code
Order ---> *order ID, date
SalesPerson --> *SalesPerson ID, name, email.
Territories --> Territory ID, name
Materials --> *Material identifier,name, unit_cost, no_of_supplied.
3)
Relationships:
--------------------
Widgets 1..* <--> 1..* Employees
Widget 1 <---> 1..* Materials
Materials 1..* <-->1 Vendors
product 1..* <-->1 Customer
Customer 1 <--> 1..* Order
SalesPerson 1 <---> 1..* orders
SalesPerson 1 <---> 1 Territory
-------------------------------------------------------------------
4) Some of the queries..
Select * orders where data=='7/2/2016';
Select Customer.name , Product.name from Customer INNER JOIN Product WHERE Customer.customerID == Product.customerID;
Select * from SalesPerson where Territory_ID == '123';
Select * from Widgets;
Select * from Materials;