Relational Model, Relational Algebra and Normalization flashcards
21 flashcard decks by 18 users
This GoConqr page gathers flashcards on the relational model, relational algebra and normalisation, from database terminology to dependencies and keys. The collection has over 20 flashcards made by more than 10 users, for university students and school students practising these topics and teachers looking for study material. Choose a deck to get started.
Flashcards
-
8 cardsRelational Algebra Symbols shows basic relational algabra symbols and names.
-
33 cardsDatabase Management 2 Attribute, or set of attributes, within one relation that matches candidate key of some (possibly same) rel...
-
52 cardsSCC 201- Lecture 3 - Relational algebra What is a relation?
-
35 cardsDatabases Topic 1 What is a database?
-
18 cardsWeek 3 - Relational Database Model
-
23 cardsNormalisation What is the purpose of normalisation? Why do we need to avoid redundancy?
-
22 cardsDuplicate Rows, Tables, Keys. Ect. Why you can't there be duplicate rows?
-
13 cardsSCC 201 - Second Normal Form Why is deletion dependency a problem?
-
9 cardsDependencies - relational model What are the requirements for 1NF?
-
16 cardsDatabases Ch5 What is a Relation?
-
9 cardsSCC 201 - Third Normal Form A relational schema is said to be in 3rd normal form, if what?
-
11 cardsRelational Data Model What is physical data independence?
-
11 cardsThe relational model What is a relation?
-
10 cardsDatabases 4.10
-
5 cardsRelational Databases Flashcards What does a relational database store data on?
-
4 cardsNormalisation Zero Normal Form
-
7 cardsChapter 5 Advantages and Disadvantages of normalisation Chapter 5 Advantages and Disadvantages of normalisation
-
4 cardsDisadvantages of normalisation Disadvantages- Reduced database performance
-
8 cardsTerminology What is a relation?
-
3 cardsKeys
-
2 cardsCMPT 354 — Database Systems What is a relation?
More Relational Model, Relational Algebra and Normalization resources
About relational model, relational algebra and normalization flashcards
GoConqr OriginalRelational model, relational algebra and normalization flashcards
These decks offer different ways to revisit the unit. Relational Databases Flashcards asks about the purpose and uses of relational databases, while The relational model covers relations, tuples and keys. Start with either deck if you want to check the vocabulary before moving on.
Practise operations and dependencies
For algebra, try Relational Algebra Symbols to connect operations with their symbols. The decks on second and third normal form focus on dependencies and schema conditions. Normalisation also asks about redundancy and anomalies.
Make the cards work for you
Answer each prompt before checking the card, then return to the terms you found difficult. If you want a different view of a topic, switch to a mind map on the unit page before testing yourself again. Pick a deck that matches what you are studying.
Frequently asked questions
Which flashcard deck is a good place to start?
Try The relational model if you want to check terms such as relation, tuple and key. Relational Databases Flashcards is another starting point, with questions about what relational databases store and how they are used. Choose the deck whose prompts are closest to what you are studying.
Are there flashcards on normalisation?
Yes. Normalisation includes questions about redundancy and anomalies, while Dependencies - relational model covers functional dependencies and normal forms. There are also decks devoted to second and third normal form. You can use the questions to check individual definitions and then revisit the ones you find difficult.
Are these flashcards free to use?
Yes. Every resource listed here is free to open and study without an account. The decks were made by GoConqr users. A free account also lets you make your own flashcards, quizzes, mind maps and notes, and save your quiz scores.