(Solved): You want to create a database about the books on your shelf. Each book has authors (assume that onl ...

You want to create a database about the books on your shelf. Each book has authors (assume that only the last name is needed), title, publisher, courses used in (course number only). Draw the ER diagram using the Chen-like model, and then write the English description for your diagrams. Compare the English to your diagrams and state any assumptions you made when drawing the diagrams. Which attributes would you consider composite attributes in this database? Which attributes would you consider multivalued attributes in this database? Could there be any derived attributes? What would be good keys? Map your diagram to a relational database. Note: Example of mapping to a relational database Student (sname, stno, address, phone) Note that the primary key is underlined