quiz 3 a Boston University CS 669

Answers: a. b. c. d. Response Feedback: The normalization process might yield additional entities and attributes that need to be added to the ERD. The design process for a new database usually begins with conceptual design, then proceeds to logical design, and then to physical design. An early step is identifying the entities, attributes, and relationships. Normalization is applied at all stages of design of a relational database, beginning with conceptual design. The concepts are covered in section 6-7 of the textbook, 12th and 13th editions. Question 2 Selected Answers: a. e. Answers: a. b. c. d. e. Response Feedback: View the incomplete relational diagram, and follow the instructions below. The ROWS table is a linking (bridge) table between the ROWER and BOAT tables, and is missing its composite primary key. Select all of the appropriate attributes from BOAT and ROWER which should be duplicated into ROWS as its primary key. (Choose all appropriate attributes to make up ROWS' primary key). BOAT_CODE ROWER_NUM BOAT_CODE BOAT_CLASS ROWER_L_NAME ROWER_HEIGHT ROWER_NUM The concepts are covered in section 4-1k of the textbook, 12th and 13th editions. Question 3 A prominent animal and nature magazine company employs many photographers to capture wildlife. Each photographer is supplied with at least one high-end camera. To assist in deciding which photographers to assign to the most exotic and difficult projects, the company ranks the photographers. They 5 out of 5 points 5 out of 5 points Selected Answer: e. Answers: a. b. c. store this information in tables represented by the following ERD: The company decides to maintain a history of the date a camera is assigned to each photographer, and the rank of each photographer at the time of this assignment. This history can be stored in a single table. Try to store the minimum data sufficient to record which photographers had which cameras on which dates, and their rankings on those dates. Choose the best solution to this