Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compare two ER-models: Attached is the business rules for case and two solutions presented by two different people for the same case . Compare ER

Compare two ER-models: Attached is the business rules for case and two solutions presented by two different people for the same case .

Compare ER model Solution-1 & Solution-2 and write answers for the below questions

1) Identify 3 differences between Solution-1 & Solution-2

2) For each difference, discuss in a short paragraph

a) which do you think is correct the sample 1 or solution 2 and why is it so?

b) what elements of the case did the person interpret to Solution 1 that led to draw model in that fashion?

c) what elements of the case did the person interpret to Solution 2 that led to draw model in that fashion?

image text in transcribed

image text in transcribed

image text in transcribed

Hot Deals is a start-up company that offers deals for gift certificates (e.g., gift certificate to Chipotle, Starbucks, Olive Garden) and merchandise (e.g., area rugs, headphones) via an app. The gift certificates and merchandise are offered at a price lower than retail value, but the prices are only available for a short time and only a specified quantity can be sold. - When customers create accounts on the app, their first name, last name, email address, gender, username, and password are collected. Customers can also refer new customers to the site, so the current customer that referred the new customer should be stored. A referral is not required to create an account. Referring others is also not required, but a customer can refer as many others as they would like. - Customers can provide multiple shipping addresses to facilitate sending gifts to family and friends. A label for each address should also be stored. For each order, the shipping address selected by the customer should be recorded. Each order can only be shipped to one address. - Customers' activity on the app should be stored and fall into one of four categories - logins, searches, menu clicks, and deal views. For each activity, the timestamp associated with the activity should be stored along with what account was used. Logins are when an account log in is attempted. Both searches and menu clicks represent users navigating through the app, either by typing in a search string or clicking links in the menu. For searches, the text string entered into the search box should be stored, and for menu clicks, the name of the menu button clicked is stored. Deal views are when the description and details of a deal are viewed, and the unique ID number of this deal should be store for this activity type. No additional information is stored for logins. - Customers can purchase as many deals as they would like within each order as long as the deal is still available. Each customer can also purchase each deal as many times as they would like. - Each deal has a start date time and duration, as some deals are for just a few hours and some are for 24 hours. Each deal also has a name, sale price, and original retail value. For example, an Olive Garden $40 gift certificate might have a sale price of $20 but the original retail value was $40. Each deal can be a gift certificate, merchandise, or both. For deals containing gift certificates, the address of the store or restaurant at which the certificate can be used should be stored. For deals containing merchandise, the brand of the merchandise and categories (e.g.apparel, electronics) should be stored. Each merchandise must belong to at least one category, and the categories are set by Hot Deals. Merchandise can also belong to multiple categories. - Within the app, customers can also specify which categories of deals they are most interested in, and this is stored along with their account information. Each customer can specify as many categories of interest as they wish

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions