Consider Figure 2.1. In addition to constraints relating the values of columns in one table to columns in another table, there are also constraints that impose restrictions on values in a column or a combination of columns within a table. One such constraint forces that a column or a group of columns must be unique across all rows in the table. For example, in the STUDENT table, the StudentNumber column must be unique (to prevent two different students from having the same StudentNumber). Identify the column or the group of columns in the other tables that must be unique across all rows in the table?
What will be an ideal response?
Computer Science & Information Technology
You might also like to view...
How do the dependencies between SSE-CMM processes affect capability levels?
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
RAM is an example of ________ storage.
A. volatile B. nonvolatile C. permanent D. mobile
Computer Science & Information Technology
Briefly distinguish among data, information, and knowledge.
What will be an ideal response?
Computer Science & Information Technology
At installation, Fedora Linux creates a symbolic link called ____________________ to the correct device file for your first CD-ROM drive.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology