Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
A representative salesman is someone responsible for selling the products of a given factory to shops that will later resell those products. Each factory manufactures its own list of products. A representative office can sell products from different factories at the same time to the same shop. A product item of a given factory is described as an alpha-numeric ID, a textual description of the product, the price of a single unit, and the tax rate. A shop (here denominated the 'customer') is described by an ID, a name, address, telephone, email and date of the first purchase. A purchase order is described by the date of the purchase, the ID of the customer, a list of products (ID of the item and amount of units being purchased), the ID of the factory and the total amount of the order. Its important to notice that each purchase order can only contain products of a single factory. We are expected to design an ER diagram (ERD) to model to manage: • CUSTOMERS as the shops to which the representative salesman sells products • FACTORIES as the manufacturers of those products • PRODUCTS as the list of products being manufactured by a single factory • PURCHASES as the orders made by customers to buy products from a factory Upload an image file that contains your ERD that should describe: 1. The list of entities including weak entities (if any) 2. The list of attributes of each entity, indicating single-valued, multi-valued, composite attributes, key attributes, and derived attributes (if any) 3. The relationships among those entities, including relational attributes (if any) 4. Cardinality ratios and participation constraints (whenever applicable) PS.: You are allowed to add information (but not remove) to the domain to include your own assumptions to the conceptual model. In that case, add a table below the diagram describing such assumptions.

A representative salesman is someone responsible for selling the products of a given factory to shops that will later resell those products. Each factory manufactures its own list of products. A representative office can sell products from different factories at the same time to the same shop. A product item of a given factory is described as an alpha-numeric ID, a textual description of the product, the price of a single unit, and the tax rate. A shop (here denominated the 'customer') is described by an ID, a name, address, telephone, email and date of the first purchase. A purchase order is described by the date of the purchase, the ID of the customer, a list of products (ID of the item and amount of units being purchased), the ID of the factory and the total amount of the order. Its important to notice that each purchase order can only contain products of a single factory. We are expected to design an ER diagram (ERD) to model to manage: • CUSTOMERS as the shops to which the representative salesman sells products • FACTORIES as the manufacturers of those products • PRODUCTS as the list of products being manufactured by a single factory • PURCHASES as the orders made by customers to buy products from a factory Upload an image file that contains your ERD that should describe: 1. The list of entities including weak entities (if any) 2. The list of attributes of each entity, indicating single-valued, multi-valued, composite attributes, key attributes, and derived attributes (if any) 3. The relationships among those entities, including relational attributes (if any) 4. Cardinality ratios and participation constraints (whenever applicable) PS.: You are allowed to add information (but not remove) to the domain to include your own assumptions to the conceptual model. In that case, add a table below the diagram describing such assumptions.

Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
9th Edition
ISBN:9781337669405
Author:FARRELL
Publisher:FARRELL
Chapter2: Elements Of High-quality Programs
Section: Chapter Questions
Problem 9RQ
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
100%
A representative salesman is someone responsible for selling the products of a given factory to shops that will later resell those products. Each factory manufactures its own list of products. A representative office can sell products from different factories at the same time to the same shop. A product item of a given factory is described as an alpha-numeric ID, a textual description of the product, the price of a single unit, and the tax rate. A shop (here denominated the 'customer') is described by an ID, a name, address, telephone, email and date of the first purchase. A purchase order is described by the date of the purchase, the ID of the customer, a list of products (ID of the item and amount of units being purchased), the ID of the factory and the total amount of the order. Its important to notice that each purchase order can only contain products of a single factory. We are expected to design an ER diagram (ERD) to model to manage: • CUSTOMERS as the shops to which the representative salesman sells products • FACTORIES as the manufacturers of those products • PRODUCTS as the list of products being manufactured by a single factory • PURCHASES as the orders made by customers to buy products from a factory Upload an image file that contains your ERD that should describe: 1. The list of entities including weak entities (if any) 2. The list of attributes of each entity, indicating single-valued, multi-valued, composite attributes, key attributes, and derived attributes (if any) 3. The relationships among those entities, including relational attributes (if any) 4. Cardinality ratios and participation constraints (whenever applicable) PS.: You are allowed to add information (but not remove) to the domain to include your own assumptions to the conceptual model. In that case, add a table below the diagram describing such assumptions.
Transcribed Image Text:A representative salesman is someone responsible for selling the products of a given factory to shops that will later resell those products. Each factory manufactures its own list of products. A representative office can sell products from different factories at the same time to the same shop. A product item of a given factory is described as an alpha-numeric ID, a textual description of the product, the price of a single unit, and the tax rate. A shop (here denominated the 'customer') is described by an ID, a name, address, telephone, email and date of the first purchase. A purchase order is described by the date of the purchase, the ID of the customer, a list of products (ID of the item and amount of units being purchased), the ID of the factory and the total amount of the order. Its important to notice that each purchase order can only contain products of a single factory. We are expected to design an ER diagram (ERD) to model to manage: • CUSTOMERS as the shops to which the representative salesman sells products • FACTORIES as the manufacturers of those products • PRODUCTS as the list of products being manufactured by a single factory • PURCHASES as the orders made by customers to buy products from a factory Upload an image file that contains your ERD that should describe: 1. The list of entities including weak entities (if any) 2. The list of attributes of each entity, indicating single-valued, multi-valued, composite attributes, key attributes, and derived attributes (if any) 3. The relationships among those entities, including relational attributes (if any) 4. Cardinality ratios and participation constraints (whenever applicable) PS.: You are allowed to add information (but not remove) to the domain to include your own assumptions to the conceptual model. In that case, add a table below the diagram describing such assumptions.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Control Structure
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Microsoft Visual C#
Microsoft Visual C#
Computer Science
ISBN:
9781337102100
Author:
Joyce, Farrell.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS