Question

Office supply store: South of Fifth Copy Boutique is a small office supplies/office services store that sells stationery and mailing supplies, such as envelopes, paper boxes, pens, tape, etc. It also has a two printers, a scanner, and two copy machines that customers can use on a first-come first-serve basis, or reserve them in advance in 15 minute blocks of time. The owner is also a general manager and runs the operations, and employs one part-time worker who is usually a first-semester student of graphics design. The student is often asked to help clients with designing business cards and party invitations, so the owner has included consulting services as one of the offerings of the business. Clients can also drop off their materials and the office will make copies or scans for them as an additional service. The information system should track the performance of the business, and also be able to track the working hours of the student helper. - Entity-Relationship Diagram Entities, attributes o Primary keys, foreign keys Relationships, cardinality, mandatory/optional

Answer 1

Entity relation ship diagram The entities here are owner part time employee customers The shop i.e sooth of fifth copy boutique attributes are 2.printers 1 scanner 2 copy machines Relationships are owner to part time worker owner to shop owner to customer customer to part time worker customer to equipment implies The primary keys here is the service being provided by the owner and the part time worker to cally out the requirement that come to the shop