Quiz 1-4 Questions
Linking
If two tables have a many-to-many relationship, you need to define a/an ____________________ table that relates their records.
that doesn't include a value for that column is added to the table
If you define a column with a default value, that value is used whenever a row
One-to-Many
The most common type of relationship between two tables is a/an _______________________ relationship.
each non-key column must depend only on the primary key
To be in the third normal form,
return an error instead of deleting any rows AND delete a row in a primary key table and all related rows in a foreign key table
To enforce referential integrity for a delete operation, an Oracle database can
Table
To model a database on a real-world system, you typically represent each real-world entity as a/an ____________________________.
Foreign Key
To relate one table to another, a/an _______________________ in one table is used to point to the primary key in another table.
third
Typically, most database designers consider a database structure normalized if it's in the ________________________ normal form.
Primary Key
A/An _______________________ uniquely identifies each row in a table.
Type
When a column in a table is defined, it is given a data ________________ that determines what kind of data it can store.