Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts...

15
Review Session Quiz 1

Transcript of Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts...

Page 1: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ReviewSessionQuiz1

Page 2: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

DifferentTopicsCoveredatthisPoint

• RelationalAlgebra• RelationalModel• Entity-RelationshipModel• TupleRelationalCalculus(Notontest)• Sql 1• Sql 2• Constraints

Page 3: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

RelationalAlgebra

BasicOperators1.Select(σ)2.Project(π)3.Union(∪)4.Setdifference(–)5.Cartesianproduct(X)6.Rename(ρ)

AdvancedOperators1.NaturalJoin(⨝)2.Division(÷)3.Aggregation(g)4.OuterJoins(⟕⟗⟖)

Page 4: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion

Page 5: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion

Page 6: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion2

Page 7: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

QuestionsonRelationalAlgebra?

BasicOperators1.Select(σ)2.Project(π)3.Union(∪)4.Setdifference(–)5.Cartesianproduct(X)6.Rename(ρ)

AdvancedOperators1.NaturalJoin(⨝)2.Division(÷)3.Aggregation(g)4.OuterJoins(⟕⟗⟖)

Page 8: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

EntityRelationshipDiagrams

BasicTermsandConcepts1. Entities2. RelationshipsDesignConstraints1. EntitySetsvsAttributes2. EntitySetsvsRelationshipSets3. RelationshipCardinalities4. WeakEntitySets5. Inheritance

Typesofkeys1.CandidateKeys2.SuperKeys3.PrimaryKeys

TranslatingERDiagramsToRelationalSets

Page 9: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

QuestionsonTupleRelationalCalculus?

FormulaSetup:1. Queryhastheform:{T|p(T)}2. AnsweristhesetofalltuplesT

forwhichtheformulap(T)evaluatestotrue.

AvailableOperations1. ¬p,p∨ q,p∧q

1. PandQareformulas

2. ∃R(p(R))1. Risatuplevariable

3. ∀R(p(R))1. Risatuplevariable

Page 10: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

SQL

• BasicStructure

• OtherIdeas• DistinctClause• NaturalJoin• RenameOperator• AggregateFunctions

• GroupBy• NestedSubQueries

Page 11: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion

Page 12: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion

Page 13: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestion

Page 14: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

ExampleQuestionCont.

• Breaktheproblemupintosubparts

Page 15: Review Session Quiz 1 · 2017. 10. 15. · Entity Relationship Diagrams Basic Terms and Concepts 1.Entities 2.Relationships Design Constraints 1.Entity Sets vs Attributes 2.Entity

Constraints

IntegrityConstraints1.PrimaryKey2.AttributeConstraint3.ReferentialIntegrityConstraint4.GlobalConstraints


Instructor’s Guide to Teaching SolidWorks Software Lesson 4 · 2019-02-24 · 3 Ι Ι l Ι Sketch for Cut Feature Sketch is composed of two curves. Convert Entities creates the

Instructor’s Guide to Teaching SolidWorks Software Lesson 4 · 2019-02-24 · 3 Ι Ι l Ι Sketch for Cut Feature Sketch is composed of two curves. Convert Entities creates the

HUMAN COMPUTER INTERACTIONhy364/files/lectures/02_Human... · 2020-02-06 · 1st Part: The human We discuss the user’s: Psychological and Physiological attributes A basic overview

HUMAN COMPUTER INTERACTIONhy364/files/lectures/02_Human... · 2020-02-06 · 1st Part: The human We discuss the user’s: Psychological and Physiological attributes A basic overview

Entity-Relationship Παραδείγματα

Entity-Relationship Παραδείγματα

TENSOR ALGEBRA - PRESENTACIOmmc.rmee.upc.edu/documents/Slides/Ch0-Algebra_v22.pdf · Concept of Tensor A TENSOR is an algebraic entity with various components which generalizes the

TENSOR ALGEBRA - PRESENTACIOmmc.rmee.upc.edu/documents/Slides/Ch0-Algebra_v22.pdf · Concept of Tensor A TENSOR is an algebraic entity with various components which generalizes the

Therapeutic Class Overview Long-Acting Inhaled β -Agonists ......Therapeutic Class Overview Long-Acting Inhaled β2-Agonists (Single Entity) Therapeutic Class Overview/Summary: Respiratory

Therapeutic Class Overview Long-Acting Inhaled β -Agonists ......Therapeutic Class Overview Long-Acting Inhaled β2-Agonists (Single Entity) Therapeutic Class Overview/Summary: Respiratory

NISTmAb RM 8671 Humanized Monoclonal IgG1κ · 5 NISTmAb Attributes by CE Methods ... AHT-UV_NR PDA - 220nm AHT+UV_NR 10 kDa . L . H . H:L . H:H . H:H:L . clip monomer CE-SDS Qualification

NISTmAb RM 8671 Humanized Monoclonal IgG1κ · 5 NISTmAb Attributes by CE Methods ... AHT-UV_NR PDA - 220nm AHT+UV_NR 10 kDa . L . H . H:L . H:H . H:H:L . clip monomer CE-SDS Qualification

