Question: Imagine that you need to design a database for an on-line wine shop. The shop sells bottles of wine. Each bottle has a price

Imagine that you need to design a database for an on-line wine shop. The shop sells bottles of wine. Each

Imagine that you need to design a database for an on-line wine shop. The shop sells bottles of wine. Each bottle has a price and a volume (for example, 0.75 1 or 0.375 1). Each wine has a name, type (red, white or rose), year of production, grape variety, and a wine-maker. Each wine-maker comes from a particular region and country (for example, Bordeaux, France). The same wine-maker can make several different kinds of wine, and there can be several wine-makers in the same region. The same wine name can be used by several wine-makers, but the (wine name, wine-maker) combination is unique. You can also assume that wine-maker's name is unique. (a) Draw an entity-relationship diagram for the wine-shop database. (10) (b) Describe the schemas for the wine-shop database (names of tables, column names, types of 1 values for each attribute). (5) (c) What are the candidate keys in the tables for the wine shop? (5) (d) What are the foreign keys in the tables for the wine shop? (5)

Step by Step Solution

★★★★★

3.50 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a EntityRelationship Diagram Entities Wine WineMaker Region Bottle Relationships Produces WineMa... View full answer

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 Programming Questions!

What specific subject areas are you anticipating being the most challenging for you during the CPC certification exam? Why will these specific subject areas be so challenging for you? What are you...

Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have...

1. Consider the futures contract to buy/sell December gold for $500 per ounce on the New York Commodity Exchange (CMX). The contract size is 100 ounces. The initial margin is $3,000, and the...

After completing the Sandlands Vineyards case study, prepare a slide show that answers the following questions: Is the premium wine market an attractive market, or a good place to invest? How is the...

For this assignment, assume you are in school full time and are starting a part-time side business. You will need to create a database for your part-time concierge service. Examples of specialty...

Imagine that you have to design a database that would match information about job postings and internship opportunities etc. to candidate NYU graduating students? (So, instead of matching patrons to...

Part A: Draw the ER diagram Identify the business situation ( a small / medium size business ) that you wish to design a database for. The situation needs to be a real life one ( not an imaginary...

Part A: Draw the ER diagram Identify the business situation ( a small / medium size business ) , that you wish to design a database for. The situation needs to be a real life one ( not an imaginary...

The intangible assets section of the balance sheet for Gore Company at December 31, 2010, is presented here. Patents ($70,000 cost less $7,000 amortization) ...... $63,000 Copyrights ($48,000 cost...

Convicted drug dealers were scored on the Wanting Recognition (WR) Scale -a scale that provides a quantitative measure of a person's level of need for approval and sensitivity to social situations....

Question 3 The height of a cricket ball hit by a batman can be predicted using the following polynomial function: h ( t ) = - gt ^ ( 2 ) + v _ ( 0 ) t + h _ ( o ) where: g is the gravitational...

Use the financial statements for Allendale Company from Problem 13-17A to calculate the following ratios for 2019 and 2018: Financial Statement From Problem 13-17A a. Working capital. b. Current...

The Central Valley Company has prepared division overhead budgets for budgeted-volume levels before allocations as follows: Management has decided that the most appropriate inventory costs are...

The following account titles and balances were taken from the adjusted trial balance of King Co. for 2018. The company uses the periodic inventory system. Account Title Balance Sales returns and...

During 2010, Diaz Corporation had net income of $41,000. Included on its income statement were depreciation expenses of $2,300 and amortization expense of $300. During the year, accounts receivable...

Portofino Company made purchases on account from three foreign suppliers on December 15, 2012, with payment made on January 15, 2013. Information related to these purchases is as follows: Portofino...

Exercise 10-17(Static) Part 9When interpreting the fund balances measure, which of the following is correct?Multiple ChoiceA ratio of 5 percent or better is considered adequate.A ratio of 15 percent...

From a behavioral point of view, what potential problems can occur when implementing a target costing system?

Chow Company is an insurance company in Hong Kong. Chow hires 55 people to process insurance claims. The volume of claims is extremely high, and all claims examiners are kept extremely busy. The...

Characteristics of a MACS: rewards Can goal congruence be increased if rewards are tied to performance? Explain.

The following information is based on independent random samples taken from two normally distributed populations having equal variances: Based on the sample information, determine the 95% confidence...

A decision maker wishes to test the following null and alternative hypotheses using an alpha level equal to 0.05: The population standard deviations are assumed to be known. After collecting the...

The owner of the A.J. Fitness Center is interested in estimating the difference in mean years that female members have been with the club compared with male members. He wishes to develop a 95%...