Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Flow Diagram Hello I need help creating a DFD with the following business procedure I have provided below: Business Description: Eklektic Jewelry Design Studios

Data Flow Diagram

Hello I need help creating a DFD with the following business procedure I have provided below:

Business Description:

Eklektic Jewelry Design Studios is a company that handles their customers jewelry needs. Customers are able to create jobs for the piece of jewelry that they want to purchase. The customer gets a chance to customize his/her jewelry by being able to choose stone cut, stone clarity, stone carat, stone type, component color, metal type, metal purity, gold karat, and the component type. Vendors supply the components that are used to customize the jewelry. A customers job can/will create no or many invoices and the invoices can be paid through various payment types. Jobs can produce no or many tasks that are expressed on a shop sheet line. Employees are assigned to shop sheet lines that tell them what tasks to complete. An employee can have many skills that will help them complete the jobs better. In addition, customers are able to add items to their wish list and return items if they are not satisfied.

Mission:

We will focus on the payment process. In the payment process, a customer must first make a job. Once the job is made, an invoice will be sent. Once the invoice is sent, the customer can choose how he/she would like to pay through the payment_type. If the customer decides to pay with a credit card, then the credit card type will be listed on the invoice. The invoice status will tell whether or not the invoice is paid or unpaid. Each customer lives in a state or province that requires him/her to pay taxes. The applied tax percentage will be dependent on the state or province the customer lives in.

Tables included:

CUSTOMER

JOB

INVOICE

PAYMENT_TYPE

INVOICE_STATUS

CARD_TYPE

STATE_PROVINCE

TAX

Process Map:

image text in transcribed

Customer Creates Job Job Creates invoice Tax Calculated from stated province table Payment Type? -Electronics Fement- Credit Card Credit Card Type? Invoice Status Changes American Express

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

8th Edition

013460153X, 978-0134601533

More Books

Students also viewed these Databases questions

Question

What impediments originate in society at large?

Answered: 1 week ago

Question

How have their tactics changed?

Answered: 1 week ago

Question

What impediments have financial or economic origins?

Answered: 1 week ago