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.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd