Consider the following four database design activities:
1 - Design user views.
2 - Select a DBMS.
3 - Apply normalization.
4 - Determine entities.
Which choice shows the correct ordering of these activities, from first to last, by assigned numbers?
With regard to databases, what is normalization?
Which statement accurately describes a characteristic of attributes?
Your enterprise must decide whether to use a database management system. Which of the following best describes the functionality of a DBMS?
What is the most important service provided by a database management system?
Consider the table shown in the exhibit. Which relational algebraic operation would return Row 3?
Consider the following relation definition:
STUDENT(
Student_Number: integer NOT NULL
Name: variable length character string length 20 NOT NULL)
Primary Key Student_Number
HOUSING(
Housing_ID: integer NOT NULL
Student_Number: integer NOT NULL
Building: variable length character string length 25 NOT NULL)
Primary Key Housing_ID
Foreign Key Student_Number References
STUDENT(Student_Number)
ON DELETE NO CHECK
ON UPDATE
Which integrity constraint is violated in this relation definition?
Your enterprise is developing a database system that will contain highly sensitive data. Security of the data will take priority over database processing speed. Which database protection technique should be employed?
Consider the following relational algebraic expression: Which of the following SQL statements is equivalent to this relational algebraic expression?
Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists?
