Question
The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells
The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells antique dining room tables and new tablecloths. The antiques are purchased from both individuals and wholesalers, and the new items are purchased from distributors. The stores customers include individuals, owners of bed-and-breakfast operations, and local interior designers who work with both individuals and small businesses. The antiques are unique, although some multiple items, such as dining room chairs, may be available as a set (sets are never broken). The new items are not unique, and an item may be reordered if it is out of stock. New items are also available in various sizes and colors (for example, a particular style of tablecloth may be available in several sizes and in a variety of colors)
CIICTON FR tahlo 1. Using a Table notation format (e.g., RELATION_NAME (Column 1, Column 2, ...) ), write two tables below ( 10pts). a. Customer table: b. Purchase table: 2. Elaborate potential problems (modification anomalies) of both tables that are likely to occur when inserting, updating, and deleting data in those tables (CUSTOMER and PURCHASE) in a minimum of 200 words ( 10pts). 3. Identify the number of possible themes for CUSTOMER table and suggest tables per each theme using a Table notation format (10 pts)
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