Question

Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. Given the functional description of the processes encountered at Automata's purchasing department, do the following: a. Identify all of the main entities b. Draw a Crow's Foot ERD for Automata Inc. and list all the assumptions you make based on your understanding of the problem

          Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. Given the functional description of the processes encountered at Automata's purchasing department, do the following:
a. Identify all of the main entities
b. Draw a Crow's Foot ERD for Automata Inc. and list all the assumptions you make based on your understanding of the problem

Show more…

automata inc produces specialty vehicles by contract the company operates several departments each of which builds a particular vehicle such as a limousine a truck a van or an rv before a ne 14274

Added by Barbara C.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

06/07/2023

Step 1

Identify all of the main entities: -Automata Inc. -Purchasing Department -Suppliers b. Draw a Crow’s Foot ERD for Automata Inc. and list all the assumptions you make based on your understanding to the problem: -Automata Inc. manufactures specialty vehicles by Show more…

Show all steps

lock

Thanks for your feedback!

Automata Inc. produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, a truck, a van, or an RV. Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata's purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials. The order received by the purchasing department may contain several different items. An inventory is maintained so that the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers. Given the functional description of the processes encountered at Automata's purchasing department, do the following: a. Identify all of the main entities b. Draw a Crow's Foot ERD for Automata Inc. and list all the assumptions you make based on your understanding of the problem

Play audio

Feedback

Powered by NumerAI

Akash M and 83 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

00:01 Based on the functional description provided, following are the main entities in the purchasing department of automata inc.

00:12 First one is department represents the different departments with automata inc that build specific vehicle.

00:25 Vehicle then vehicle represents the different types of vehicles produced by automata inc.

00:43 Each department is responsible for building a specific type of vehicle.

00:48 Then order represents the order placed by a department to purchasing department for specific component and order can contain multiple items.

01:03 Then item represents the specific component required requested in an order.

01:12 Each item may have several supplier.

01:15 Now supplier represents the supplier from whom items can be ordered.

01:23 Now assumptions based on understanding of the problem.

01:27 Each department can place multiple orders and each order can contain multiple items.

01:32 Each item can be ordered from multiple suppliers and inventory is maintained to track the availability of items in stock.

01:40 When an item is not in inventory, it needs to be ordered from a supplier.

01:45 The database will store information about orders, items, suppliers and inventory to facilitate the tracking and delivery of materials.

01:56 I am unable to directly create visual context like crows foot erd diagrams.

02:02 However, i can provide you with a textual representation of the crows foot erd for automata inc based on the entities identified and assumptions made...

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later