Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

sql

memorize.ai (lvl 286)

(0)

17 cards

()

Section 1

Preview this deck

types of data models

Front

1 / 17

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (17)

Section 1

(17 cards)

types of data models

Front

Analysis - architect engineer - design (tell how)

Back

partial specialization

Front

an entity instance of the supertype does not have to belong to any subtype single line

Back

Weak entity

Front

an entity whose existence depends on the existence of some other entity

Back

total specialization

Front

all entities under the supertype are already accounted for double line

Back

solid relationship for

Front

identifying relationship

Back

subtype

Front

an entity whose instances may inherit common attributes from its entity supertype physican nurse pharamicst

Back

overlap

Front

an entity instance can simultaneoulsy be a member of two or more subtypes be nurse and pharmacist written as O

Back

supertype

Front

an entity whose instances store attribues that are common to one or more entity subtypes caregiver

Back

cardinality

Front

how many students? how many classes?

Back

Modality

Front

must a class have students must a student enroll in classes

Back

non identifying realtionship

Front

strong to strong

Back

attribute

Front

a field in a realtionship

Back

how do we represent a relationship on an ERD

Front

a line

Back

disjoint

Front

if an entity instance of the supertype is a member of one subtype it cannot be a member of another subtype only nurse or pharmacist Written as D

Back

identifying relationship

Front

strong to weak

Back

completeness

Front

there are no securities other than stocks and bonds

Back

strong entity

Front

an entity type whose existence does not depend on the existence of some other entity

Back