CSE 2102 - Databases

0.0(0)
studied byStudied by 0 people
0.0(0)
full-widthCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/8

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

9 Terms

1
New cards

Entity-Relationship Diagram

  • real-world object or concept (Job, User)

  • attributes of entity (name, email)

  • how entities interact or are associated with each other

2
New cards

Primary Key

unique identifier for each entity instance (UserID in User entity)

3
New cards

Foreign Key

field that links to a primary key in another entity to create relationships between tables (JobID in Application refers to Job.JobID)

4
New cards

ACID

  • DB model that ensures reliable, consistent transactions

  • used in SQL/relational databases

  • completely or not at all, rules and constraints, independence, committed transactions stay

5
New cards

BASE

  • DB model that is flexible, used when availability and scalability are prioritized

  • used in NoSQL/distributed databases

  • system always available, data can change and will become consistent eventually

6
New cards

SOAP

  • client-server, XML

  • rigid and complex (banking and insurance)

7
New cards

RPC

  • client calls or invokes server

  • large volume of messages back and forth

8
New cards

Web Socket

  • 2-way communication

  • large volume of messages back and forth (gaming, chat)

9
New cards

REST

  • Transferring representations of digital resources from a server to a client

  • More control over request/response, JSON