Bec Case Study
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. Again, review the DFDs you developed for the MyBroadway system (or those given to you by your instructor). Use these DFDs to identify the attributes of each of the six entities listed in this case plus any additional entities identified in your answer to Question 1. Write an unambiguous definition for each attribute. Then, redraw BEC, Figure 6-1 by placing the six (and additional) entities in this case on the diagram along with their associated attributes.
The updated ERD appears in the BEC ERD at the end of this section. Microsoft Visio was used to prepare the ERD.
The Comment entity has the attributes: * Comment ID – a number generated by the system to uniquely identify a comment. * Membership ID – the membership number of the customer who makes the comment. * Member Comment – the text that a customer states about a certain product. * Member Name – the name of the customer who makes the comment. * Comment Time Stamp – the date and time that the comment was entered into the system by a customer. * Parent/Child – a designation whether the customer entering the comment is a parent or a child. * Product ID – serves as a foreign key.
The Pick entity has the attributes: * Pick ID – a number
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. Again, review the DFDs you developed for the MyBroadway system (or those given to you by your instructor). Use these DFDs to identify the attributes of each of the six entities listed in this case plus any additional entities identified in your answer to Question 1. Write an unambiguous definition for each attribute. Then, redraw BEC, Figure 6-1 by placing the six (and additional) entities in this case on the diagram along with their associated attributes.
The updated ERD appears in the BEC ERD at the end of this section. Microsoft Visio was used to prepare the ERD.
The Comment entity has the attributes: * Comment ID – a number generated by the system to uniquely identify a comment. * Membership ID – the membership number of the customer who makes the comment. * Member Comment – the text that a customer states about a certain product. * Member Name – the name of the customer who makes the comment. * Comment Time Stamp – the date and time that the comment was entered into the system by a customer. * Parent/Child – a designation whether the customer entering the comment is a parent or a child. * Product ID – serves as a foreign key.
The Pick entity has the attributes: * Pick ID – a number