Databases Flashcards
Why would an Organisation use websites to Acquire data?
Cheap, Quick, 24 Hour Customer Access, Global
Why would an Individual use websites to Supply data?
Convenience (easy to shop), Variety of Choice (global market>local) and Reduction of costs (travel costs are nifty)
What are some various methods of acquisition offline?
Interview and Observation
What are some various methods of acquisition online?
Forms, Surveys, ‘hit counters’, Email
What is a User Flow Diagram
Visual representation of how a user can navigate a site to complete a task
What is the importance of including shipping, returns and privacy statements on a website
Avoids confusion and helps with disputes
What is the most efficient technique for validating a selection in a form?
Check Boxes
What is the difference between a Flat-File Database and a Relational Database?
A Flat-File database only involves one table whereas a Relational database involves multiple tables
Why is a Relational Database the preferred option over a Flat-File Database?
More complex, establishes 1 to many relationship
Why are Naming Conventions important?
Naming Conventions are important because it allows users to quickly identify each component’s purpose
What is the difference between CamelCasing and the Hungarian naming convention?
-No spaces, capital letter for each new word
H: Lower case 3 letter prefix, followed by single word
What is a Field?
A Field is a single piece of data, an isolated fact.
What is a Record?
group of related fields, connected by a primary key
What are the 4 data types?
Text, Number (integer, date, currency, boolean), Image, Sound
What’s the difference between a Primary Key and a Foreign Key?
A Primary Key is a unique identifier for each record whereas a Foreign Key is a field in a table which connects to a primary key in another table
Why should an organisation implement a Form over a Table?
- more user-friendly experience
- easier to understand
- reduces confusion and chance of error
What is a Query?
a Query is a process that sorts, filters and/or calculates existing data
What are some functions for manipulating data?
- Search
- Sort
- Filter
- Calculated field
Why are Reports designed?
Reports are designed for communication and printing and the finished product displays results of a query
How can a website help boost business?
- Provides a global reach
- 24/7 service
- Quicker transactions
- Fewer staff (saves money)
What is the most important thing to remember when normalising data in a relational data base?
There must be a Relationship
What data type is a field which contains a year?
Integer (even though it cannot be calculated)
What is the process of normalisation?
Normalization is a process of reducing redundancies of data in a database.
What is referential integrity?
A concept that explains that table relationships must always be consistent. In other words any primary key field changes must be applied to all foreign keys, or not at all
