undefined

Q2. Transform the solution for problem 4 into a logical model D. A book (see (a) above) can be part of a series, which is also identified as a book and has its own ISB N number. One book can belong to several sets and a set consists of at least one but potentially many books. BOOK ISBN Title Price Publish Date Belongs To Problem 4: Solution Q3. Transform the solution for problem 5 into a logical model Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists. PIANO Serial Number Mfg Completion Date MODEL ID Number Name DESIGNER Designer ID Designer Name Problem 5: Solution 3. Transform the solution for problem 6 into a logical model + Ebony and Ivory (see (e) above) employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade. 2 PIANO Serial Number Mfg Completion Date TECHNICIAN Employee Number Inspection Date Quality Grade Problem 6: Solution