data bits models classes & schemes rows & tables keys associations $100 $200 $300 $400 $500...
TRANSCRIPT
![Page 1: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/1.jpg)
![Page 2: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/2.jpg)
Data BitsModels
Classes & Schemes
Rows & Tables Keys
Associations
$100
$200
$300
$400
$500
$100 $100 $100 $100
$200 $200 $200 $200
$300 $300 $300 $300
$400 $400 $400 $400
$500 $500 $500 $500
Final DataBit
![Page 3: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/3.jpg)
$100 Answer from Models
This modeling language was developed for software engineering of large
systems using object-oriented programming languages. We use it for
modeling the enterprise.
![Page 4: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/4.jpg)
$100 Question from Models
What is the Unified Modeling Language (UML)?
![Page 5: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/5.jpg)
$200 Answer from Models
This model is similar to UML, but is used primarily in database
development rather than software engineering.
![Page 6: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/6.jpg)
$200 Question from Models
What is the Entity-Relationship (ER) model?
![Page 7: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/7.jpg)
$300 Answer from Models
CATEGORY 1 - $300
This is the formal mathematical model of a relational database.
![Page 8: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/8.jpg)
$300 Question from Models
What is the Relational Model?
![Page 9: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/9.jpg)
$400 Answer from Models
This formal language is used to symbolically manipulate objects of the
relational model.
![Page 10: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/10.jpg)
$400 Question from Models
What is Relational Algebra?
![Page 11: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/11.jpg)
$500 Answer from Models
This is the informal set of terms for relational model objects, used most
often in database work.
![Page 12: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/12.jpg)
$500 Question from Models
What is the table model?
![Page 13: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/13.jpg)
$100 Answer from Classes & Schemes
This is any "thing" in the enterprise that is to be represented in the database by a UML model. (It is called an entity in
the ER model.)
![Page 14: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/14.jpg)
$100 Question from Classes & Schemes
What is a UML class?
![Page 15: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/15.jpg)
$200 Answer from Classes & Schemes
This is any "thing" in the enterprise that is to be represented in the database by
an ER model. (It is called a class in UML.)
![Page 16: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/16.jpg)
$200 Question from Classes & Schemes
What is an ER model entity?
![Page 17: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/17.jpg)
$300 Answer from Classes & Schemes
This is one piece of information that characterizes each member of a class
or entity type.
![Page 18: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/18.jpg)
$300 Question from Classes & Schemes
What is an attribute? (UML, ER, RM)
![Page 19: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/19.jpg)
$400 Answer from Classes & Schemes
This is an attribute that provides real-world information, relevant to the
enterprise, about the class that we are modeling.
![Page 20: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/20.jpg)
$400 Question from Classes & Schemes
What is a descriptive attribute?
![Page 21: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/21.jpg)
$500 Answer from Classes & Schemes
This is a set of attributes, with an assignment rule. It provides the structure for a database table.
![Page 22: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/22.jpg)
$500 Question from Classes & Schemes
What is a relation scheme?
![Page 23: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/23.jpg)
$100 Answer from Rows & Tables
This contains information about one individual in a database table. (It is
called a tuple in the relational model.)
![Page 24: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/24.jpg)
$100 Question from Rows & Tables
What is a (table model) row?
![Page 25: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/25.jpg)
$200 Answer from Rows & Tables
This function assigns a constant value from the attribute domain to each
attribute in a relation scheme. (It is called a row in the table model.)
![Page 26: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/26.jpg)
$200 Question from Rows & Tables
What is a (relational model) tuple?
![Page 27: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/27.jpg)
$300 Answer from Rows & Tables
This set of rows represents all of the individual in a class. (It is called a relation in the relational model.)
![Page 28: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/28.jpg)
$300 Question from Rows & Tables
What is a (tablel model) table?
![Page 29: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/29.jpg)
$400 Answer from Rows & Tables
This set of tuples contains the information for all individuals in a class. (It is called a table in the table model.)
![Page 30: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/30.jpg)
$400 Question from Rows & Tables
What is a (relational model) relation?
![Page 31: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/31.jpg)
$500 Answer from Rows & Tables
This special constant value is compatible with any data type and means "this field doesn't have any
value assigned to it."
![Page 32: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/32.jpg)
$500 Question from Rows & Tables
What is NULL?
![Page 33: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/33.jpg)
$100 Answer from Keys
This can be any set of attributes in a relation whose values, taken together, guarantee uniqueness of the rows in a
table.
![Page 34: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/34.jpg)
$100 Question from Keys
What is a super key?
![Page 35: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/35.jpg)
$200 Answer from Keys
This minimal super key can't have an attribute deleted without losing the
super key property, or added without losing its distinction.
![Page 36: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/36.jpg)
$200 Question from Keys
What is a candidate key?
![Page 37: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/37.jpg)
$300 Answer from Keys
This candidate key is picked by the database designer to guarantee
uniqueness of each row in a table.
![Page 38: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/38.jpg)
$300 Question from Keys
What is a primary key?
![Page 39: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/39.jpg)
$400 Answer from Keys
This made-up primary key has no descriptive value about an
individual.
![Page 40: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/40.jpg)
$400 Question from Keys
What is a surrogate key?
![Page 41: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/41.jpg)
$500 Answer from Keys
This made-up primary key has at least some descriptive value about an
individual.
![Page 42: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/42.jpg)
$500 Question from Keys
What is a substitute key?
![Page 43: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/43.jpg)
$100 Answer from Associations
The minimum and maximum number of individuals of one class that may be associated with a single member of
another class. (Called cardinality in ER, RM and table model)
![Page 44: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/44.jpg)
$100 Question from Associations
What is multiplicity? (UML)
![Page 45: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/45.jpg)
$200 Answer from Associations
The way that two classes are functionally connected to each other.
(Called a relationship in the ER model.)
![Page 46: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/46.jpg)
$200 Question from Associations
What is an association? (UML)
![Page 47: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/47.jpg)
$300 Answer from Associations
The way that two entities are functionally connected to each other.
(Called an association in UML.)
![Page 48: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/48.jpg)
$300 Question from Associations
What is a relationship? (ER model)
![Page 49: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/49.jpg)
$400 Answer from Associations
This association has a maximum multiplicity of 1..*
![Page 50: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/50.jpg)
$400 Question from Associations
What is a one-to-many association?
![Page 51: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/51.jpg)
$500 Answer from Associations
This set of attributes is copied from the PK of a parent table into the scheme of
a child table.
![Page 52: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/52.jpg)
$500 Question from Associations
What is a foreign key?
![Page 53: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/53.jpg)
Final DataBitThis computer scientist developed the relational model
database for IBM in the 1970s.
![Page 54: Data Bits Models Classes & Schemes Rows & Tables Keys Associations $100 $200 $300 $400 $500 $100 $200 $300 $400 $500 Final DataBit](https://reader038.vdocuments.us/reader038/viewer/2022103121/56649c6f5503460f94922109/html5/thumbnails/54.jpg)
Final DataBit
Who is Dr. E.F. Codd?