Essay
BTEC - LEVEL 3 - Unit 18- Database Design A1
Assignment 1 P7 M2 M3
[Show more]
Connected book
Book Title:
Author(s):
- Edition:
- ISBN:
- Edition:
Content preview
Testing TablesBlack Box Testing
Test description Test Results (Expected) Test Results (Actual) Fix
Do all Tables,Queries, I expect all of All opened without a No fix required.
Forms and Reports Tables,Queries, Forms and problem.
open. Reports to Open.
Does the order form I expect it to be able to All orders had a No fix required.
calculate the cost of calculate the cost of all calculate total.
the order. orders.
Does the order form I expect it to charge for All orders had a No fix required.
charge for delivery if delivery on orders which delivery charge
the total is less than require it. applied when
£8. required.
Does editing I expect the data to update The data was not I had to fix the
information on forms in the tables. updating. relationships between the
change the information tables in order for the
in tables. information to update.
White Box Testing
Item to improve Suggestion How Notes/URL for tutorial
The suspended It would be better if all I could produce a new table which https://
feature. people who were stores the suspended customer support.office.com/en-
suspended were placed in a information however not have that ie/article/create-a-
different table and were
unable to place orders. table linked to the order form so table-8fdc65f9-8d40-
that customers in that table 4ff5-9212-
cannot make any orders. 80e6545e8d87
Adding more It would be better if there By using a random number https://
orders. was a larger amount of generator I could quickly fill the www.random.org/
orders in the database to table with new orders using the
see how it would run if it
was used by an actual random number to get the
business. product id and quantity amount.
Adding more In a usual business I could add more fields to the staff https://
information database there would be table which show more support.office.com/en-
about staff. more information about staff information about the staff such gb/article/add-a-field-
that needs to be stored.
as address or how long they’ve to-a-table-c4b7c90c-
been working at the company. c842-47be-8e2b-
b85f3546f6b0
Payment At the moment there is no I could add another table for
Information way to track the payment payment information which links
method used such as them to the order form.
paying by cash or card.
Importing/Exporting Data
The below screenshots show me importing data from an excel document into my access
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller OllieJ10. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £3.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
66579 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now