Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SoundBuster.com is a music web site that buys and sells CDs online for pop music fans. Each CD is uniquely identified by an item number
SoundBuster.com is a music web site that buys and sells CDs online for pop music fans. Each CD is uniquely identified by an item number and is also characterized by a description, asking price, condition, and open-ended comments. SoundBuster.com works with many different individuals, called clients, who sell items to and buy CDs from the store. Some clients only sell CDs to SoundBuster.com, some only buy CDs, and some others both sell and buy. A client is identified by a client number and is also described by a client name and client address. When SoundBuster.com sells a CD in stock to a client, the owners want to record the commission paid, the actual selling price, sales tax (tax of zero indicates a tax- exempt sale), and date sold. When SoundBuster.com buys an item from a client, the owners want to record the purchase cost, date purchased, and condition at time of purchase. The entities for the data model are below. Sell Buy Purchase_Cost Condition Date_Purchased Selling Price Commission Sales_Tax Date_Sold CD clients Description Asking Price Condition Comments client__Name Client Name client_Street client_Postal_code client_city client_Province client_country SoundBuster.com is a music web site that buys and sells CDs online for pop music fans. Each CD is uniquely identified by an item number and is also characterized by a description, asking price, condition, and open-ended comments. SoundBuster.com works with many different individuals, called clients, who sell items to and buy CDs from the store. Some clients only sell CDs to SoundBuster.com, some only buy CDs, and some others both sell and buy. A client is identified by a client number and is also described by a client name and client address. When SoundBuster.com sells a CD in stock to a client, the owners want to record the commission paid, the actual selling price, sales tax (tax of zero indicates a tax- exempt sale), and date sold. When SoundBuster.com buys an item from a client, the owners want to record the purchase cost, date purchased, and condition at time of purchase. The entities for the data model are below. Sell Buy Purchase_Cost Condition Date_Purchased Selling Price Commission Sales_Tax Date_Sold CD clients Description Asking Price Condition Comments client__Name Client Name client_Street client_Postal_code client_city client_Province client_country
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started