1. The online site has members, each of whom is identified by a unique member number...

1. The online site has members, each of whom is identified by a unique member number
and is described by an e-mail address, name, password, home address, and phone
number.
2. A member may be a buyer or a seller.
3. A buyer has a shipping address recorded in the database.
4. A seller has a bank account number and routing number recorded in the database.
5. Items are placed by a seller for sale and are identified by a unique item number
assigned by the system. Items are also described by an item title, a description, and
price
6. Items are also categorized based on a fixed classification hierarchy (for example, a
modem may be classified as COMPUTER → HARDWARE → MODEM).
7. The buyer and seller may record feedback regarding their completed transactions.
8. Feedback contains a rating of the other party participating in the transaction (1–10) and
a comment.
Design an enhanced entity–relationship (EER) diagram for the online_store database.

Expert Solution

Entity: It represents a real world object and is represented by a rectangle, Each entity is an individual table in a database.

Attributes: They describe the properties of an entity. They are represented by an ellipse. They are also known as fields,columns.

Reletionship: They are represented by a diamond. They describe the relationship betwwen two entities.

Cardinality: It represents the no. of associations involved between two enties in a relationship.

There are 4 types of cardinality:

one-one (1-1)
one-many (1-M)
many-one (M-1)
many -many (M-N) - (N used here not to confuse between M and N)

venereology answered 1 year ago

A 3-person jury has 2 members each of whom have independently a probability 0.7 of making...

A 3-person jury has 2 members each of whom have independently a probability 0.7 of making a correct decision. The third juror just flips a coin for each decision. In this jury, the majority rules. A 1-person jury has a probability 0.7 of making a correct decision. What is the probability of the best jury of making a correct decision?

Design a Ship class that has the following members: • A member variable for the name...

Design a Ship class that has the following members: • A member variable for the name of the ship (a string) • A member variable for the year that the ship was built (a string) • A constructor and appropriate accessors and mutators • A virtual print function that displays the ship’s name and the year it was built. Design a CruiseShip class that is derived from the Ship class. The CruiseShip class should have the following members: • A...

Each element has a unique atomic number, which is listed on the periodic table above the...

Each element has a unique atomic number, which is listed on the periodic table above the chemical symbol for the element. The atomic number is equal to the charge on the nucleus. The atomic number also equals the number of protons in the nucleus and the number of electrons in the neutral atom of the element. For example, Fluorine (F) has the atomic number 9, which means that its atoms contain 9 protons and 9 electrons. Zinc (Zn) has the...

Imagine an island with many people on it, each of whom can catch some number of...

Imagine an island with many people on it, each of whom can catch some number of fish or pick some number of coconuts (each person's numbers being different from the rest). Now imagine that they discover a new invention--the ladder! The ladder allows every person to pick twice as many coconuts as before. a. What happens to the marginal cost of fish for each person and what happens to the marginal cost of coconuts? b. Sketch the PPF and show...

An internet research company surveyed 90 online shoppers, each of whom made one purchase today. The...

An internet research company surveyed 90 online shoppers, each of whom made one purchase today. The company recorded the type of purchase each shopper made. Here is a summary. Type of purchase Number of shoppers Beauty supplies 12 Clothing 33 Pet supplies 21 Office supplies 24 Three shoppers from the survey are selected at random, one at a time without replacement. What is the probability that none of the three shoppers purchased beauty supplies? Do not round your intermediate computations....

An insurance company insures 2,000 people each year, each of whom has a 1/1000 chance of...

An insurance company insures 2,000 people each year, each of whom has a 1/1000 chance of an accident in 1 year. Use the Poisson approximation to compute the probability that there will be at most 2 accidents. Also, calculate the exact binomial-(n,p) probability

A company has three employees, each of whom has been employedsince January 1, earns $3,600...

A company has three employees, each of whom has been employed since January 1, earns $3,600 per month, and is paid on the last day of each month. On March 1, the following accounts and balances appeared in its ledger. a. Employees’ Income Taxes Payable, $1,393.70 (liability for February). b. EI Payable, $576.68 (liability for February). c. CPP Payable, $923.32 (liability for February). d. Employees’ Medical Insurance Payable, $1,960.00 (liability for January and February). During March and April, the company...

A stockbroker has a large number of clients. The proportion of clients with whom she does...

A stockbroker has a large number of clients. The proportion of clients with whom she does not communicate during a given month has the beta distribution with parameters α = 6 and β = 2. Determine the probability that, during a given month, the percentage of clients with whom the broker does not communicate will be a) at least 60%. b) between 70% and 80%.

A company has three employees, each of whom has been employed since January 1, earns $3,600...

A company has three employees, each of whom has been employed since January 1, earns $3,600 per month, and is paid on the last day of each month. On March 1, the following accounts and balances appeared in its ledger. Employees’ Income Taxes Payable, $1,393.70 (liability for February). EI Payable, $430.27 (liability for February). CPP Payable, $982.58 (liability for February). Employees’ Medical Insurance Payable, $1,960.00 (liability for January and February). During March and April, the company completed the following related...

A village has six residents, each of whom has accumulated savings of $100. Each villager can...

A village has six residents, each of whom has accumulated savings of $100. Each villager can use this money either to buy a government bond that pays 18 percent interest per year or to buy a year-old llama, send it onto the commons to graze, and sell it after 1 year. The price the villager gets for the 2-year-old llama depends on the quality of the fleece it grows while grazing on the commons. That in turn depends on the...

Question