compare and contrast relational and flat file databases - correct answer
Similarity
Both use a primary key
Both can create searches/reports
Both store data in records and fields in the table Both use indexes
Differences
Flat file database is a plain text file
Flat file is a simple structure
Flat file uses one table Relational database has linked tables/relationships
Relational database allows searches/reports to be created over multiple
tables
Relational database allows cross referencing between tables Relational
database records are easier to add
Relational databases are more powerful
Relational database reduces duplicate data
Relational database uses foreign keys ;
Difference between attached stylesheets and inline style attributes - correct
answer Inline stylesheet is within the webpage
Attached stylesheets are edited in a separate file
The link to attached stylesheet doe sin the head
Attached stylesheets can be applied to multiple webpages
,Inline attributes can be used to overide the attached stylesheet;
Explain the term stylesheet when used in webpages - correct answer Used
to describe the presentation of a document in HTML
Enables the separation of presentation and content
Part of the Presentation Layer;
Advantages and disadvantages of Using a contactless card compared to a
chip and pin card - correct answer Adv:
Its not worn out easily
No shoulder surfing
Quicker transactions
disadv:
There's a limit to the money spent
If its stolen, due to lack of pin money is lost
if its lost, it can be used by anyone;
Advantages and disadvantages of touchscreen compared to a keyboard
and monitor - correct answer Adv:
Footprint will be smaller
Easy to select items
Computer will be more compact
Fewer Peripherals so it saves money
,Disadv:
Screen can become dirty
Screen can become damaged
Fat fingers can mis key data in touchscreen ( yes this was in the ms)
Keyboard and monitor can be easily upgraded
Three examples of uses of GPS - correct answer drone position
Tracking of stolen goods
Military
Ploughing fields
Surveying
How does GPS pinpoint location in smart phone? - correct answer The
location of the smartphone is calculated using GPS software
Signa is transmitted using a satellite
The signal is continuous
Data is saved by the smartphone
The coordinates of the smart phone appear on the screen
Differences between WWW and Internet - correct answer Internet is a
wide area network
WWW is a part of the internet
, WWW is a collection of web pages
WWW is accessed through the internet
disadvantages of using a search engine rather than typing the web address -
correct answer Irrelevant websites can show up.
If a website loads faster it has higher priority
some search engines do not include all webpages
Some websites pay search engines to display their webpage first.
When an e-mail is sent it could have an digital certificate attached.
Explain why it is required and what it contains - correct answer Digital
certificate adds a level of security., and verifies if e-mail is coming from a
trusted source. It is used for initializing SSL between web browser and
web server
A digital certificate contains the details of the owner of the certificate,
digital signature and expiry date and valid from date.
Describe the advantages to both the company and employees of working
patterns due to introduction of computers - correct answer Advantages for
staff: Staff are more flexible when they work
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 Schoolflix. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £11.37. You're not tied to anything after your purchase.