Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CS 364 Final > Relational Database & ER Diagram > Flashcards

Relational Database & ER Diagram Flashcards

Intro, relational databases, and er diagrams

1
Q

Ubiquitous computing

A

computers/sensors that are everywhere

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

RDBMS

A

Relational Database Management System

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

SQL

A

Structured Query Language, a programming language for interfacing with a relational database

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

Schema

A

how data is represented

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

Internal Schema

A

comprised of logical and physical schemas

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

Conceptual schema

A

comprehensive design of our database (ex: ER diagrams, documentation, views)

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

External Schema

A

how data is viewed by end users

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

ER Diagram

A

Entity-relationship diagram, graphical notation for communicating the design of a database

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

Entity types

A

very similar to classes, represent with a box

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

Attributes

A

describe properties of an entity, represent with an oval

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

Set-valued attribute

A

contains > 1 value, multi-value, represent with double oval (ex: skills)

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

Composite attributes

A

attribute divided into smaller pieces, represent as a hierarchy of ovals (ex: date or name)

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

Optional attributes

A

optional fields, represent with an oval with an asterisk or italicized text

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

Derived attributes

A

not stored, but can be calculated, represent with a dashed oval

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

Keys

A

make an entity unique, represent with an underline

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

Composite key

A

two or more attributes needed for a unique entry

17
Q

Relationships

A

connect two tables together, can be 1:1, 1:many, or many:many, represent with a diamond

18
Q

Foreign key

A

primary key from another entity type, represent with a dotted underline

19
Q

Weak entity type

A

relies on the existence of other entities, represent with a double outline for both entity and relationship

20
Q

Tuple

A

row in a relational database, one entry

21
Q

Attribute

A

column in a relational database

CS 364 Final (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions