Question: This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which

This question asks you to develop a database from spreadsheet data.

You are given a sample list of transactions for Online Management Training Inc,

which includes columns below:

Cust ID Region Payment Source Amount Product Time of Day

(A) Design a database that keeps track of customer information. Add other fields that hold customer information in addition to the CustID. Indicate at least two tables in the relational database that will hold the data above.

(B) Show the attributes and fields in each table. Indicate the primary key in each table.

(C) Draw an entity relationship diagram (similar to Figure 6. 7 ) Make up sample data with three rows of data in each table.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which includes columns below: Cust ID Region...

1. Chapter 2 (15 points) Review Question 2-2 on Page 69 ("How do information systems serve different management group in a business and how do systems that link the enterprise improve organizational...

leauig web browser...) 3. (10 points) This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which...

This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which includes columns below: Cust ID Region...

This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which includes columns below: Cust ID , Region,...

This question asks you to develop a database from spreadsheet data. You are given a sample list of transactions for Online Management Training Inc, which includes columns below: Cust ID Region...

This project gives you an opportunity to learn how to use Excels PivotTable functionality to analyze a database or data list. Use the data file for Online Management Training Inc. described earlier...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

Write a paper about Cultural theory How effective is management at communicating company values?

Explain why cultural factors should be an important consideration in analyzing and choosing among alternative strategies.

A company's 'bottom line' or net income decreased. Which of the following statements is most correct? Group of answer choices The only possible cause is that sales decreased. The only possible cause...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

3. What measures in addition to turnover and employee complaints could be used to evaluate the effectiveness of G4Ss training initiatives?

4. Create a briefing for division managers showing the advantages and disadvantages of using MOOCs. Use websites, including www.td.org, www.coursera.org, and www.mooc-list.com.

LO3 Identify three types of analyses used to determine training needs.