CIW Related Exams
1D0-541 Exam
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?

In which phase of database design do you identify entities, attribute domains, and relationships?
Your company must choose which type of database to use for a new project. Which of the following lists three characteristics of file-based database systems?