Exam (elaborations)
Harrow Fix it Evaluation (ACHIEVED DISTINCTION OVERALL)
- Course
- Institution
How I answered part of a mock exam for Unit 2.
[Show more]
Seller
Follow
Scrumlin
Reviews received
Content preview
Harrow Fix-ITStructure Evaluation (20 minutes)
Evaluate your database structure.
You should consider:
How well your database structure minimised data duplication
How well your database structure meets these requirements:
o There are three types of repairs: peripherals, software and hardware
o A record cannot be saved if the repair reported date is in the past
o The customer postcode will not save if it is in the incorrect format
Structure Evaluation
Database Minimising Data Duplication
My database minimises data duplication by using primary keys in the tables, this minimises data
duplication because with primary keys only one record can have a specific ID allocated to it and if
multiple records have the same ID, the duplicates will be deleted. An example of this being
present in my database is with the Customer ID if there are records with the same and it is set to
be the primary key, the duplicates will be deleted and it will only keep the records with unique
ID’s.
Database Meeting the requirements
Three types of repairs
My database only allows three types of repairs to be inputted into the Repair Type field, these are
Peripherals, Software and Hardware. This is achieved by using a lookup wizard
("Peripheral";"Software";"Hardware”) to create a drop down box that lets people choose from the
three options, if something other than these options are inputted then the database will not save.
When testing this in my database I had created the lookup wizard to allow options to be
displayed, so it had passed the test.
Report date being in the past
My database only accepts dates that are between the 27/09/2019 and the current date. This is
achieved by using a validation rule ( >=#27/09/2019# And <=Now() ) that specifies the dates it
should only allow and if a date is inputted that is out of the range of the two dates, it will not
allow the database to save which forces the person inputting the data to change it to a suitable
date. When testing this in my database I had not included a validation rule at first but once I had
tested for that and found it was not there, I added it in and now it works as it should.
Postcode being in the incorrect format
My database only allows postcodes have been inputted in the correct format. This is achieved by
using an input mask ( AA00\ 0AA ) that only allows characters to be inputted in that specific way, if
it is not typed in this format it will prevent the database from saving until the person has changed
it to follow the rules set in place. When testing this in my database I had not added in a format to
make sure it is correct but when I tested it and found it was not working, I implemented it in and
now it works.
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 or Stuvia-credit 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 Scrumlin. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $18.69. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
55628 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now