A library has a collection of items that they loan out to members. They refer to these items as holdings (as these are the items held). For each holding, they must keep track of its estimated value and the date it was originally acquired by the library. Items can be books, audio books, DVDs, or software. For books, we need to know the publisher. Audio books, the label. DVDs, the studio. And for software, the developer. 1. Draw an ER diagram that includes all of the necessary information in a single entity.
2. Draw an EER diagram version using supertypes and subtypes. Include subtype discriminators. Indicate whether there should be subtype overlap or disjoint. Indicate whether there is full or partial specialization. Add Assumptions to the side of your diagram to justify your design choices.
3. Add an entity for Library_Patron (we need to know at least their name and email address), and create an entity to keep track of when holdings are checked out and returned (and by whom).
4. Duplicate the EER diagram you made and expanded, but this time show the reverse of your choices for disjoint/overlap and partial/full-specialization. Add Assumptions to the side of your diagram to justify your design choices.
ER diagram should be made on paper or software anything works.

it is much more convenient for the consumer to order something online, rather than going to a store. it saves them time and money for them, especially if that item is not accessed easily.

kuikmnbk; ujgkjb; u65416+98532

9+5

the benefits of raising bc’s minimum wage to $15 through a

series of pre-announced staged increases far outweigh the likely

costs. claims that such an increase will lead to massive job losses

in low-wage sectors of the economy are not credible.

• an increase to $15 would result in some job losses. however,

the likely impact is less than a 1 per cent reduction in the overall

provincial employment rate, and a 7.6 per cent reduction in the

employment rate for those currently making between $10.25

and $15 per hour.

• the large job loss impacts predicted by some opponents of

minimum wages misrepresent the existing economic research. in

reading and using that research, it is important to recognize that

estimates showing job loss effects of minimum wage increases

apply only to teenagers. estimated effects for young adult and

adult workers range from insignificant to non-existent.

• focusing on teenage workers plays up an inaccurate stereotype

about who earns very low wages in bc and leads to exaggerated

claims about job losses. only 26 per cent of those currently making

between $10.25 and $12 are teenagers, and only 5 per cent

of those making between $12 and $15 are teenagers.