Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers. Helge purchases inventory from distributors at trade conventions. Each time Helge makes a purchase, the company records the suppliers name, address, date, specific items purchased, price paid for each, and the total amount spent. Helge later researches the inventory items to set the customer price. The company assigns an inventory number to each item purchased and records the customer price for each item. Helge buys price tags and display supplies from Alwin Incorporated, a company that sells them at all trade conventions. All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name. All cash received from sales are also deposited to the same bank account. Several times a year Helge rents display space at dealer conventions. A deposit is always required, and the entire fee is due the day the convention starts. Helge records the deposit and final payment, along with the convention's name and address, in the same worksheet on which purchases of inventory and supplies are recorded. Which of the following would not be an attribute in the Purchases table?   Person's name or company name from whom the purchase was made.   Date of purchase.   Total amount of purchase.   Address where purchase was made.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

KA 

Helge Autoparts sells new and refurbished auto parts exclusively to auto dealers. Helge purchases inventory from distributors at trade conventions. Each time Helge makes a purchase, the company records the suppliers name, address, date, specific items purchased, price paid for each, and the total amount spent. Helge later researches the inventory items to set the customer price. The company assigns an inventory number to each item purchased and records the customer price for each item. Helge buys price tags and display supplies from Alwin Incorporated, a company that sells them at all trade conventions. All inventory and supplies purchases are immediately paid for with cash or with checks from a bank account in Helge's name. All cash received from sales are also deposited to the same bank account. Several times a year Helge rents display space at dealer conventions. A deposit is always required, and the entire fee is due the day the convention starts. Helge records the deposit and final payment, along with the convention's name and address, in the same worksheet on which purchases of inventory and supplies are recorded. Which of the following would not be an attribute in the Purchases table?

 

Person's name or company name from whom the purchase was made.

 

Date of purchase.

 

Total amount of purchase.

 

Address where purchase was made.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Control Structure
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education