make an E/R design for described database:
Bob Bee is an artist who has chosen to make his living designing and printing shirts and jerseys for various clubs and events. He named the company after himself and his favorite color. Although he has been in business only a couple of years, it has been successful. Several local clubs sponsor several events each year and want commemorative apparel that they either give to everyone who registers for the event or sell as a separate item. Either way, Bob makes money because he is paid for the work regardless of the number of items that actually sell. Artwork
Sometimes customers have only a vague idea of the artwork needed. Other times, they come with computer-printed designs. In most cases, an artist still has to clean up the artwork so that it will display reasonably well on the desired item. Ultimately, the art must be color-separated so that each color has its own film. The individual films are assigned to a single print color on the press, and the colors are placed in layers on the final object. Registration, or matching the color separations so the colors do not overlap and the separate layers align perfectly, is a key element in creating a professional product. As shown in Figure 1, an individual item, such as a shirt, could have art in several locations (front, back, sleeve, and so on). Each location requires a separate pass through the print process. Each color requires a separate film and a separate imprint. Although the newer print systems automatically rotate an object through several colors, each print station requires a separate setup, so customers are charged by the number of artwork elements and the number of colors. The total price of the artwork generally includes a setup fee as well as the per item charges. Some organizations are given discounts, but these are somewhat arbitrary and determined by Bob. Most customers create t-shirts associated with some event, such as a festival, race, or bike ride. The artists work the event’s theme into the designs.
Once in a while customers just place orders for the artwork, but generally, they really want the art imprinted onto some item—usually a t-shirt. Figure 3 shows the main print order form. This form is also used to guide the overall project timeframe, so several dates are added to it as the order progresses through the system. The first major step is to select the apparel item. The company keeps samples of common items and colors on hand to help the customer visualize the final product. Many other items can colors can be ordered from a selection of vendors. The price of the item is an important consideration in the selection, and vendors have different prices based on fabric and size. Basic sizes are listed at a standard price, but the larger sizes carry an additional charge. The customer has to estimate the number of items desired at each size. Per unit prices also depend on the quantity ordered—with typical breakpoints of 100, 500, and 1000 unit orders. The other interesting twist is that most vendors charge higher prices for darker-colored items. The actual costs and the price Bob charges fluctuate, so they are determined by the clerks at the time of the sale. This form also contains the pricing breakdown for printing the individual artwork. The price is determined by the number of imprints and the number of colors. It is critical for clerks to enter all of the exact colors on the form. At the end of the month, Bob develops a report that displays a cost analysis for each recent project. He uses the information to help set prices and to identify which jobs are the most profitable. Figure 4 shows the basic arrangement of the report. Bob usually looks at the net profit data first followed by the subtotal breakdown. He only looks through the detail material and labor costs in cases that seem unusual. Note that all items used in the production of a particular item are listed—including the apparel, film sets, and ink. The labor costs are summarized by task. Even though an employee might have worked on the artwork three different times over four days, there will be one entry for the artwork development. One of the important steps in this case is identifying a standard list of tasks—because employees tend to invent strange names every month, and it is difficult to put the data together to create this report.
İşin Yapılacağı Konum: ONLINE
Görevin Başlangıç Tarihi: 14-06-2020
Görevin Bitiş Tarihi: 15-06-2020