System Analysis and Design - Data Design

Flashcards covering key concepts from the System Analysis and Design lecture on Data Design, including ERD, database terminology, relationships, and data types.

Entity Relationship Diagram (ERD)

A blueprint that makes sure a streaming service actually works, including elements like UserAccount, Profile, WatchHistory, and Movie/TV_Show.

Data Management Design

Includes Data access and manipulation logic and Storage design.

Relational Databases (RDBs)

Focus on Relationships based on key match.

Table/Entity/Relation

Database Terminology: Structure that holds data in rows and columns.

Attribute/Field/Column

Database Terminology: A characteristic or property of an entity.

Row/Record/Tuple

Database Terminology: A single instance of an entity.

Primary Key

The attribute that is selected to uniquely define each row in a database table.

Foreign Key (FK)

An attribute in one table that refers to the Primary Key (PK) of another table, used for key-matching.

Multiplicities

Represent relationships between entities, such as zero or one, one or many, or zero or many.

CHAR

A fixed-length text data type.

VARCHAR

A variable-length text data type.

INT

An integer data type.

FLOAT

A floating-point number data type.

BIT/BOOLEAN

A yes/no data type.

DATETIME

A date and time data type.

Class Diagram

Shows data values in the class and Actions or functions that a class can perform

One-to-many Association

Insert an ID of the one-side table into the many-side table.