Bec Case Study

Only available on StudyMode
  • Download(s) : 327
  • Published : January 19, 2013
Open Document
Text Preview
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 generated by the system to uniquely identify an employee pick. * Employee Comment – the text that an employee states about a certain product. * Rating – a structured rating given to a certain product by an employee. * Employee ID – the ID number of the employee who submitted the pick. * Employee Name – the name of the employee who entered the pick into the system. * Pick Time Stamp – the date and time that the employee entered the pick into the system. * Product ID – serves as a foreign key.

The Product entity has the attributes:
* Product ID – a number generated by the system to uniquely identify a product offered for sale or rent by BEC. * Title – the title of the product.
* Artist – the name of the artist of the product (if applicable). * Type – an indication if the product is music, a game, or a movie. * Publisher – the name of the publisher of the product. * Category – the category that the product falls under (comedy, drama, etc.). * Media – the type of media that the product is on (CD, DVD, etc.). * Description – a description of the product.

* Release Date – the date that the product was released. * Sale Price – the sales price of the product.
* Rental Price – the rental price of the product.
The Request entity has the attributes:
* Request ID – a number generated by the system to uniquely identify requests made by customers. * Request Time Stamp – the date and time that the request was made by a customer. * Membership ID – the membership ID number of the customer who made the request. * Member Name – the name of the customer who made the request. * Artist – the name of the artist (if applicable) of the product being requested. * Title – the title of the product being requested.

* Type – an indication if the requested product is music, a game, or a movie. * Media – the type of media the customer would like the product on. * Product ID – serves as a...
tracking img