Database Design And Testing Essay

814 words - 4 pages

MIS 4330 – Assignment 6 and Assignment 7: Database Design and Testing
Assignment: Complete exercises 1-4.
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 ...view middle of the document...

To check an order quantity that must be 10-100, the tester would use a valid value (20); a lower value (5); a higher value (101); and non-numerical characters (ABC).
A System Test can be performed in the Design Phase to test the Interface Design by doing Usability Testing.
By allowing users to use the system under specific instructions, and recording their reactions and frustrations, the designers get an idea of the ease of use of the system. If a user got confused or frustrated accomplishing a task, it is a flag to do some re-designing.
One of the most common types of tests used in the Implementation phase is Acceptance Testing. Alpha and Beta Tests are conducted to see if the business needs that the system was developed for are met or not.
Alpha testing uses made up data while beta testing will use real data but are monitored for errors. 
4. Consider the Use Case Diagram, Use Case Description, and Sequence diagram you created for the AVS scenario. Write a test case to test the rent video functionality in the system. I have provided a sample test case template that you may use. (20 points)
Purpose: This test case tests the Video rental functionality. It will test how videos are rented out of the store.
Prereq: Some Assumptions are; “User exists”, “Video is in stock”.

Find Another Essay On Database Design and Testing

Database Administrators Essay

1268 words - 5 pages database within the parameters established by the database designer. Database administrators also keep current with trends in database design and are often the first to suggest when new technologies appear that can benefit the organization through improved efficiency and performance (Krol 33). WHY COMPANIES NEED DATABASE ADMINISTRATORS Companies need database administrators because the needs of database users are constantly changing, as is the

Bead Bar Network Design Essay

3408 words - 14 pages . Their interests also include a strong database to store information from sales and inventory to personnel information. Proper infrastructure design and implementation is imperative to meet all the Bead Bar’s requirements. The steps listed below are recommended in order to meet the needs of the Bead Bar

Bead Bar Systems Development Plan

1739 words - 7 pages customers to use. Diagram 2 provides a detailed picture of the design and layout of the Bead Bar’s client-server network. [pic] Diagram 2 Client-Server Network Architecture The database management system (DBMS) being used is a relational type database like the one illustrated in diagram 3 and will make use of Microsoft SQL as the database software. The DBMS will be accessed and used by the various Bead Bar departments and the e-commerce

role of database administrator

1611 words - 7 pages modifications to the database, they rarely work together with companies on a day-to-day basis. Companies need database administrators because technology is constantly changing to be better. The needs of database users are constantly changing. The company database administrator can hire database designers to come into an organization and design a database suitable for the organization. However, these designers are not required for everyday. Many

Elements of a Fulfilling and Successful DBA

901 words - 4 pages design and development, networking and systems administration, software implementation analysis, testing and QA are some examples of recession-proof IT positions that are still dominating. In spite of a volatile economy and automation; longevity is assured in the IT field and specifically as a Database Administrator. There are many important skills a database administrator must demonstrate and many go beyond technical expertise. Candidates for these

Implementation System Development Lifecycle

1184 words - 5 pages user documentation to help users in using the system. There are several sub activities involved during coding activity. The sub activities involve system analysts, programmers, system designers and database administrators. Such activities are planned simultaneously with other activities; network building and testing, database building and testing, install and test new software, write and test new programs. After the coding process, programmers

Kudler Coupons Project Report

1313 words - 5 pages , the Kudler support team will set up the development and test environments, to include a copy of the customer database for use in testing.Develop Coupons System: 6 days, $2,387.60The designs from the design phase will be developed here, including the development of the code for the various functionalities required to enact the coupon system: the code for the DB module and unit testing, the code for input UI module and unit testing, the code for

Database Management Systems

665 words - 3 pages reporting requirements, the conversion to SQL is essential to the generation of reports fulfilling each governmental agency's requirements.Maintenance and Precautionary MeasuresDue to the tremendous importance of our data, we take measures to safeguard the data, database management systems and, databases themselves. As mentioned previously we do not apply any software without testing it first. We also take other steps to ensure the integrity of the data

Riordan Manufacturing Business-To-Business Database System

5480 words - 22 pages AbstractRiordan Manufacturing is seeking a database system to facilitate web-based communication between employees and vendors to increase the efficiency of the materials purchasing process. Preliminary design estimates indicate that the application will include functions for current inventory management, automated and manual ordering, and order status tracking. The users of the database and website will include specified vendors, purchasing

Skills and Certification Design and Implementation Project

1992 words - 8 pages Specialist IT Director Implementation of schema design into database platform.QA Engineer Project Manager Responsible for Quality Assurance testing and reporting on all developed applications.Application Developer (AD) needs to develop web based tools and db interaction layers for a pop music site. The developer will receive functional and occasionally technical requirements and will implement processes designed to meet these requirements. The

B&E project

4756 words - 19 pages need to be tested for checking if they were working correctly as expected. The functions that need to check for this system are entering, deleting, adding, editing and searching the data records from database. The testing results should show all the wrong data to correct, wrong format display on the system and unexpected value from the system.2. Design Requirements - the design testing should check out the user interface, web page navigation

Similar Essays

Design & Engineering, Fabrication, Inspection, Testing And Supply Of Radar Level Transmitter As Per Cb&I Enquiry Document No: Ce 010 3304 Subsequent C

1050 words - 4 pages Sub: Design & Engineering, Fabrication, Inspection, Testing and Supply of Radar Level Transmitter as per CB&I Enquiry Document no: CE-010-3304 subsequent correspondence. Ref : Annexure-E for List of Correspondence. Dear Sir, With reference to the above Inquiry from our EPCM Contractor M/s.CB&I Lummus Crest Mauritius hereinafter called “EPCM CONTRACTOR”, we Nagarjuna Oil Corporation Limited, hereinafter called as “OWNER”, are pleased to

Database Performance Tuning Essay

1155 words - 5 pages causes of slow database performance, 2014). 2. Poor Database Application Design: A poor database design can lead to severe performance issues. An application which uses large tables (e.g. table with 100000 rows and 100 columns), ill-formed and un-optimized queries, improper use of database connections and so on. The database application design can be improved in a number of ways as described below: a. Normalize Database Design: The application

Huffman Trucking Company: Database Management System Request For Proposal: Description Of Team Red Consulting, Inc

1005 words - 4 pages - Analysis Phase- Design Phase- Development Phase- Implementation Phase- Testing Phase- Maintenance Phase- Refer to following Gantt chart.Expected Results.The expected results are the creation of UML Use Case and Class Diagram for maintenance scheduling system. Secondly, the creation of a database management system using MS Access database application that implements the scheduling scope of the database schema for Huffman's vehicle maintenance

The Changing Role Of The Database Administrator

1145 words - 5 pages March 1996Technology Changes Roll of Database AdministratorThe database administrator (DBA) is responsible for managing and coordinating all database activities. The DBA's job description includes database design, user coordination, backup, recovery, overall performance, and database security. The database administrator plays a crucial role in managing data for the employer. In the past the DBA job has required sharp technical skills along with