It may be necessary to add _____ to an attribute or relationship for legal or strategic reporting requirements.
Blog
Identify the design error when incorrectly using the crow’s…
Identify the design error when incorrectly using the crow’s foot symbol near the parent entity type instead of the child entity type and the 1 symbol (perpendicular line) for the maximum cardinality near the child entity type instead of the parent entity type.
The __________ action causes deletion of related child rows…
The __________ action causes deletion of related child rows when a parent row is deleted.
You have been given two tables, CUSTOMER and SALE. Currently…
You have been given two tables, CUSTOMER and SALE. Currently there is no foreign key relationship, but you want to add one, so you need to check the referential integrity constraint: SALE.CustomerNumber must exist in CUSTOMER.CustomerNumberYou run the following SQL query: SELECT CustomerNumber FROM SALE WHERE CustomerNumber NOT IN (SELECT CustomerNumber FROM CUSTOMER); What is shown in the results of this query?
When representing a one-to-many relationship in a relational…
When representing a one-to-many relationship in a relational database design, ________.
An attribute that determines which subtype should be used is…
An attribute that determines which subtype should be used is a(n) ________.
A table with columns PhoneNumber01, PhoneNumber02, and Phone…
A table with columns PhoneNumber01, PhoneNumber02, and PhoneNumber03 is likely to have ________.
A tuple is also known as a ________.
A tuple is also known as a ________.
A 1-1 relationship is converted into _____ when converted to…
A 1-1 relationship is converted into _____ when converted to a table design.
Supertype/subtype (generalization hierarchy) entities are sa…
Supertype/subtype (generalization hierarchy) entities are said to have a(n) ________ relationship.