(Answered) 1 the universal product code upc is a bar-coded number

Engineering

1) The universal product code (UPC ) is a bar-coded number that uniquely identifies many products sold in the United States. Consider how the design of the RMO database might change if all items sold by RMO were required by law to carry a permanently attached UPC (eg., on a label sewn into a garment or on a radio frequency ID tag attached to a product). How might the RMO relational database schema change under this requirement?

2) Assume that RMO will begin asking a random sample of customer who order by telephone about purchase made from competitor. RMO will give customers 15 percent discount on their current order in exchange for answering a few questions. To store and use this information, RMO will add two new classes and three new associations to the class diagram. The new classes are Competitor and ProductCategory. Competitor has a single attribute called Name. ProductCategory has four attributes: Description, DollarAmountPurchased, MonthPurchased, and YearPurchased. Revise the relational database schema shown in figure 12-10 to include the new classes and associations. All tables must be in 3NF.

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M92028899
Price:- $20

Verified Expert

Priced at $40 Now at $20, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Strings in cstrings manipulationwrite one main code with

Strings in C++ Strings manipulation Write one main code with the following functions. Toggle Write a function called toggle() that accepts a string, and an integer. The function checks whether the character at the positi ...

A wholesale t-shirt company offers sizes small medium large

A wholesale T-shirt company offers sizes small, medium, large, and extra-large in organic or non-organic cotton and colors white, black, gray, blue, and red. How many different T-shirts are there to choose from?

Scenario you have been asked to develop a company policy on

Scenario: You have been asked to develop a company policy on what should be done in the event of a data breach, such as unauthorized access to your company's customer database. What sort of process would you use to devel ...

Question 1 designing team and team identityusing the

Question: 1. Designing Team and Team Identity. Using the Internet, team should read at least 5 academically reviewed articles on designing. 2. Please do not change the wording of the original summary. Include the team me ...

The systems development lifecycle sdlc provides a

The systems development lifecycle (SDLC) provides a standardized process for all phases of any system development. What are the different phases involved in SDLC give a brief note on all its phases in your own words. (no ...

Questionif a string is stored at the memory address 0 times

Question: If a string is stored at the memory address 0 times 20008000 and the string is "Cortex-M", show the memory content in hex format starting at 0 times 20008000. How many bytes does this string take in the memory? ...

Qestion what steps are involved for implementing sw s0 0

Question : What steps are involved for implementing sw $s0 , 0 ( $s1) instruction . Draw data path and control path for this instruction. The response must be typed, single spaced, must be in times new roman font (size 1 ...

Question ransomware to pay or not to pay when it comes to

Question: Ransomware: To pay or not to pay? When it comes to corporate data, should corporations pay? Can you trust paying? What can be done to protect against ransomware?Would you pay if it were your own personal data? ...

Question you can transfer your health data to another

Question: You can transfer your health data to another personal health record provider such as Microsoft HealthVault. What privacy issues are involved? Express your views on using this type of system, make sure to includ ...

Suppose that relations r and s contain 20 and 30 blocks

Suppose that relations r and s contain 20 and 30 blocks respectively, and the block nested-loop join algorithm is used to natural-join r and s. What is the cost in terms of number of seeks and number of block transfers i ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert