TheEyesHaveIt.com Book Exchange is a type of e-business exchange that does business entirely on the Internet. The company acts as a clearing exchange for both buyers and sellers of used books.

For a person to offer books for sale, he/she must register with EyesHaveIt. The person must provide a current physical address and telephone number as well as a current e-mail address. The system will then maintain an open account for this person. Access to the system as a seller is through a secure, authenticated portal.

A seller can list books on the system through a special Internet form. Information required includes all of the pertinent information about the book, its category, its general condition, and the asking price. A seller may list as many books as desired. The system maintains an index of all books in the system so that buyers can use the search engine to search for books. The search engine allows searches by title, author, category, and keyword.

People wanting to buy books come to the site and search for the books they want. When they decide to buy, they must open an account with a credit card to pay for the books. The system maintains all of this information on secure servers.

When a request to purchase is made, along with the payment, TheEyesHaveIt.com sends an e-mail notice to the seller of the book that was chosen. It also marks the book as sold. The system maintains this as an open order until it receives notice that the books have been shipped. After the seller receives notice that a listed book has been sold, he/she must notify the buyer via e-mail within 48 hours that the purchase is noted. Shipment of the order must be made within 24 hours after the seller sends the notification e-mail. The seller sends a notification to both the buyer and TheEyesHaveIt.com when the shipment is made.

After receiving notice of shipment, TheEyesHaveIt.com maintains the order in a shipped status. At the end of each month, a check is mailed to each seller for the book orders that have been in a shipped status for 30 days. The 30-day waiting period is to allow the buyer to notify TheEyesHaveIt.com if the shipment does not arrive for some reason, or if the book is not in the same condition as advertised.

The buyers can, if they want, enter a service code for the seller. The service code is an indication of how well the seller is servicing book purchases. Some sellers are very active and use TheEyesHaveIt.com as a major outlet for selling books. So, a service code is an important indicator to potential buyers.

1. Develop the database schema based on the domain model class diagram. Make sure that each table has a primary key and the foreign keys are identified from the one-to-many associations. The database schema can be developed in table format (see Figure 12-8from the text book for example) or using a database schema design tool (for example MS Visio with Entity Relationship Diagram template) (10 points)

QUESTIONS BELOW ARE BASED OFF OF THE TEXT FROM ABOVE.

2. Use a User Interface Design Tool (for example MS Visio with Wireframe template) to design the user interface for the use case Register as Seller. (10 points)

Submit the database schema and user interface together with the domain