4. What is the relationship that exists among the customer, order, and Product entities?
Homework Answers
From the above flow chart, customer, order, Product have direct relationship with many sub-entities that are explained below.
- Customer : From the above chart customers will be having their unique customer number , name and E-mail ID. Customer makes an order using this details.
- Order : once the customer makes an order using the his/her name email or customer number, order will be placed to the firm. This order will be having its particular order number, order date, handling cost for holding that order.
- products: The order from the customer will have certain products / service. For above case, customer order particular products. The products have its unique product number, product name, product or list price.
Hence all the above entities are interrelated to each other. Hence customer will have direct link with order and products as well.
Add Answer to:
4. What is the relationship that exists among the customer,
order, and Product entities?
customer-no prder-no...
the initial entities for CUSTOMER, ORDER, and PRODUCT provided , transform them into relations, and normalize...
the initial entities for CUSTOMER, ORDER, and PRODUCT provided ,
transform them into relations, and normalize your model to 3rd
Normal Form.
CUSTOMER Customer ID CustomerName CustomerAddress CreditLimit ORDER Order ID CustomerID Customer PONumber OrderDate Due Date L ShipDate PRODUCT Product ID Product Description Unit Price Stock Quantity
ER Diagram of Online Sale System Product ProductID OrderID DepartmentID Product Name Price Cutomer PK CustomerID...
ER Diagram of Online Sale System Product ProductID OrderID DepartmentID Product Name Price Cutomer PK CustomerID Order OrderID PK Full Name FK1 FK2 CustomerID StoreID Sales Amount Date Time PK Store StorelD Store Name Consider the ER diagram of online sales system above. Based on the diagram answer the questions below, a) Based on the ER Diagram, determine the Foreign Key in the Product Table. Just mention the name of the attribute that could be the Foreign Key (2 marks]...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where...
Oarty emanded of Apie Using the infprmation plotted above, what type of relationship exists between the...
Oarty emanded of Apie Using the infprmation plotted above, what type of relationship exists between the two variables Determine the slope between Determine the slope between points C and D points E andF 7 Plot the following data Price should be on the Y axis and quantity supplied on the X axis Quantty Supplied of Price of Oranges Oranges 0.30 350 9.55 And 0.75 so n 1.00 700 1.05 800 1000 115 M Oranges Using the information plotted above, what...
Deliverable 1. Simple SQL Statements Caution: Read the instructions carefully! Each question is based on a...
Deliverable 1. Simple SQL Statements Caution: Read the instructions carefully! Each question is based on a single SQL statement, and the single SQL statement might contain sub-queries (additional SELECT statements) within the statement. Provide a list all of the Customer ID, Customer Names, and States and sort the list in alphabetical order by Customer Name. Provide a list of all of the Customer ID, Customer Names, and States, and sort the list by state with the Customer Names in alphabetical...
Question 4 (1 point) Wizard Corporation has analyzed their customer and order handling data for the...
Question 4 (1 point) Wizard Corporation has analyzed their customer and order handling data for the past year and has determined the following costs: Order processing cost per order $7 Additional costs if order must be expedited (rushed) $8.00 Customer technical support calls (per call) $12 Relationship management costs (per customer per year) $1200 In addition to these costs, product costs amount to 75% of Sales. In the prior year, Wizard had the following experience with one of its customers,...
Exercise 12-9 Special Order Decision [LO12-4] Delta Company produces a single product. The cost of producing...
Exercise 12-9 Special Order Decision [LO12-4] Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's norma activity level of 93,600 units per year is: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling and administrative expenses Fixed selling and administrative expenses $ 2.50 $ 3.00 $ 0.90 1.30 $ 2.00 The normal selling price is $21.00 per unit. The company's capacity is 122,400 units per...
Exercise 12-9 Special Order Decision [LO12-4] Delta Company produces a single product. The cost of producing...
Exercise 12-9 Special Order Decision [LO12-4] Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company’s normal activity level of 85,200 units per year is: Direct materials $ 2.40 Direct labor $ 4.00 Variable manufacturing overhead $ 0.60 Fixed manufacturing overhead $ 4.95 Variable selling and administrative expenses $ 1.80 Fixed selling and administrative expenses $ 3.00 The normal selling price is $22.00 per unit. The company’s capacity is...
Exercise 12-9 Special Order Decision (L012-4) Delta Company produces a single product. The cost of producing...
Exercise 12-9 Special Order Decision (L012-4) Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's normal activity level of 92,400 units per year is: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling and administrative expenses Fixed selling and administrative expenses $ 1.60 $ 3.00 $ 1.00 $ 3.55 $ 1.80 $ 2.00 The normal selling price is $18.00 per unit. The company's capacity is...
CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships...
CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships between entities in a database environment. The following is an example from the textbook (p 254) Address Name Email Ships Hem Orders Price Forwards Credit Card Creates Order Number Entity Relationship Attribute :0ne 0-Zero or more. Optional )-=Many In the above example, we can identify the entities (what would be tables within our database), the attributes (the items that describe the entity), the relationship...
the initial entities for CUSTOMER, ORDER, and PRODUCT provided ,
transform them into relations, and normalize your model to 3rd
Normal Form.
CUSTOMER Customer ID CustomerName CustomerAddress CreditLimit ORDER Order ID CustomerID Customer PONumber OrderDate Due Date L ShipDate PRODUCT Product ID Product Description Unit Price Stock Quantity
ER Diagram of Online Sale System Product ProductID OrderID DepartmentID Product Name Price Cutomer PK CustomerID Order OrderID PK Full Name FK1 FK2 CustomerID StoreID Sales Amount Date Time PK Store StorelD Store Name Consider the ER diagram of online sales system above. Based on the diagram answer the questions below, a) Based on the ER Diagram, determine the Foreign Key in the Product Table. Just mention the name of the attribute that could be the Foreign Key (2 marks]...
Identify the Entities and Attributes and Draw the ER diagram. 1. Consider a mail order database in which employees take orders for parts from customers. The data requirements are summarized as follows: The mail order company has employees identified by a unique employee number, their first and last names, and a zip code where they are located Customers of the company are uniquely identified by a customer number. In addition, their first and last names and a zip code where...
Oarty emanded of Apie Using the infprmation plotted above, what type of relationship exists between the two variables Determine the slope between Determine the slope between points C and D points E andF 7 Plot the following data Price should be on the Y axis and quantity supplied on the X axis Quantty Supplied of Price of Oranges Oranges 0.30 350 9.55 And 0.75 so n 1.00 700 1.05 800 1000 115 M Oranges Using the information plotted above, what...
Exercise 12-9 Special Order Decision [LO12-4] Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's norma activity level of 93,600 units per year is: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling and administrative expenses Fixed selling and administrative expenses $ 2.50 $ 3.00 $ 0.90 1.30 $ 2.00 The normal selling price is $21.00 per unit. The company's capacity is 122,400 units per...
Exercise 12-9 Special Order Decision (L012-4) Delta Company produces a single product. The cost of producing and selling a single unit of this product at the company's normal activity level of 92,400 units per year is: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Variable selling and administrative expenses Fixed selling and administrative expenses $ 1.60 $ 3.00 $ 1.00 $ 3.55 $ 1.80 $ 2.00 The normal selling price is $18.00 per unit. The company's capacity is...
CSCI 3700 - Introduction to MIS Assignment 4-Entity Relationship Diagram Entity relationship diagrams document the relationships between entities in a database environment. The following is an example from the textbook (p 254) Address Name Email Ships Hem Orders Price Forwards Credit Card Creates Order Number Entity Relationship Attribute :0ne 0-Zero or more. Optional )-=Many In the above example, we can identify the entities (what would be tables within our database), the attributes (the items that describe the entity), the relationship...
Most questions answered within 3 hours.
-
You follow the lab procedure and at the end of Part 4C, you used
an average...
asked 10 minutes ago -
Write 250-450 words, about the following: • Analyze how a
servant leader in your organization or...
asked 14 minutes ago -
3. American and Japanese workers can each produce 4 cars a
year. An American worker can...
asked 17 minutes ago -
On October 1, 20X1, a company purchased a piece of land by
agreeing to pay the...
asked 29 minutes ago -
Jamie is doing a survey at her school about whether the students
feel the cafeteria food...
asked 34 minutes ago -
What are the roles of 3' and 5' untranslated regions in
mRNAs?
asked 35 minutes ago -
A domestic television receives antenna delivers a sky noise
power of -105 dBm to a matched...
asked 34 minutes ago -
What do you think are the chemical reactions involved in the
breathalyzer tests administered to potentially...
asked 49 minutes ago -
A random sample of 120 observations produces a mean of
38.2 from a population with a...
asked 56 minutes ago -
The average area of land burned by forest fires every year in
Canada is 2.5 million...
asked 58 minutes ago -
36. The basic difference between government bureaus and market
firms is that bureaus:
a. can...
asked 58 minutes ago -
java
- A recursive method findR() to search for a number in list
(ArrayList)
- A...
asked 1 hour ago