Databases

Question 1

Why would an Organisation use websites to Acquire data?

Answer 1

Cheap, Quick, 24 Hour Customer Access, Global

Question 2

Why would an Individual use websites to Supply data?

Answer 2

Convenience (easy to shop), Variety of Choice (global market>local) and Reduction of costs (travel costs are nifty)

Question 3

What are some various methods of acquisition offline?

Answer 3

Interview and Observation

Question 4

What are some various methods of acquisition online?

Answer 4

Forms, Surveys, ‘hit counters’, Email

Question 5

What is a User Flow Diagram

Answer 5

Visual representation of how a user can navigate a site to complete a task

Question 6

What is the importance of including shipping, returns and privacy statements on a website

Answer 6

Avoids confusion and helps with disputes

Question 7

What is the most efficient technique for validating a selection in a form?

Answer 7

Check Boxes

Question 8

What is the difference between a Flat-File Database and a Relational Database?

Answer 8

A Flat-File database only involves one table whereas a Relational database involves multiple tables

Question 9

Why is a Relational Database the preferred option over a Flat-File Database?

Answer 9

More complex, establishes 1 to many relationship

Question 10

Why are Naming Conventions important?

Answer 10

Naming Conventions are important because it allows users to quickly identify each component’s purpose

Question 11

What is the difference between CamelCasing and the Hungarian naming convention?

Answer 11

-No spaces, capital letter for each new word

H: Lower case 3 letter prefix, followed by single word

Question 12

What is a Field?

Answer 12

A Field is a single piece of data, an isolated fact.

Question 13

What is a Record?

Answer 13

group of related fields, connected by a primary key

Question 14

What are the 4 data types?

Answer 14

Text, Number (integer, date, currency, boolean), Image, Sound

Question 15

What’s the difference between a Primary Key and a Foreign Key?

Answer 15

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

Question 16

Why should an organisation implement a Form over a Table?

Answer 16

• more user-friendly experience
• easier to understand
• reduces confusion and chance of error

Question 17

What is a Query?

Answer 17

a Query is a process that sorts, filters and/or calculates existing data

Question 18

What are some functions for manipulating data?

Answer 18

• Search
• Sort
• Filter
• Calculated field

Question 19

Why are Reports designed?

Answer 19

Reports are designed for communication and printing and the finished product displays results of a query

Question 20

How can a website help boost business?

Answer 20

• Provides a global reach
• 24/7 service
• Quicker transactions
• Fewer staff (saves money)

Question 21

What is the most important thing to remember when normalising data in a relational data base?

Answer 21

There must be a Relationship

Question 22

What data type is a field which contains a year?

Answer 22

Integer (even though it cannot be calculated)

Question 23

What is the process of normalisation?

Answer 23

Normalization is a process of reducing redundancies of data in a database.

Question 24

What is referential integrity?

Answer 24

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