DB 4 - Design Considerations for Visual Interfaces and Navigation Systems within Database Systems  Flashcards

1
Q

What is a view mechanism?

A

Provides users with only the data they want or need to see

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

SELECT *
What does * mean?

A

Everything

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What is the purpose of interface?

A

For frontend users to interact with the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Why is interface important?

A

Because they perform just like views, but with standardized design and constraints
EX: Forms

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What are the 4 important concerns when designing an interface?

A

Readability
Navigation
Logical order
Inclusivity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What is readability?

A

Refers to the ease of a user to understand how to navigate through the interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

what happens if we have poor interface readability?

A

Technical issues such as data entry errors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

How to improve readability of an interface?List 3 ways

A

Use words in the interface that people can understand
Avoid using technical languages
Avoid long-winded explanation

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is navigation?

A

The ability for users to properly navigate the system through interface

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

How to improve navigation? List 3 ways

A
  • Ensure the process is logical and easy to follow
  • Navigation menu is named appropriately
  • Provide more than 1 navigation paths
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is inclusivity?

A

Refers to the accessibility of the interface to a broader audience

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

How would an inclusive interface be like?

A
  • User-friendly regardless of culture and language
  • Catered to maximum use by people
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

How does the users navigate a database system?

A

Through views OR interfaces

How well did you know this?
1
Not at all
2
3
4
5
Perfectly