Develop the database schema based on the domain model

Assignment Help Database Management System

Reference no: EM132152004

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 or using a database schema design tool.

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.

Submit the database schema and user interface together with the domain

Reference no: EM132152004

Questions Cloud

Develop a use-case description for each major use case : Create an activity diagram for the business process described in this case through the use of graphical tools in Microsoft Word or Visio, or an open source.

Convert the class so that the link objects have a single : Convert the class so that the Link objects have a single long instance variable -- call it "data" -- and the Link instance variable..

Identify five forms of qualitative media evaluation : BSBADV605 Evaluate campaign effectiveness Assignment - Identify five forms of qualitative media evaluation which may be used

Why is the term important in economics : What is an opportunity cost, and why is the term important in economics? (The answer should be a calculation with 2 or 3 complete sentences).

Develop the database schema based on the domain model : Develop the database schema based on the domain model class diagram. Make sure that each table has a primary key and the foreign keys.

What is the actuarially-fair premium : A group of individuals each face a 1% probability of suffering a loss of $10,000, a 4% probability of suffering a $1,000 loss, a 20% probability of suffering a

Write a main function that outputs the result of calling : Write a simple C++ program that defines two different functions (f and g) that both take two int values and return an int. value.

Payors of healthcare or the providers of healthcare : Pick a side, the payors of healthcare or the providers of healthcare, and defend their position for the payment of healthcare services.

Explain how dc performed project planning : Write a four to five (4-5) page paper in which you: Explain how DC performed project planning and analyze its effectiveness for later execution and product.

User Account

All Pages