# Requirements
?
The current application is provided under “Existing Application?? folder.
The current database schema is provided in the file “Existing DB [login to view URL]?
The script to create the administrator account is provided under “[login to view URL]?.
? The requirements for the changes to the existing application are as follows. The new database script is in the file “New DB [login to view URL]?.
The programmer should first install the existing application and the existing database script and understand the functionality. After that the changes should be implemented using the new database script.
Detailed requirements are in the? MS Word document "Requirement [login to view URL]" that is provided in the attached zip file.? The programmer? should read the? this document? before making a bid.
?
## Deliverables
# Detailed Requirements
?
The current application is provided under “Existing Application?? folder.
The current database schema is provided in the file “Existing DB [login to view URL]?
The script to create the administrator account is provided under “[login to view URL]?.
?
The requirements for the changes to the existing application are as follows. The new database script is in the file “New DB [login to view URL]?.
?
The programmer should first install the existing application and the existing database script and understand the functionality. After that the changes should be implemented using the new database script.
?
The system allows two types of customers.
?
1)? ? ? ? ? Customers that come in through sign-up requests
2)? ? ? ? ? Customers that come in through invitations
?
?
## *Signup requests*
?
1. Currently, signup requests are available for only a single product.
2. Change this, and make the signups available for all products.
3. To do this, add a drop-down in the sign-up screen where the user can select a product.
?
## *When a customer logs in*
?
1. The system should present all available products.
2. The list of available products should be obtained from the products table.
3. For each product, system should indicate whether the user “signed up?? or was “invited?? for that product.
* If the user signed up, the system should present information regarding the date of sign up and whether the sign up was approved by the administrator.
* If the user was invited, the system should present the date the user was invited.
* For invitations, they should be able to see the information that REDNOTES entered into the system when inviting them (including the content of the email that was sent to them). The email should not be directly displayed on this screen (since it will make the screen very busy). But should be displayed as a popup.
4. For each product, the system should present the list of downloads (if any) for that product based on the previous downloads by that user.
* For each product, the product license (provided that the user accepted the terms and conditions and downloaded the product previously).
* For each license code, display the expiration date and the number of licensed users.
5. The user should be able to change their “login id??, “password?? or “email address??.
?
## *The administration interface*
?
1. When viewing a user, the system should present all products and within each product, the signups and invitations for that user
2. When viewing invitations, it should be possible to edit the invitation and “resend?? that invitation. This should create a new invitation record in the database.
3. When a customer logs in, they should be able to see all their sign ups and all their invitations, and all the available products for download.
1. For signups, they should see the information they entered during signup.
2. All products that are available for download should be displayed, along with a brief description, a link to detailed product description and a link to download the product.
4. The current administration interface does not “highlight?? the screen that the administration is currently viewing. For example, when the administrator is viewing “Manage Users?? screen, the “Manage Users?? menu item should be highlighted. Also, there should be a screen heading at the top of the screen, below the menu, showing the title of the screen.
?
?
## *The database*
?
1. The new database script is attached in the file “New DB [login to view URL]?
2. The new script separates the “downloads?? into a new table.
3. The downloads table is used for downloads that are based on sign-up requests as well as invitations.
?
?
## *Graphical User Interface Improvements*
?
Using the application provided in the “Model for GUI?? folder, the graphical user interface should be improved (primarily in the main page and in the customer pages).
?
?