Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please just work through number 4. The following is a short description of a print shop. Based on this description, please prepare the following items.

Please just work through number 4. image text in transcribed

The following is a short description of a print shop. Based on this description, please prepare the following items. 1. A DFD context diagram of the case description 2. Level 0 DFD diagram of the case description 3. Data model in ER notations of the case description 4. Data requirements of two data stores (as identified in the DFD level O) expressed in XML Instructions The level 0 DFD diagram must have at least five activities and two data stores. Some information about the data elements of the data stores is provided in the case description. You can assume some additional data elements of these data stores. The data model (ER) should include-entities, attributes, relations, and cardinalities. If necessary, you can make some assumptions to create the ER model. One XML file should contain data elements of both these data stores. You need to have specific values (at least 5 rows) of data elements in this XML. The information of the specific values of the data elements/attributes are not provided in the case description. You need to assume reasonable values of these elements. The XML should have some data attributes as well.[ Please submit electronically, a word document where all the diagrams are provided. You can use any tool to draw the diagrams. All your assumptions about the models can be mentioned in the document. Submit a .xml file separately. Upload both these files at blackboard. Note that this is an individual midterm. Students are advised not to consult/discuss their solutions with other classmates. The print shop case Business customers often outsource their mass printing orders to print shops. The following describes the overall process of a print shop-PrintAll. PrintAll specializes printing marketing communication materials such as brochures and flyers. A business customers places print order to PrintAll and this order is received by a sales associate. After receiving the order, the production supervisor prepares an order and informs the graphic artist about the production schedule. Based on the available raw materials (generally papers and ink), the graphic artist places a production notice to the procurement department. The order is processed as received. The order repository contains information about the details of customer requests, quantity, date, and the promised delivery time. The payment information is also stored in the order repository. For high efficiency and on time delivery, PrintAll mantains a schedule for processing the print job. It is the responsibility of the production supervisor to maintain this schedule. This schedule contains information such as expected printing time, raw materials required, and the list of all orders that need to be processed. Once the printing is done, the production supervisor checks the quality of the prints and on satisfactory quality, the printing is delivered to the customer. Along with the printing, the customer receives the invoice and the payment information is updated in the customer file by the account's clerk. A reminder is sent to the customer if the payment is not received within a due date. The following is a short description of a print shop. Based on this description, please prepare the following items. 1. A DFD context diagram of the case description 2. Level 0 DFD diagram of the case description 3. Data model in ER notations of the case description 4. Data requirements of two data stores (as identified in the DFD level O) expressed in XML Instructions The level 0 DFD diagram must have at least five activities and two data stores. Some information about the data elements of the data stores is provided in the case description. You can assume some additional data elements of these data stores. The data model (ER) should include-entities, attributes, relations, and cardinalities. If necessary, you can make some assumptions to create the ER model. One XML file should contain data elements of both these data stores. You need to have specific values (at least 5 rows) of data elements in this XML. The information of the specific values of the data elements/attributes are not provided in the case description. You need to assume reasonable values of these elements. The XML should have some data attributes as well.[ Please submit electronically, a word document where all the diagrams are provided. You can use any tool to draw the diagrams. All your assumptions about the models can be mentioned in the document. Submit a .xml file separately. Upload both these files at blackboard. Note that this is an individual midterm. Students are advised not to consult/discuss their solutions with other classmates. The print shop case Business customers often outsource their mass printing orders to print shops. The following describes the overall process of a print shop-PrintAll. PrintAll specializes printing marketing communication materials such as brochures and flyers. A business customers places print order to PrintAll and this order is received by a sales associate. After receiving the order, the production supervisor prepares an order and informs the graphic artist about the production schedule. Based on the available raw materials (generally papers and ink), the graphic artist places a production notice to the procurement department. The order is processed as received. The order repository contains information about the details of customer requests, quantity, date, and the promised delivery time. The payment information is also stored in the order repository. For high efficiency and on time delivery, PrintAll mantains a schedule for processing the print job. It is the responsibility of the production supervisor to maintain this schedule. This schedule contains information such as expected printing time, raw materials required, and the list of all orders that need to be processed. Once the printing is done, the production supervisor checks the quality of the prints and on satisfactory quality, the printing is delivered to the customer. Along with the printing, the customer receives the invoice and the payment information is updated in the customer file by the account's clerk. A reminder is sent to the customer if the payment is not received within a due date

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Spatial And Temporal Databases 11th International Symposium Sstd 2009 Aalborg Denmark July 8 10 2009 Proceedings Lncs 5644

Authors: Nikos Mamoulis ,Thomas Seidl ,Kristian Torp ,Ira Assent

2009th Edition

3642029817, 978-3642029813

More Books

Students also viewed these Databases questions