Create an event-agent-database table

Assignment Help Database Management System

Reference no: EM131841961

Question: Books Ga'Lore! needs assistance to document its business processes for the revenue cycle - customer credit card sales. The following is a narrative, along with a list of tables in the Books Ga'Lore! database

Books Ga'Lore! sells books. When a customer makes a credit card purchase at their retail outlet, an employee totals the items. The credit card information is submitted to the credit card company. After receiving credit confirmation, the employee generates a receipt then gives the receipt and items to the customer.

Books Ga'Lore! database tables: Item, Customer, Sales Order, Sales Order Line, Vendor, Purchase Order, Purchase Order Line, Employees, Employee Type, Time, Cash Receipts,
Cash Account, and General Ledger.

Requirements

Complete the following for Books Ga'Lore!

1. Annotate the narrative; label and number the events.

2. Create an Event-Agent-Database (EAD) table. (use the appropriate tables from the list provided)

3. Build a level-0 DFD for sell-books.

Reference no: EM131841961

Questions Cloud

Identify the greatest challenge or asset : In the book Strategic Vision America and the Crisis of Global Power by Zbigniew Brzezinski, he refers to the list of liabilities and assests on America's.

What is a call option and put option : What is a put option? What is a call option?

What is the delta of the call option : what is the current value of a one-year European call option on XYZ with an exercise price of $12? What is the delta of the call option?

What position should the manager take : What position (long or short) should the manager take? Please explain.

Create an event-agent-database table : Books Ga'Lore! sells books. When a customer makes a credit card purchase at their retail outlet, an employee totals the items.

Find probability of customers visiting the store : The Brainchild is a store that specializes in educational toys for children. In order to increase the probability of customers visiting the store.

What is optimal total annual cost : Brady Jones is a manager at a local store that sells computers. He needs to decide how many computers to order based on the quantity discount schedule below.

Which employer was the primary employer : The union distinguishes between displaying a stationary banner and picketing (where union members move about, carring wooden signs).

How to win where you are playing : Do you agree with the authors that these five questions capture the essence of strategy? Do you feel Apple has answered and implemented these five questions.

User Account

All Pages