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
8. Yes, this record includes a session ID. The purpose of the session ID is to provide the SSL session a unique identifier.
This entity stores information about a payment that correlates directly from a client to a package being delivered.
2. using the data requirements and the business rules provided, develop a conceptual model (ERD), including attribute data types and required field lengths; and
In Section A, please answer the questions with as much detail as possible. Please provide specific examples and share any additional information you may have.
Use these DFDs to identify the attributes of each of the six entities listed in this case, using Figure PE Figure 7-1; I have also placed the Visio diagram in doc sharing, Project Workbook - Week 4).
Auto number can be used to provide a value which is unique and serves no other purpose than to make a record
A. Lab # : BSBA BIS245A-1 B. Lab 1 of 7 : Introduction to MS Visio and MS Access C. Lab Overview--Scenario/Summary TCOs: 1. Given a business situation in which managers require information from a database, determine, analyze and classify that information so that reports can be designed to meet the requirements. 2. Given a situation containing entities, business rules, and data requirements, create the conceptual model of the database using a database modeling tool. Scenario: You have been asked to create two conceptual database models using MS Visio Database Model Diagram Template. The purpose of this lab is to have you gain familiarity with the various modeling tools needed to create a conceptual model (entity relationship diagram) of a
"email" or "e-mail", but your suggested attributes are shown in this feedback. Databases like this one should be
The id is the part of someone that seeks pleasure selfishly. The id is destructive and demanding. When it’s hungry it wants to eat, when it’s tired it wants to sleep. Calvin’s id wants to throw the snowball, which is causing damage, ad he states that “Throwing these snowballs would give me immediate and certain pleasure.”. At the same time, he wants presents on Christmas, saying “Refraining from throwing these snowballs in the hope of being
Entities: Entities are objects that are located in a data base. Entities allow you to store data objects in the systems data base. These are set out in a table form in the data base. Primary keys, foreign keys, referential integrity and data redundancy are all part of entities.
2.) Answer the following questions based on a reading of the above document and material from your textbook.
needs of identity. The id is driven by the delight standard, which takes a stab at quick satisfaction of all,