In a relational table, what do rows and columns represent?
Columns describe attributes, while each row represents one record or instance.
Study Relational Tables, Keys, and Relationships with 12 free online flashcards. Review key terms, definitions, and concepts with this interactive flashcard deck.
In a relational table, what do rows and columns represent?
Columns describe attributes, while each row represents one record or instance.
What makes a candidate key the primary key?
A primary key is the candidate key chosen as the table’s main identifier. Its values must be unique and not null.
How do data types, domains, and constraints work together?
A data type supplies a basic domain of acceptable values; additional rules can narrow that domain, and constraints enforce those rules.
What table structure represents students taking many courses and courses having many students?
An associative table connects records from two tables and represents a many-to-many relationship, such as students taking courses.
What is a candidate key?
A candidate key is a minimal set of columns that uniquely identifies each row. A table may have more than one.
What do `NOT NULL`, `UNIQUE`, and `CHECK` constraints enforce?
`NOT NULL` requires a value, `UNIQUE` disallows repeated values or combinations, and `CHECK` enforces a specified condition.
What does a table’s schema define?
A table’s schema defines its columns; its rows vary as records are added or removed.
Where can a foreign key go in a one-to-many relationship?
Put a foreign key on the “many” side. For example, `Courses` can contain `department_id` when each course belongs to one department.
What is a cell in a relational table?
A cell contains the value at the intersection of a particular row and column.
What does `(student_id, course_id)` as a combined primary key prevent?
The combined primary key `(student_id, course_id)` allows at most one enrollment row for each student-course pair.
What does a foreign key require of its values?
A foreign key’s values must match a key in another table or the same table, preventing references to records that do not exist.
What is a column’s domain?
A domain is the set of valid values for an attribute; additional rules can narrow which values are acceptable.
A progressive guide to how computers encode numbers, text, images, and sound as binary data, including the trade-offs and limits of digital representation.
A 14-question medium-difficulty quiz on Boolean algebra, logic gates, truth tables, and combinational circuits.
A focused set of flashcards covering Python variables, data types, expressions, control flow, functions, input, output, and common programming practices.
Learn how computer memory stores and addresses information, how RAM and ROM differ, and how caches and the memory hierarchy balance speed, capacity, and cost.
A progressive guide to tree structure, binary-tree traversals, binary search tree operations, deletion, balancing, and the way tree height determines time and space costs.
A progression through how data is organized, searched, exposed through software interfaces, and managed through abstraction layers in modern computer systems.
Reviews how interrupts support event handling and multitasking, and how Linux system calls use the RISC-V `ecall` instruction and register conventions.
This quiz covers process management, context switching and scheduling, multitasking, traps and interrupts, and RISC-V privilege transitions.
A quiz on operating-system system calls, including privileged-operation requests, process creation and execution with fork, exec, and waitpid, and signal handling.