Description of Entities and Associations identified trace analysis and additional assumptions made.
Remarks to chart:
Entity DEPARTMENT
Description: Represents the division into departments of the library catalog.
Department Code is the key attribute, department name and description (architecture and urban planning, art ...)
Entity CATEGORY
Description: Represents the categories to which those books.
class is the key attribute, Description is the description of the category ("can not miss", "Best Sellers" ...) Notes allows you to add a comment ("Discount 20% "...)
Entity BOOK
Description: Represents the books in the catalog. Bookseller
is key attribute, an attribute data which includes various information (number of pages, binding type ...), Availability is a text attribute used when ordering, and the other attributes are clear interpretation.
Association Classified
Description: associates a book to a department.
Association belongs
Description: Bind a book in various categories.
user entity
Description: Represents registered users can make purchases.
User ID is the key attribute, the attribute address is composed of city, street, house number etc.., The other attributes are clear interpretation.
Order entity
Description: Represents the purchase orders placed by users.
Order Number is the key attribute, the attribute status indicates whether the order is processed or to deal with, the bill required attribute indicates whether the user has requested an invoice being issued the order.
Association Included in the basket
Description : Users associated books and is the shopping cart that the user "fills" every time you access the site shop. Copies
is an attribute of the association and represents the number of copies of a book that you put in the cart, the attribute deleted is used to remove the book from the basket and avoid placing it in the order.
Association Make
Description: associates a user to its purchase orders.
The association is' included
Description: associates a book to order.
attribute Number of Copies is the number of copies of a book included in an order.
0 comments:
Post a Comment