Block 4 - lecture 2

Question 1

What gives data meaning?

Answer 1

context

Question 2

What is data once it has context?

Answer 2

information

Question 3

3 roles of a database?

Answer 3

• record
• access
• protect

Question 4

entity relationship database model?

Answer 4

very common in databases,
records (entities) are linked to others with a relationship
eg. allocating pay record to employee

Question 5

ER database model?

Answer 5

entity relationship

Question 6

types of relationship?

Answer 6

• 1 to 1
• 1 to many
• many to many
• mandatory
• optional

Question 7

symbols for relationships?

Answer 7

to many = triangle and line

to one = double line

Question 8

examples of local, departmental information systems in engineering?

Answer 8

• MS Access databases
• MS excel spreadsheets
• local shared folders

Question 9

examples of company-wide information systems in engineering?

Answer 9

-PLM (product lifecycle management systems)

Question 10

UML?

Answer 10

unified modeling language

Question 11

unified modeling language?

Answer 11

a group of 13 types of standardised diagrams to describe systems

Question 12

use case diagrams?

Answer 12

describe how ‘actors’ interact with the system

eg. waiter, chef and customer in a restaurant

Question 13

relationships in use case diagram?

Answer 13

an optional, specialised function within a higher level one

eg. ‘serve wine’ extends ‘serve food’

Question 14

relationships in use case diagram?

Answer 14

functions always within another higher level function

eg. ‘read menu’ in ‘order food’

Question 15

class diagram?

Answer 15

describes the structure,
each class has properties for everything inside it

Question 16

types of relationships in a class diagram?

Answer 16

mandatory - black diamond
optional - empty diamond
subclass - triangle
none or 1 - 0..1
1 or more - 1..*

Question 17

sequence diagram?

Answer 17

show the order of interactions

Question 18

2 groups of UML?

Answer 18

• static diagrams

- behavioural diagrams

Question 19

name of a collection of models?

Answer 19

a view

Question 20

strengths of UML?

Answer 20

• each diagram is only relevant information
• you can control the level of detail
• mistakes are exposed when different diagrams are drawn
• only relevant diagrams are required

Question 21

Actor in a use case diagram?

Answer 21

might be:

• a person
• another system
• a device

Question 22

what doesn’t a use case diagram show?

Answer 22

• how tasks are done
• the order of tasks
• time tasks take
• actions not involving the system
• non-functional requirements

Question 23

use case description?

Answer 23

used to supplement the diagram

Question 24

how are each object’s lifeline ended?

Answer 24

with a cross at the bottom end of the line

Question 25

how to identify non-human actors?

Answer 25

• they initiate contact with the system

- they get a benefit from the system