Question

Competing with the Big Boys Provenzo’s Rentals is a small privately owned business that rents sports equipment in Denver, Colorado. The company specializes in winter rentals including ski, snowboard, and snowmobile equipment. Provenzo’s has been in business for 20 years and, for the first time, it is experiencing a decline in rentals. Greg Provenzo, the company’s owner, is puzzled by the recent decreases. The snowfall for the past two years has been outstanding, and the ski resorts have opened earlier and closed later than most previous years. Reports say tourism in the Colorado area is up, and the invention of loyalty programs has significantly increased the number of local skiers. Overall, business should be booming. The only reason for the decrease in sales might be the fact that big retailers such as Walmart and Gart’s Sports are now renting winter sports equipment. Provenzo would like your team’s help in determining how he can use e-business and Business 2.0 to help his company increase sales, decrease costs, and compete with these big retailers.

1. identify the nouns for the case described.

2. create conceptual data model for the case described

3. create logical data model for the case described

4. create physical data model for the case described

Answer 1

1. the nouns for the case described-

• Equipment
• Customers
• Rental
• Season
• company

2. Logical relational model -

• This model has has been converted into 3NF
• Here each entity and its attributes are in tabular form
• Data types of each attribute has been mentioned with it
• The primary key as PK and foriegn key as FK has been mentioned there.

If any doubt, please feel free to ask and comment, i would like to answer them.
Thank you