DBS at TU Ilmenau

Flashcards and summaries for DBS at the TU Ilmenau

Arrow Arrow

It’s completely free

studysmarter schule studium
d

4.5 /5

studysmarter schule studium
d

4.8 /5

studysmarter schule studium
d

4.5 /5

studysmarter schule studium
d

4.8 /5

Study with flashcards and summaries for the course DBS at the TU Ilmenau

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Attribute und Domäne

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Probleme Transaktion -> Lost update

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Erste Normalform
This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Entwurfsverfahren: Dekomposition

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Def Relationship

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Def Attribut

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

create tbale, primary key
This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

M:N-Beziehung

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Def Entity

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

[min, max]-Notation

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

ER-Modell, Optionalität
This was only a preview of our StudySmarter flashcards.
Flascard Icon Flascard Icon

Millions of flashcards created by students

Flascard Icon Flascard Icon

Create your own flashcards as quick as possible

Flascard Icon Flascard Icon

Learning-Assistant with spaced repetition algorithm

Sign up for free!

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

Realtionships: Stelligket vs. Kardinalität

Your peers in the course DBS at the TU Ilmenau create and share summaries, flashcards, study plans and other learning materials with the intelligent StudySmarter learning app.

Get started now!

Flashcard Flashcard

Exemplary flashcards for DBS at the TU Ilmenau on StudySmarter:

DBS

Attribute und Domäne
dom(A) : A el U (Attribute) -> D (Wertebereich)

DBS

Probleme Transaktion -> Lost update
T1 liest Wert T2 liest selben Wert T1 ändert Wert T2 ändert selben Wert T1 schreibt Wert T2 schreibt Wert -> Nur Änderung von T2 in DB

DBS

Erste Normalform
Nur atomare Attribute

DBS

Entwurfsverfahren: Dekomposition
Sucht transitive Abhängigkeiten und eliminiert diese (Dekomposition). Bis 3.NF erreicht ist gewährleistet keine Abhängigkeitstreue

DBS

Def Relationship
Beziheung zwischen Entities

DBS

Def Attribut
Repräsentiert Eigenschaft von Entities oder Relationships

DBS

create tbale, primary key
create table xy( ab int primary key ... ) ODER create table xy( ab int cd int ... primary key(ab,cd) )

DBS

M:N-Beziehung
keine Restriktionen

DBS

Def Entity
Objekt, über das Informationen gespeichert werden sollen

DBS

[min, max]-Notation
lagert_in(Produkt[0,1], Fach[0,3]) "EIN Produkt kann maximal eine Beziheung eingehen" "EIN Fach kann maximal drei Beziehungen eingehen"

DBS

ER-Modell, Optionalität
Attribute können als optional gekennzeichnet werden, funktionale Bezihungen können auch partiell sein (Kardinalität [0,1])

DBS

Realtionships: Stelligket vs. Kardinalität
Stelligkeit: # beteiligter Entity-Typen Kardinalität: # Entities eines Typs, die an der Bezihung teilnehmen können

Sign up for free to see all flashcards and summaries for DBS at the TU Ilmenau

Singup Image Singup Image

DL4CV at

TU München

DM2 at

Universität Bielefeld

DSSZ at

Universität Bochum

DBA at

Hochschule Augsburg

DCT at

Université Panthéon-Sorbonne (Paris I)

Similar courses from other universities

Check out courses similar to DBS at other universities

Back to TU Ilmenau overview page

What is StudySmarter?

What is StudySmarter?

StudySmarter is an intelligent learning tool for students. With StudySmarter you can easily and efficiently create flashcards, summaries, mind maps, study plans and more. Create your own flashcards e.g. for DBS at the TU Ilmenau or access thousands of learning materials created by your fellow students. Whether at your own university or at other universities. Hundreds of thousands of students use StudySmarter to efficiently prepare for their exams. Available on the Web, Android & iOS. It’s completely free.

Awards

Best EdTech Startup in Europe

Awards
Awards

EUROPEAN YOUTH AWARD IN SMART LEARNING

Awards
Awards

BEST EDTECH STARTUP IN GERMANY

Awards
Awards

Best EdTech Startup in Europe

Awards
Awards

EUROPEAN YOUTH AWARD IN SMART LEARNING

Awards
Awards

BEST EDTECH STARTUP IN GERMANY

Awards
X

StudySmarter - The study app for students

StudySmarter

4.5 Stars 1100 Rating
Start now!
X

Good grades at university? No problem with StudySmarter!

89% of StudySmarter users achieve better grades at university.

50 Mio Flashcards & Summaries
Create your own content with Smart Tools
Individual Learning-Plan

Learn with over 1 million users on StudySmarter.

Already registered? Just go to Login