CIW Related Exams
1D0-541 Exam

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?
Consider the Information Engineering diagram shown in the exhibit for a building management company. Referential integrity must be maintained such that a building cannot be deleted when it has residents. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name, Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters. Which SQL statement best implements the relations shown in this diagram?
Consider the relations shown in the exhibit. Which of the following SQL statements would enter data from the Customers relation into the Atlanta_Customers relation?