Home/Engineering & CS/Draw Entity Relationship Diagram (ERD) with entities, attributes task(function) inclusive primary key, foreign key & cardinality using Chen Notation. 1. The KK Furniture company sells a number of different furniture products. These products are grouped into several product lines. The identifier for a product is Product_ID, while the identifier for a product line is Product_Line_ID. Referring to the customer invoice, we identify the following additional attributes for product: Product_Description, Product_Finish, and Unit_Price. Another attribute for product line is Product_Line_Name. A product line may group any number of products, but must group at least one product. Each product must belong to exactly one product line. 2. Customers submit orders for products The identifier for an order is Order-ID, and another attribute is Order_Date. A customer may submit any number of orders, but need not submit any orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address. 3. A given customer order must request at least one product. Any product sold by KK Furniture may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested. 4. KK Furniture has established sales territories for its customers. Each customer does business in one or more of these sales territories. The identifier for a sales territory is Territory_ID. A sales territory may have any number of customers, or may not have any customers doing business. 5. KK Furniture Company has several salespersons. The identifier for a salesperson is Salesperson_ID. Other attributes include Salesperson_Name, Salesperson_Telephone, and Salesperson_Fax. A salesperson serves exactly one sales territory. Each sales territory is served by one or more salespersons. 6. Each product is assembled from one or more raw materials. The identifier for the raw material entity is Material_ID. Other attributes include Unit_of_Measure and Unit_Price. Each raw material may be assembled into one or more products. 7. Raw materials are supplied by vendors. The identifier for a vendor is Vendor_ID. Other attributes include Vendor_Name and Vendor_Address. Each raw material can be supplied by one or more vendors. A vendor may supply any number of raw materials, or may not supply any raw materials to KK Furniture. An attribute of the relationship between vendor and raw material is Unit_Price 8. KK Furniture has established a number of work centers. The identifier for a work center is Work_Center_ID. Another attribute is Location. Each product is produced in one or more work centers. A work center may be used to produce any number of products, or may not be used to produce any products. 9. The company has over 100 employees. The identifier for employee is Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skill. An employee may have more than one skill. A skill can be mastered by many employees 10. Each employee works in one or more work centers. A work center must have at least one employee working in that center, but may have any number of employees. 11. Each employee has exactly one supervisor. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors. Subject: Database system it's very urgent pls help me

Question Solved1 Answer Draw Entity Relationship Diagram (ERD) with entities, attributes task(function) inclusive primary key, foreign key & cardinality using Chen Notation. 1. The KK Furniture company sells a number of different furniture products. These products are grouped into several product lines. The identifier for a product is Product_ID, while the identifier for a product line is Product_Line_ID. Referring to the customer invoice, we identify the following additional attributes for product: Product_Description, Product_Finish, and Unit_Price. Another attribute for product line is Product_Line_Name. A product line may group any number of products, but must group at least one product. Each product must belong to exactly one product line. 2. Customers submit orders for products The identifier for an order is Order-ID, and another attribute is Order_Date. A customer may submit any number of orders, but need not submit any orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Address. 3. A given customer order must request at least one product. Any product sold by KK Furniture may not be requested on any order, or may be requested on one or more orders. An attribute associated with each order and product is Quantity, which is the number of units requested. 4. KK Furniture has established sales territories for its customers. Each customer does business in one or more of these sales territories. The identifier for a sales territory is Territory_ID. A sales territory may have any number of customers, or may not have any customers doing business. 5. KK Furniture Company has several salespersons. The identifier for a salesperson is Salesperson_ID. Other attributes include Salesperson_Name, Salesperson_Telephone, and Salesperson_Fax. A salesperson serves exactly one sales territory. Each sales territory is served by one or more salespersons. 6. Each product is assembled from one or more raw materials. The identifier for the raw material entity is Material_ID. Other attributes include Unit_of_Measure and Unit_Price. Each raw material may be assembled into one or more products. 7. Raw materials are supplied by vendors. The identifier for a vendor is Vendor_ID. Other attributes include Vendor_Name and Vendor_Address. Each raw material can be supplied by one or more vendors. A vendor may supply any number of raw materials, or may not supply any raw materials to KK Furniture. An attribute of the relationship between vendor and raw material is Unit_Price 8. KK Furniture has established a number of work centers. The identifier for a work center is Work_Center_ID. Another attribute is Location. Each product is produced in one or more work centers. A work center may be used to produce any number of products, or may not be used to produce any products. 9. The company has over 100 employees. The identifier for employee is Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skill. An employee may have more than one skill. A skill can be mastered by many employees 10. Each employee works in one or more work centers. A work center must have at least one employee working in that center, but may have any number of employees. 11. Each employee has exactly one supervisor. An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors. Subject: Database system it's very urgent pls help me

