Figure 2-22 attached picture e. All entities should have a primary key, even though this diagram shows many entities without primary keys. What would be an appropriate primary key for the PRODUCED IN entity? Explain why you chose that primary key for the PRODUCED IN entity.
f. The textbook author frequently leaves an intersection entity with no attributes on "first draft" data models provided in the book. Thus, the PRODUCED IN entity has no attributes on the data model. Think about the purpose of this entity for the Pine Valley Furniture Company and name at least one non-key attribute that you believe might be stored in the PRODUCED IN entity. I recommend that you think about what data might have to be stored for a
furniture manufacturing company in order to answer this question.
g. Make up three sample rows of data each for the WORK CENTER, PRODUCT and PRODUCED IN entities. This means you will have a total of 9 rows of data (3 rows in each of 3 entities). Be sure to include data for all primary and foreign keys. If you don’t understand what I mean by “sample data,” refer to the first week exercise that we completed via Zoom class. If you weren’t in class, then watch the Zoom recording for Thursday, 1/28 or look at Figure 1-17 of your text. Again, I recommend that you think about what data attributes and data values would be reasonable for a wood furniture manufacturing company in order to answer this question.

The following are line items from the horizontal analysis of an income statement:increase/ (decrease) increase/ (decrease) 2017 2016 amount percent fees earned $120,000 $100,000 $20,000 20% wages expense 50,000 40,000 10,000 25 supplies expense 2,000 1,700 300 15 which of the items is stated incorrectly? a. fees earned b. supplies expense c. none of these choices are correct. d. wages expense

Which represents a surplus in the market? a market price equals equilibrium price. b quantity supplied is greater than quantity demanded. c market price is less than equilibrium price. d quantity supplied equals quantity demanded.

Imagine us is a startup that offers high definition 3d prenatal ultrasounds for high-end customers. the service process includes four activities that are conducted in the sequence described below. (the time required for each activity is shown in parentheses): activity 1: welcome a patient and explain the procedure. (20 minutes)activity 2: prep the patient (e.g., show them to the room, apply ultrasound gel). (17 minutes) (*your id number represents the amount of time needed to complete this task)activity 3: take images. (5 minutes)activity 4: discuss diagnostic with patient. (20 minutes)at each location there are employees (servers) s1, s2, and s3. the assignment of tasks to servers is the following: s1 does activities 1 and 2.s2 does activity 3.s3 does activity 4.a. what is the capacity of this process (in customers per hour)? b. suppose 3 patients arrive every hour on average. ignoring any “start of day” or “end of day” effects, what are the utilizations of all three servers (%)? c. suppose each activity can be done by any server and any server can do any set of activities. however, each activity is done by only one server. for example, a possible assignment includes: s1 does activity 1, s2 does activity 2, and s3 does activities 3 and 4. of course, the original assignment of servers to activities is also feasible. what is the maximum capacity of the process (in customers per hour)? d. now consider the capacity measures in (c) and (a), what is the percentage change? why can you improve capacity without using additional resources? (there is no free lunch, right? )note: for all hw assignments, show your process of getting the results. only providing the final answers is not acceptable and will get 0%. if necessary, use a separate sheet of paper to show your work.