Relational Model, Relational Algebra and Normalization quizzes
21 quizzes by 18 users
This GoConqr page gathers quizzes on the relational model, database tables and normalisation, from table terminology to dependencies and normal forms. University students and school students can practise these topics, while teachers can find ready-made questions; the collection is mostly university-level, with some school-level material. There are more than 10 quizzes from more than 10 users. Pick a quiz to begin.
Quizzes
-
41 questionsChapter 3 (Multiple Choice) CIS 3365
-
42 questionsChapter 6 (Multiple Choice CIS 3365)
-
30 questionsChapter 3 (True/False) 1) The practical significance of taking the logical view of a database is that is serves as reminder of the...
-
11 questionsNormalization Practice In which state are the attributes shown (see table)?
-
38 questionsERD & Normalisation & SQL One of the disadvantage of the traditional file-based system is:
-
88 questions214
-
24 questionsChapter 5 - 13 Relational Databases In a relational database, a row may also be called what? (Choose two.)
-
38 questionsChapter 2 The classical/elementary types of file organization include:
-
21 questionsWeek 3 and 4 Consider the following relation: STUDENT(studentID, studentName, dateOfBirth, address, emailAddress, phoneN...
-
13 questionsQ14 What best matches with the Relational Database Terminologies A, B, and C depicted in the representation below?
-
20 questionsQuiz 3 - Chapter 4
-
10 questionsModule 7
-
6 questionsExams
-
11 questionsC192 Test Data Storage
-
9 questionsConcept 10 Practice Quiz A table is in BCNF if every determinant in the table is a foreign key.
-
6 questionsUML Lec4 Quiz The process of normalisation involves applying a series of refinements to groups of data items in order to ...
-
6 questionsConcept 9 Practice Quiz
-
13 questionsChapter 3 1.)A table is in NF3 if:
-
6 questionsUntitled In general, denormalization produces
-
2 questionsDBMS Midterm Select the FALSE statement
-
1 questionsUntitled Through normalization, update anomalies
More Relational Model, Relational Algebra and Normalization resources
About relational model, relational algebra and normalization quizzes
GoConqr OriginalRelational model, relational algebra and normalization quizzes
These quizzes offer different ways to check your understanding of database tables and normalisation. Module 7 asks about the relational data model and how data is organised. Normalization Practice uses tables to ask about partial and transitive dependencies and the state of a table.
How to use the quizzes
Start with Module 7 if you want to check the basic terminology before moving on to normalisation. For questions on redundancy and attributes, try Concept 9 Practice Quiz. Concept 10 Practice Quiz includes questions on BCNF and normalisation in the design process.
Work through a quiz and note the questions you find difficult. If you need to revisit an idea, switch to a mind map or flashcards on the unit page, then return to the quiz. Choose a question set and see where you want to focus.
Frequently asked questions
Which quiz is a useful place to start?
Module 7 is a starting point for checking relational model terminology. It asks how the model portrays stored data and how a user conceptually organises it. If you want to focus on normalisation instead, Normalization Practice asks you to identify dependencies and the state of tables.
What normalisation topics do these quizzes cover?
Normalization Practice includes questions on partial and transitive dependencies. Concept 9 Practice Quiz asks about redundancy, key attributes and dependencies between attributes. Concept 10 Practice Quiz includes BCNF and normalisation in the design process, while the Chapter 6 multiple-choice quiz asks about normal forms.
Are the quizzes free to use?
Yes. Every quiz listed here is free to open, study and take without an account. The resources were made by GoConqr users. A free account also lets you save quiz scores and make your own quizzes, mind maps, flashcards and notes.