For each of the descriptions below perform the following tasks: a. A book is identified by its ISBN number and it has a title, a price, and a date of publication. It is published by a publisher which has its own ID number and a name. Each book has exactly one publisher but one publisher typically publishes multiple books over time.
b. A book is written by one or multiple authors. Each author is identified by an author number and has a name and a date of birth. Each author has either one or multiple books. In addition, occasionally data are needed regarding prospective authors who have not yet published any books.
c. In the context specified in 2a and 2b better information is needed regarding the relationship between a book and its authors. Specifically, it is important to record the percentage of the royalties that belong to a specific author whether or not a specific author is a lead author of the book and each author's position in the sequence of the book's authors.
d. A book (2a) can be part of a series which is also identified as a book and has its own ISBN number. One book can belong to several sets and a set consists of at least one but potentially many books.

Formatting rows and columns is similar to cell formatting. in an openoffice calc spreadsheet, you can format data entered into rows and columns with the of the rows and columns options. you can insert rows and columns into, or delete rows and columns from, a spreadsheet. use the insert or delete rows and columns option on the insert tab. alternatively, select the row or column where you want new rows or columns to appear, right-click, and select insert only row or only column options. you can hide or show rows and columns in a spreadsheet. use the hide or show option on the format tab. for example, to hide a row, first select the row, then choose the insert tab, then select the row option, and then select hide. alternatively, you can select the row or columns, right-click, and select the hide or show option. you can adjust the height of rows and width of columns. select row and then select the height option on the format tab. similarly, select column, then select the width option on the format tab. alternatively, you can hold the mouse on the row and column divider, and drag the double arrow to the position. you can also use the autofit option on the table tab to resize rows and columns.