Κώδικας Δεοντολογίας του Ν.4224/2013 Entities/Info... · 2015-08-06 · Κώδικας Δεοντολογίας του Ν.4224/2013 -2- i. ΕΙΣΑΓΩΓΗ

Κώδικας Δεοντολογίας του Ν.4224/2013 Entities/Info... · 2015-08-06 · Κώδικας Δεοντολογίας του Ν.4224/2013 -2- i. ΕΙΣΑΓΩΓΗ

St. Michael and Attis - EKTejournals.epublishing.ekt.gr/index.php/deltion/article/viewFile/... · St. Michael and Attis Cyril MANGO ... granted these very attributes to archangels,

St. Michael and Attis - EKTejournals.epublishing.ekt.gr/index.php/deltion/article/viewFile/... · St. Michael and Attis Cyril MANGO ... granted these very attributes to archangels,

Hecate and Her DogsHecate: Origin, relations and attributes • Place of worship and origin (von Rudloff 1992: 45-55) • Indications of a Carian or general Anatolian origin (e.g.

Hecate and Her DogsHecate: Origin, relations and attributes • Place of worship and origin (von Rudloff 1992: 45-55) • Indications of a Carian or general Anatolian origin (e.g.

Sofia Zapounidou Antigoni Dimitriadouconta.uom.gr/conta/ekpaideysh/metaptyxiaka/technologies_diktywn...Abstract Topology is one of the three networking attributes, which characterize

Sofia Zapounidou Antigoni Dimitriadouconta.uom.gr/conta/ekpaideysh/metaptyxiaka/technologies_diktywn...Abstract Topology is one of the three networking attributes, which characterize

Effect of Starch Physiology, Gelatinization and Retrogradation …...[16]. Starch amylose/amylopectin ratio, morphological attributes along with other biopolymers and plasticizers

Effect of Starch Physiology, Gelatinization and Retrogradation …...[16]. Starch amylose/amylopectin ratio, morphological attributes along with other biopolymers and plasticizers

Relational algebra - · PDF file• If a relational-algebra expression E has arity n, then returns the result of expression E under the name X, and with the attributes renamed to A1,

Relational algebra - · PDF file• If a relational-algebra expression E has arity n, then returns the result of expression E under the name X, and with the attributes renamed to A1,

ra-sql2 [Uyumluluk Modu] - bekirdizdaroglu.com · Applying γ L(R) Group Raccordi t llth iding to all the grouping attributes on list L. That is: form one group for each distinct

ra-sql2 [Uyumluluk Modu] - bekirdizdaroglu.com · Applying γ L(R) Group Raccordi t llth iding to all the grouping attributes on list L. That is: form one group for each distinct

Experimental Studies on it-Clefts and Predicate Interpretation · the truth conditions of cleft sentences are defined by overlap with or identity to the mereological sum of entities

Experimental Studies on it-Clefts and Predicate Interpretation · the truth conditions of cleft sentences are defined by overlap with or identity to the mereological sum of entities

Epic Slides (HONR 218C) slides short.pdfThe seventh century poet Mimnermus attributes the murder of Ismene, sister of Antigone, to Tydeus (father of Diomedes). No other classical writer

Epic Slides (HONR 218C) slides short.pdfThe seventh century poet Mimnermus attributes the murder of Ismene, sister of Antigone, to Tydeus (father of Diomedes). No other classical writer

SIX SIGMA - Sudan University of Science and Technology · Sigma vs. DPMO •1 sigma ... Key Six Sigma Concepts • Critical to quality: attributes most important to ... •CTQ Tree

SIX SIGMA - Sudan University of Science and Technology · Sigma vs. DPMO •1 sigma ... Key Six Sigma Concepts • Critical to quality: attributes most important to ... •CTQ Tree

Supermarket Key Attributes and Location Decisions: A ...A well-known aphorism states, “the most important attributes of stores are location, location and location”. ... 1 Note

Supermarket Key Attributes and Location Decisions: A ...A well-known aphorism states, “the most important attributes of stores are location, location and location”. ... 1 Note

Context Aware Spatial Priors using Entity Relations (CASPER) Geremy Heitz Jonathan Laserson Daphne Koller December 10 th, 2007 DAGS.

Context Aware Spatial Priors using Entity Relations (CASPER) Geremy Heitz Jonathan Laserson Daphne Koller December 10 th, 2007 DAGS.

Automatic Exchange of Financial Account Information ...nuntiusbrokers.com/fs/CRSNuntiuseng.pdf · Services S.A., as in any Financial Institution and Investment Entity: (a) Collection

Automatic Exchange of Financial Account Information ...nuntiusbrokers.com/fs/CRSNuntiuseng.pdf · Services S.A., as in any Financial Institution and Investment Entity: (a) Collection

Effect of Mild Sonication Conditions on the Attributes of ...file.scirp.org/pdf/AiM20120200007_20851741.pdf · M. MONCADA . ET AL. 105. kHz showed the highest amount of β-galactosidase

Effect of Mild Sonication Conditions on the Attributes of ...file.scirp.org/pdf/AiM20120200007_20851741.pdf · M. MONCADA . ET AL. 105. kHz showed the highest amount of β-galactosidase