Avoid Discomfort In Shortness Of Breath

Track Maturity AS 2006/07

An online store calls for both designed and built a database for the organization and management a portal for the sale of books on the Internet.

The store requires that:

• Catalogue of books is organized by:

- Departments (in alphabetical order: architecture and urbanism, art, classical Greek and Latin, kitchen and home, law, economics and management, science fiction and fantasy, philosophy, comic books, ...)

• Each department is organized in books:

- "Do not miss" characterized by a 20% discount on the cover price

- "Best Sellers" characterized by the largest number of copies sold in the last 30 days

- "Last Uploads" characterized by titles added in the last 30 days

- "Special" characterized by a 25% discount on the cover price

- "Remainders" characterized by a 50% discount on the cover price

• each book in the store is closed with the following additional information:

- title, author, cover price, discount (if applicable), data (number of pages, hardbound, ...), year of publication, publisher, series, image (photo cover ), data storage

• enabled users to purchase online are listed with the following information:

- name, address, zip code, city, country, phone, fax, and email, password, credit card number, type of credit card (Visa, CartaSi, Mastercard, ...), expiration date of the credit card

• Users may request, during the purchase, the store will invoice

• shopping cart is organized as follows:

- number of copies purchased, title, author, price, availability ( days, weeks, ...), remove from cart (checkbox)

• the list of orders is organized as follows:

- order date, order number

- order details (reference item number, title, cover price, discounted price, order status, avoidance expected from the order date).

The candidate, after making any additional assumptions:

a. Supply:

1. the conceptual and logical database schema

2. the definition of relations in SQL.

b. Implements the following query:

1. Search by Department: choose a department, the number of books "can not miss" and the number of books, "Best Sellers" with details about

2. Orders: Orders in progress, with details of a given user.

c. Write a server side language, the code of at least one of the following pages of the portal:

1. with free access, the page useful to view the Departments and for each department, the page that implements the query No 1;

2. with access restricted to registered users, the composition of the orders.