PLEASE DRAW THE DIAGRAM ACCORDING TO THE QUESTION: 4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager.

PLEASE DRAW THE DIAGRAM ACCORDING TO THE QUESTION: 4. Company TeaLeaves has recently adopted a new order management system for handling production requests. The sales representative can place a new order for production. If special materials are required for producing the new order, then an order is placed for special materials with the supplier. Otherwise, if no special materials are required for producing the new order or the supplier has finished providing the special materials, the order is added to the production list. Afterwards, the order is scheduled for production. Once the order is confirmed, a letter is generated to the sales representation and to the manager.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter12: System Acquisition And Development

Section: Chapter Questions

Problem 3PSE: A new sales ordering system needs a relational database that contains a customer table, a product...

See similar textbooks

Similar questions

Create a Crow’s Foot ERD to include the following business rules for the “ProdCo company” 1. Each sales representative writes many invoices. 2. Each invoice is written by one sales representative. 3. Each sales representative is assigned to one department. 4. Each department has many sales representatives. 5. Each customer can generate many invoices. 6. Each invoice is generated by one customer.
Use the following business rules to create a Crow’s Foot Entity Relationship Diagram. Write all appropriate connectivities and cardinalities in the ERD. Add other linking entities as needed. • A department employs many employees, but each employee is employed by one department. • Some employees, known as “rovers,” are not assigned to any department. • A division operates many departments, but each department is operated by one division. • An employee may be assigned many projects, and a project may have many employees assigned to it. • A project must have at least one employee assigned to it. • One of the employees manages each department, and each department is managed by only one employee. • One of the employees runs each division, and each division is run by only one employee.
A bright , young engineer has recommended that they eliminate the assignment of an order to a specific stock person and allow both stock persons to select their next activity from a single first - come , first - served order queue . b ) Develop a model of this system using Arena and draw the model in your paper using software syntax . Explain the functions of each flow chart module you used in your model .
Create a Crow's Foot ERD to include the following business rules for the ProdCo company:a. Each sales representative writes many invoices.b. invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales representative.e. Each customer can generate many invoicesd. Each invoice is generated by one customer
Create an Entity Relationship Diagram using the following scenario: A restaurant chain has several store locations in a city (with a name and postal code stored for each), and each is managed by one manager. Managers manage only one store. Each restaurant location has its own unique set of menus. Most have more than one menu (e.g., lunch and dinner menus). Each menu has many menu items, and items can appear on multiple menus, and with different prices on different menus.
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
A company keeps track of its departments, employees and mobile numbers assigned to employees by the department. Draw an ER diagram using the (min,max) notation for structural constraints, given that: An employee has a unique id, name and can have more than one address A department has a unique id, name and one address A mobile is identified by its number An employee must work in one department only A department has a minimum of 4 employees A department can own up to 10 mobiles An employee can be assigned up to 2 mobiles State any assumptions you make.
Draw an Entity relationship diagram (ER) for a university according to the following rules: ‐ For each student the university needs to keep track of: first name, last name, student id, address, phone no and their major. ‐ The student id is identical for each ‐ Each course has a number, name and credit. The course number is unique for each course. ‐ Each department has a name, code and The code is unique for each department. ‐ Each course may has one or more sections where each section is belong to only one ‐ A department offers one or many 7-‐ Some courses have perquisite courses. 8-‐ Each student could register in one or more courses. In your diagram you need to show the following: 1-‐ The primary key for each entity. 2-‐ The cardinality and participation between entities.
Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 A wedding hall (Shadi Hall) organizes different types of functions for its customers. Each function is hosted (owned) by exactly one customer. A customer may host many functions. There are many employees working at the company. Before each function date, the administrations of the wedding hall calls a meeting of relevant employees to finalize the arrangements of the function. Each meeting belongs to exactly one function. Comments/suggestions of each employee in the meetings and the decisions of the meetings are also recorded. Instructions: • Identify the relationship between Entities (clearly showing the cardinality and participation)
Draw a dependency diagram for this data. You may assume the following:• Each material item has one or more suppliers. Each supplier may supply one or more items or may not supply any items.• The unit price for a material item may vary from one vendor to another.• The terms code for a supplier uniquely identifies the terms of the sale (e.g., code 2 means 10 percent net 30 days). The terms for a supplier are the same for all material items ordered from that supplier.
In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Product
Draw an Entity Relationship Diagram for all of those below. Draw an ER diagram to represent information about students. A student is identified by his/her student number. Student’s name (first and last), permanent address, phone number, gender and date of birth are also stored. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production. Some students live in student halls. Each hall has a name (unique) and an address. Each student has a number (unique) and a name. Assume that there are students living in every hall. Each text book has a unique ISBN (International Standard Book Number), and contains several chapters. Each chapter has a chapter number (unique within a book), the number of pages and the number of references. A chapter covers a single topic, but the same topic may be covered in various books. Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for…

SEE MORE QUESTIONS

Recommended textbooks for you

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Principles of Information Systems (MindTap Course…

Computer Science

ISBN:

9781305971776

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS