Movie Called Crush On

additional analysis and assumptions

is required to design and implement a database that contains the information necessary for the online sale of books to registered users .

Books and Users are therefore the main objects of computer system you will achieve.

for books are required:

• division into departments (architecture and urban planning, art, classical Greek and Latin ...).
  Although not explicitly stated is plausible assume that a book is part of a single department

• further subdivision of the Department in categories, the text uses the term "books" that we replace with "class" Alternatively, we could use even the term "reported" to avoid ambiguity ("can not miss", "Best Sellers" category ...); every comment or a characterization that may affect the type of discount offered, the number of copies sold or the date of publication and inclusion in the catalog.
  Also in this case is not explicitly defined by the fact that a book can only belong to one or more categories, equivalently, if it is not explained in the same book can be applied to different reports, in our proposal will be given the opportunity to add a book in more than one category (may receive more alerts) thinking that, for example, a book can both belong to the category "not miss" and "Top Sellers"

• for each book are also precisely defined characteristics to be included in the database
  In particular we analyze:

  • the we assume that discount is not directly related to the category (or tip) of belonging

  • a series of particularly structured data (number of pages, type of binding ...) we represent in a generic text-only attribute on which no will be provided for any particular operation. Otherwise, the data should be distributed on fields separate
    

  • pictures of book covers are stored in external files the database where an addition will be reference to those files.

Even for users are precisely defined characteristics to be included in the database.

• No characteristic poses particular management problems. We are only obliged to point out that the credit card number of each user is an extremely sensitive and should be treated with appropriate procedures to ensure that they security (but this problem goes beyond the demands made in the text)

For each user, each new access to the online store will be assigned a virtual shopping cart in which to insert the selected books which can then be confirmed (all or in part) to give rise to a purchase order.

Additional assumptions in the definition of the shopping cart text speaks of " availability (days, weeks ...), this information will be provided for each book database