WXVSG3 The Asker · Computer Science

Draw Entity Relationship Diagram (ERD) with entities, attributes task(function) inclusive primary key, foreign key & cardinality using Chen Notation.

1. The KK Furniture company sells a number of different furniture products.

  • These products are grouped into several product lines.
  • The identifier for a product is Product_ID, while the identifier for a product line is Product_Line_ID.
  • Referring to the customer invoice, we identify the following additional attributes for product: Product_Description, Product_Finish, and Unit_Price.
  • Another attribute for product line is Product_Line_Name.
  • A product line may group any number of products, but must group at least one product.
  • Each product must belong to exactly one product line.

2. Customers submit orders for products The identifier for an order is Order-ID, and another attribute is Order_Date.

  • A customer may submit any number of orders, but need not submit any orders.
  • Each order is submitted by exactly one customer.
  • The identifier for a customer is Customer_ID.
  • Other attributes include Customer_Name and Customer_Address.

3. A given customer order must request at least one product.

  • Any product sold by KK Furniture may not be requested on any order, or may be requested on one or more orders.
  • An attribute associated with each order and product is Quantity, which is the number of units requested.

4. KK Furniture has established sales territories for its customers.

  • Each customer does business in one or more of these sales territories.
  • The identifier for a sales territory is Territory_ID.
  • A sales territory may have any number of customers, or may not have any customers doing business.

5. KK Furniture Company has several salespersons. The identifier for a salesperson is Salesperson_ID.

  • Other attributes include Salesperson_Name, Salesperson_Telephone, and Salesperson_Fax.
  • A salesperson serves exactly one sales territory.
  • Each sales territory is served by one or more salespersons.

6. Each product is assembled from one or more raw materials.

  • The identifier for the raw material entity is Material_ID.
  • Other attributes include Unit_of_Measure and Unit_Price.
  • Each raw material may be assembled into one or more products.

7. Raw materials are supplied by vendors.

  • The identifier for a vendor is Vendor_ID.
  • Other attributes include Vendor_Name and Vendor_Address.
  • Each raw material can be supplied by one or more vendors.
  • A vendor may supply any number of raw materials, or may not supply any raw materials to KK Furniture.
  • An attribute of the relationship between vendor and raw material is Unit_Price

8. KK Furniture has established a number of work centers.

  • The identifier for a work center is Work_Center_ID.
  • Another attribute is Location. Each product is produced in one or more work centers.
  • A work center may be used to produce any number of products, or may not be used to produce any products.

9. The company has over 100 employees.

  • The identifier for employee is Employee_ID.
  • Other attributes are Employee_Name, EmployeeAddress, and Skill.
  • An employee may have more than one skill.
  • A skill can be mastered by many employees

10. Each employee works in one or more work centers.

  • A work center must have at least one employee working in that center, but may have any number of employees.

11. Each employee has exactly one supervisor.

  • An employee who is a supervisor may supervise any number of employees, but not all employees are supervisors.

Subject: Database system

it's very urgent

pls help me

More
See Answer
Add Answer +20 Points
Community Answer
XONSXI The First Answerer
See all the answers with 1 Unlock
Get 4 Free Unlocks by registration

Solution: ER Diagram: The entity relationship diagram represents the various entities and the relationship between them which helps us in understanding how the system works. The entities are nothing but the real world objects ... See the full answer

Related Questions

