introduction Flashcards

1
Q

what is data

A

anything that can be represented in binary

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

what is data engineering

A

designing and building systems so data can ve collected managed and analysed

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

what is a database

A

structured systems for storing retrieving and managing data

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

what is raw data

A

data kept in an excel file

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

data model

A

defines how data will be related and stored

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

what are some negatives of file processing applications

A

would have to hire a developer as they were hard to implement which is expensive
issues with optimisation performance reliability and reuse

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

what is a file processing application

A

a set of files that are processed to retrieve information

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

logical model

A

allows a logical representation which aids processing which can be represented graphically via an entity relationship diagram

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

dbms

A

database management system; uses the logical model to control the database and provides efficient reliable multi-user storage and access to large amounts of persistent data

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

what is the difference between source code, a program, and software

A

source code; code written by developers that isn’t directly executable
program; what you get when the source code is executed
software; the entire collection of programs, libraries and related data

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

ddl (data definition language)

A

creates tables

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

dml (data manipulation language)

A

modifies tables

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

what is an entity and how is it represented in an er diagram

A

an object with distinguishable attributes
rectangle

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

entity set

A

a representation of entities with the same set of attributes

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

what is an attribute and how is it represented in an er diagram

A

information that describes an aspect of an entity
oval

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

primary key

A

unique identifier for an entitiy

17
Q

what is a derived attribute and how is it represented in an er diagram

A

an imaginary attribute not stored in the database but derived using system recourses
dashed/broken oval

18
Q

what are multi-valued attributes and how are they represented in an er model

A

attributes with more than one value
double oval

19
Q

composite attributes

A

an imaginary group of attributes not in the table that groups together existing attributes

20
Q

relation

A

a logical model for associating 2 or more entities

21
Q

what is a relationship set and how is it represented in an er model

A

a set of all relationship that can have attributes and a primary key
diamond

22
Q

degree of relationship set

A

number of different entity sets in the relationship

23
Q

one to one relationship

A

created whilst creating the table and can lead to new tables

24
Q

total participation (must)

A

for every entity in an entity set, it must relate to at least another entity in the other set

25
Q

partial participation (may)

A

not all entities have to map to another entity in the other set

26
Q

what is combined to create the subject table key

A

owner table primary key + subject table weak key

27
Q

overlap constraints

A

restrictions on the relationship between different entities, ensuring that they don’t simultaneously occupy conflicting roles

28
Q

covering constraints

A

ensures that everything is correctly classified within the appropriate categories and leaving no gaps in the er model

29
Q

what are the 2 reasons that we use ISA

A

identifies entities that participate in relationships
adds descriptive attributes to a specific subclass