preview

Bec Case Study Essay

Decent Essays

Broadway Entertainment Co., Inc. Case Question Solutions 1. Review the data flow diagrams you developed for questions in the BEC case at the end of Chapter 5 (or diagrams given to you by your instructor.) Study the data flows and data stores on these diagrams and decide if you agree with the team’s conclusion that there are only the six entity types listed in this case and in BEC Figure 6-1. If you disagree, define additional entity types, explain why they are necessary, and modify BEC Figure 6-1. The six entity types in BEC Figure 1 are the only ones needed to represent the MyBroadway system. However, depending on what data about Customers and Employees are required, entities for these objects may also be required. 2. …show more content…

* Membership ID – the membership ID number of the customer who rented the product. * Member Name – the name of the person who rented the product, which may be different than the cardholder’s name (child, spouse, etc.). * Rental Time Stamp – the date that a customer rented the product involved in this rental. * Due Date – the date that the rented product is due back. This may be changed with a rental extension request. * Returned? – an indication if the rented item was returned or not. * Product ID – serves as a foreign key. The Sale entity has the attributes: * Sale ID – a number generated by the system to uniquely identify a sale of a specific product to a customer. * Membership ID – the membership ID number of the customer who purchased the product. * Member Name – the name of the person who purchased the product, which may be different than the cardholder’s name (child, spouse, etc.) * Sale Time Stamp – the date and time that the product was purchased by the customer. * Product ID – serves as a foreign key. 3. Using your answer to Question 2, designate which attribute or attributes form the identifier for each entity type. Explain why you chose each identifier. Comment ID and Pick ID are the identifiers of the entities Comment and Pick, respectively, because it would be much simpler to use a number than a long

Get Access