Introduction: In managing risks in an organization, professionals in the information technology (IT) department conduct research to identify threats, vulnerabilities, and threat/vulnerability pairs. Then, the IT professionals determine the likelihood of each threat occurring. The IT professionals present this information to IT management, whose role in risk management is to determine and recommend approaches to manage these risks. IT management then presents these recommendations to senior management, whose role is to allocate resources, specifically money and employees, to prepare for and respond to identified threats and vulnerabilities appropriately. This activity allows a small group of students to fulfill the role of IT professionals in a small business tasked with identifying threats, vulnerabilities, and threat/vulnerability pairs, estimate the likelihood of these threats occurring, and present this information to IT management. Scenario: YieldMore is a small agricultural company, which produces and sells fertilizer products. The company headquarters is in a small town in Indiana. Outside its headquarters, there are two large production facilities—one in Nebraska and other in Oklahoma. Furthermore, YieldMore employs salespersons in every state in the United States to serve its customers locally. The company has three servers located at its headquarters—an Active Directory server, a Linux application server, and an Oracle database server. The application server hosts YieldMore’s primary software application, which is a proprietary program managing inventory, sales, supply chain, and customer information. The database server manages all data stored locally with direct-attached storage. All three sites use Ethernet-cabled local area networks (LANs) to connect the users’ Windows 7 workstations via industry-standard managed switches. The remote production facilities connect to headquarters via routers with T-1 LAN connections provided by an external Internet service provider (ISP), and share an Internet connection through a firewall at headquarters. Individual salespersons throughout the country connect to YieldMore’s network via virtual private network (VPN) software through their individual Internet connections, typically in a home office. Tasks: Your instructor will assign you a group where you need to assume the roles of IT professionals assigned by YieldMore’s IT management to conduct the following risk management tasks: Identify threats to the seven domains of IT within the organization. Identify vulnerabilities in the seven domains of IT within the organization. Identify threat/vulnerability pairs to determine threat actions that could pose risks to the organization. Estimate the likelihood of each threat action. Prepare a brief report or presentation of your findings for IT management to review.
Problem 7.35 (page 287) "Figure 7.16 is a bird's-eye view ..." [6 points] Hint: In this problem the potential energy U is zero, so that there is only kinetic energy T. 7.35** Figure 7.16 is a bird's-eye view of a smooth horizontal wire hoop that is forced to rotate at a fixed angular velocity w about a vertical axis through the point A. A bead of mass m is threaded on the hoop and is free to move around it, with its position specified by the angle o that it makes at the center with the diameter AB. Find the Lagrangian for this system using o as your generalized coordinate. (Read the hint in Problem 7.29.) Use the Lagrange equation of motion to show that the bead oscillates about the point B exactly like a simple pendulum. What is the frequency of these oscillations if their amplitude is small?
Problem 23: (Bead on a rotating circular hoop) Imagine a vertical circular hoop of radius R rotating about a vertical axis with constant angular velocity S2 as shown in Figure 1.11. A bead of mass m is threaded on the hoop, so that it can move without friction, but is confined to move on the hoop. (Define the angle to be the angle from the vertical line through the center of the hoop to the bead.) Find the Lagrangian and the equations of motion. Find the Hamiltonian H explicitly. Is H a constant of the motion? Is energy (T + V) constant?
5. Linear power supply Use lecture 2.1 to design an unregulated power supply (that is no regulator) that will deliver a minimum of 12 V with a maximum of 1 V ripple when the current supplied to a load is 50 mA. Use a half wave regulator. Determine a value for the capacitor. What is the output of the transformer's secondary in rms.
A graphing calculator is recommended.The Gateway Arch in St. Louis was designed by Eero Saarinen and was constructed using the equationy = 211.49 − 20.96 cosh(0.03291765x)for the central curve of the arch, where x and y are in meters and |x| ≤ 91.20. a-What is the height (in m) of the arch at its center? (Round your answer to two decimal places.) b-At what points is the height 50 m? (Round your answers to two decimal places.)smaller x-value (x, y)=larger x-value (x, y)= c-What is the slope of the arch at the points in part b? (Round your answers to one decimal place.)at the point with smaller x-value     at the point with larger x-value     
options: increasing, positive, concave upnet signed area, slope, height1. slope, distance traveled, displacement2. make negative contribution, should be disregarded, countexactly the same as regions above the horizontal axis3. position, total distance traveled, displacement4. odd and even, increasing and decreasing, forward moving andbackward moving Sorry I asked this question like 4 times and no one answered it): Consider the task of sketching G, based two pieces of given information: 1. a graph of its derivative function g, and 2. the information that G (2) = 1. . At x-values where g is positive, G should be increasing • At x-values where g is increasing, G should be positive . Any value of G can be determined by the formula G(X) = 1+Sg(t) dt. This formula will tell us the net signed area of the G graph at a given x- value. Question 3 Active Calculus states: bounded by on any inte The rule A (x) = f(t) dt defines a new function that measures the [ Select] slope derivative We call the function A the integral function corresponding to f. net signed area velocity
About
About
Blog
Sitemap
More
Help Center
Become an Expert
Download App
Legal
Terms of Service
Privacy Policy
Honor Code
Copyright Policy
Contact
contact@studyx.im
Facebook
Instagram
Twitter
YouTube
Copyright © 2023 StudyX Inc