Database Design and Testing Assignment: Complete exercises 1-4. Exercises: 1. Recall the AVS scenario from previous assignments. Create an ER Diagram to represent the database design for this system. Include the entities, attributes, relationships, and cardinalities. Name a minimum of three attributes for each entity that you have identified. (20 points) 2. Examine the database entities shown in the figure below and then complete the following problem. (10 points) For each table pictured above, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. Use the following format to show your answers. TABLE PRIMARY KEY FOREIGN KEY(S) TRUCK TRUCK_NUM BASE_CODE TRUCK TRUCK_NUM TYPE_CODE BASE BASE_CODE NONE TYPE TYPE_CODE NONE 3. Quality assurance and testing occur throughout the software development lifecycle. Provide an example of a quality assurance or testing activity that occurs during each phase of the lifecycle. (For each phase, identify at least one QA or testing activity that occurs during that phase). (10 points) Planning: An example of a Quality Assurance activity during the Planning phase is “Coordinating Activities”. The Project Manager holds a weekly meeting of the entire team consisting of programmers and analysts working on a system to discuss any changes to the system that have arisen during the past week. Any issues that have come up are also discussed. These meetings keep the communication open and take a preventative approach to tackling issues before they occur. Analysis: One type of testing that occurs in the Analysis Phase is Unit Testing. This can be either a Black-Box or White-Box Test. This test ... ... middle of paper ... ...put Expected Output A customer chooses a video from the shelf and brings it to the checkout desk The customer has selected a video and goes to the checkout desk. The store clerk will start the checkout procedure. The store clerk/manager will ask the customer for their AVS card The customer will provide the store clerk with an AVS card. The store clerk will run the card through the system to check for overdue books and/or fines The system will notify the clerk of any holds if the customer has any overdue books or precious unpaid fines. Test Results: Date Pass/Fail Remarks 09/10/11 Fail The AVS card was rejected as the Customer had not paid his membership dues. 10/11/12 Fail The Credit Card on file of the customer has expired. Need a new form of payment on file. 11/12/13 Pass The customer has no unpaid dues or overdue books and is able to rent a video.
Some of the testing at the unit level would be White Box testing. Making sure that different parts of processes or objects were executing properly during state transitions. It would look at the accuracy of logical operations for financial transactions and functions such as keeping double booking of appointment times from occurring.
Since 1999 the growth of spending on DVD purchases and rentals has been incredible. According to Alexander & Associates, “Rapidly growing consumer activity and spending has built this industry into a major market phenomenon. The DVD format for enjoying pre-recorded entertainment at home is extraordinarily popular and consumers are changing their behavior to accommodate it.”
Quality Planning – As a first step to developing the QP, we will undertake quality planning. Quality planning will have as its objectives the identification of quality specifications and of how to meet these specifications. To accomplish these objectives, we will analyze inputs from which to derive a quality baseline and then produce artifacts that will support the execution of the QP. We will undertake quality planning immediately after award, in concurrence with other project planning activities. Quality planning activities and milestones will be incorporated into the overall project management plan.
As advance technology of fiber-optic developed and is on the rise, everyday there is another story about entertaining movies on demand and streaming online is with ease. Those developments which let movie’s viewers sit in the comfort of their home or anywhere with access to the internet can stream instance movies with a push of a bottom. They no longer need to make a trip to the movie’s stores for movies rental and return, so that is why movie shops fail and filed for bankruptcy bring a symbolic close to the “let’s go rent a movie” era. Blockbuster LLC, formerly Blockbuster Entertainment Inc., both owned and franchised American-based giant provider of home movie and video game rental services through video rental stores, later adding movies by mail, streaming online and video on demand. Due to the peak of fiber-optic and competition from companies such as Netflix, Redbox, and GameFly, Blockbuster became the victim of digital media and filed for bankruptcy on September 23, 2010 due to significant lost in revenue.[3]
...o identify any problems in the Quality management system and make suggestions of any actions that need to be taken to improve the laboratory system.
In this paper I have analyzed the past and present condition of Blockbuster. Given the right circumstances and execution, Blockbuster can once again return to the video rental powerhouse status they enjoyed throughout the 1990s.
and get the card in your name with no intention of making payments. Credit card
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
Before diving into the pros and cons of the Internet in relation to the film industry, one should understand a brief evolution of movie distribution in history. Before the convenience of being able to watch movies in our homes, films were shown at movie palaces. These palaces were “full-time single screen movie theaters that provided a more hospitable movie going environment” (Campbell, Fabos & Martin, p. 247). The first movie palace opened in 1914 and following that, mid-city movie theaters became popular. These theaters were “built in convenient locations near urban mass transit stations to attract business of the urban and suburban middle class” (Campbell et al., p. 247). As technology advanced, the videocassette appeared in the 1970s. This invention decreased movie theater ticket sales, as people were now able to rent movies and watch them in the comfort of their own homes. However, technology continued to progress and eventually, the film industry converged with the Internet. With this ...
Blockbuster had developed a successful business model leveraging on its competitive advantage in distribution channels. Blockbuster was able to quickly and efficiently (at least initially) ship videos from one location to another taking advantage of the shifts in customer demand from one location to another. Blockbuster also has the significant advantage of its customer base. This allowed them to negotiate with the media giants to reduce the individual cost of the videos is procured, by now Blockbuster was the largest single purchaser of home video tapes. Under Huizinga Blockbuster was able to quickly identify and obtain the best locations in each geographic area into which they intended to expand. He would do this until the location was saturated. He would then move to another geographic location further stifling potential competition. Using his experience with waste management, Huizinga made a number of acquisitions. He made these acquisitions especially when entering new markets. Leveraging on earlier successes with its superstore’s physical appeal, block buster formed alliances with Domino’s Pizza, Mc Donald, PepsiCo etc to attract customers and build her brand recognition. Blockbuster effectively utilized her advantage in IT and constantly upgraded to ensure customers had the most convenient and stress free experience possible with the added advantage of creating greater efficiency in her distribution channels as the Point of sale systems were linked to an inventory system that allowed better management of her distribution operations.
GM uses this system by containment, disposition, separation, and classification. Such a system guarantees that any outcome that does not comply with specified requirements is restricted from unintended use, restrained, and dispositioned by the administrators. Accompanied by this quality control is the verifying position where first-time quality and process capacity is advanced (Drew, 2011). Every team member is informed about any modifications in the production process and who and when to summon for assistance in the event of any quandary. Every team is also included in the problem solving to reach any improvement in goals.
Delivering a quality product is not solely down to how good the developer is, even though that helps, it is down to the quality of the original analysis and understanding of the requirement. Software testing is carried out to provide developers with a report on the quality of the program or application under testing. It allows the business to get an objective and informative view of how the product works. The purpose of testing is to resolve as many issues as possible before it is released. Each of the following testing principles help play a part but collectively they look to provide a working solution.
Software development follows a specific life cycle that starts with designing a solution to a problem and implementing it. Software testing is part of this software life cycle that involves verifying if each unit implemented meets the specifications of the design. Even with careful testing of hundreds or thousands of variables and code statements, users of software find bugs. “Software testing is arguably the least understood part of the development process” and is also a “time-consuming process that requires technical sophistication and proper planning” (Whittaker 71) It is important to comprehend this concept by understanding the different characteristics and aspects of software testing, and then to examine the techniques, procedures and tools used to apply this concept. This will enable the user to realize the problems faced by software testers and the importance of software testing.
The database application design can be improved in a number of ways as described below:
Product designing, in this stage for continuous quality improvement the parameters of the design gets changed and the level of tolerance gets altered. This is very difficult for the manufacturing companies in implementation stage.