1. List five guidelines for designing data entry screens by providing examples where appropriate (25 points).

2. Suppose that you will implement a new information system to a bank company. Which system changeover method should you choose? Why? (25 points).

3. Suppose that you are an IT authority at a bank company. Which back up policy do you suggest to your company to apply? Why? (25 points).

4. You are called upon to design a schema for a library database. The following aspects should be represented in your schema:

a. Each book has an ID, title, and author.

b. Each borrower has an ID and a borrow date.

c. Each book may be borrowed by one or more borrowers.

d. Each borrower must borrow at least one or more books.

Draw an entity-relationship (ER) diagram to model the schema of this music database (25 points).