For the Employee relation shown in the exhibit, which set of column value holds the complete tuple for the employee named James Smith?
What is the highest normal form of the relation(s) shown in the exhibit?
What improvement can be made to file-based databases to overcome their limitations?
Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name and Res_Name are represented by variable-length strings with a maximum of 20 characters. Location can be up to 50 characters long, and no building has more than 600 rooms. Which SQL statement best implements the BUILDING relation shown in this diagram?
Your enterprise is involved in planning a database project. The exhibit shows the result of one phase of the database design life cycle. Which term best describes the diagram shown in the exhibit?
Consider the entity-relationship (ER) diagram shown in the exhibit. What do the characters at the ends of the connecting line indicate?
Your enterprise is creating a relation (shown in the exhibit) that tracks parts and suppliers. Which situation would occur if new supplier information were entered in the relation before any information about specific parts?
Which type of relational integrity is violated if a primary key in a database has a null value?
Which of the following definitions best describes an entity?
Which of the following best describes the two-tier database architecture?
Consider the relation shown in the exhibit. Which of the following SQL statements would return a relation that excludes all customers with a Satisfaction_Rate of less than or equal to 80 unless the Sales_Office is located in Atlanta?
In which phase of database design do you identify entities, attribute domains, and relationships?
Which statement is used to define a named group of related tables, views, domains and other database objects?
What is the most important service provided by a database management system?
Which type of dependency occurs when one attribute of a composite key is removed and the dependency still exists?
Consider the Dept1_Parts and Dept2_Parts relations shown in the exhibit. Which of the following SQL statements would create a set difference of the two relations with the widest variety of Structured Query Language dialects?
A large enterprise uses a two-tier database architecture and runs complex database applications.
Which term best describes the client in this system?
Consider the following relations shown in the exhibit. Which of the following SQL statements would return the Customers2 relation from the Customers relation?