Web Site Database Application

See detailed specifications below. ## Deliverables [*Web Site Database Application*][1] *and Agreement* This is an internet application accessed with any browser. The specifications below describe it without giving field names to explain the data. Vendors must return the document CONFIDENTIALITY AGREEMENT below signed. Please change [PERSON], [COMPANY] and [LOCATION] to you name, company name and location, in the first sentence and under "Agreed By." Then sign/title/date below "Agreed By", scan the page and return the scan. I will then send the field names and detailed explanation of what the application is doing. Technical documentation should include the following: 1. How to install it. 2. A list of all directories and files in the directories. 3. For each file, its purpose. 4. For each file that is an executable computer program: 5. For each main program or subroutine defined: a. The programming languages(s) it is written in. b. The function of the program/subroutine. c. The formal input and output variables and meanings. 6. A flowchart that shows the execution sequence through the system and all calls to subroutines. All subroutines in (5) should be mentioned within the flowchart's execution path. The application consists of 16 screens that maintain a database. Each screen has a HELP button that opens a new window that explains the current screen, with links to the rest of these documentation screens that explain the entire system. In general the system should allow sophisticated interactions between the user and the system, giving quick and easy access to all of the data. URLs used should have no parameters - parameters should be passed through hidden input only. The vendor should provide a URL where I can test the system as it is being developed. The database consists of two hierarchies: Subject/Topic and Project/Group/User. Each level of each hierarchy is a record with fields named A, B, C etc. with a value with the indicated field type. 1. Subject: There are 10 subjects. A. TEXT 1 to 31 characters. 2. Topic: Each subject has 1 to 10 topics A. TEXT 1 to 31 characters. and 1. Project: The database contains any number of Projects. A. TEXTAREA 0 to 1000 characters (average 100) B. TEXT 1 to 63 characters. C. TEXT 1 to 63 characters. D. Number 0 to 1000 E. Subject (first hierarchy) F. Topic within the Subject in E. G. The IP Address of the user who added this Project. 2. Group: Each Project has any number of Groups. A. TEXT 1 to 1023 characters (average 100) B. The IP Address of the user who added this Group. 3. User: Each Group of each Project has any number of User records. Each IP Address of a user has a single record per Project and Group. This record is populated when a user with that IP Address visits a certain Project and Group, and enters its 4 field values (B-E below.) A. IP Address B. Text with 5 choices C. Number 0 to 1000000 with 60choices. D. TEXT 0 to 31 characters E. TEXT 0 to 31 characters The system also keeps track of Inappropriate Content reported by users, IP Addresses that I ban, User Feedback messages, statistics on screens that are visited with the values of variables selected, and the value that when entered goes to options that I use to maintain the system. The 16 screens are as follows. If there is room, you can keep more than one of these screens on the same display. 1. Choose Subject: There should be a picture for each Subject with the name of the Subject and the number of Projects on file. The user clicks on one of the pictures to choose that Subject and continue to screen 2. There is also a feedback form where the user can send a message and a place to enter their email address if they want a response. 2. Choose Topic: There should be a picture for each Topic within that Subject with the name of the Topic and the number of Projects on file. The user clicks on one of the pictures to choose that Topic, or on ALL to include all Topics, then continue to screen 3, or clicks on a BACK/SUBJECT button to go back to screen 1. 3. Choose Project: List the Topic or all Topics, each as a smaller display of the picture of that Topic, and for each Topic list all Projects. For each Project list fields A and B. The values of E and F (Subject and Topic) are indicated by the Project being displayed close to the picture for its Topic, with the Subject indicated by its picture being at the top of the display. The user can click on a button to go to screen 4 to add a new Project, or click on a Project to go to screen 5 to perform an action on that Project, or click a button to go back to screen 2. 4. Add Project: Display the chosen Subject and Topic, and read in the 4 other Project fields A, B, C and D. A, B and D are required, while C is optional. Field G, the user's IP Address, is automatically filled in. Click a button to save the new Project and continue to screen 5. 5. Choose Action: Display the Project with all 6 fields. Also display: The number of Groups, the number and percent of Groups that contain any User records, the number and percentage of Groups that do not contain any User records, and a formula = ( field D multiplied times the number of Groups) minus the number of User records. The user clicks a button to Add Groups (screen 6), Add Users (screen 7), View Groups (screen 8) or go back to screen 3. 6. Add Groups: The same Project data as in screen 5 is displayed. There is also a TEXTAREA box to read in a string that the user accesses from an external source. The system extracts from the string all substrings that contain a certain key string and each such substring becomes a new Group for this Project unless the Group was already added before. Field B, the IP Address of the user who added this Group, is filled in automatically. The user can also click on buttons to go to screens 5, 7 or 8. 7. Add User Records: This contains the same contents as screen 6 to allow the user to Add Groups, plus also allows the user to add his User record to any Groups. Below the contents that are the same as screen 6 is a list of all Groups field value A in the Project that meet two conditions: (a) the Group has no User record with this user's IP Address, and (b) the Group has less than the Project field D number of User records (different IP Addresses) from any users. When a button next to each Group is clicked, an image is accessed from the internet based on the Group field value A and is displayed in a new screen. Below each Group are boxes to enter a User record fields B, C, D and E. Fields B and C are required. This is his User record based on his IP Address. Each Group of each Project has these 4 fields for each IP Address that visits this screen. The user can enter in any User records then click on a button to save all of them. The list will display again except the Groups for which he entered in his User record will no longer be listed, because of condition (a) that it is a list of all Groups with no User record with his IP Address. 8. View Groups: The Project's A and B values are displayed. Below that is a list of all Groups that this Project has which have any User records. When a button next to each Group is clicked, an image is accessed from the internet based on the Group field value A and is displayed in a new screen. The list is initially displayed sorted by [c] which is one of 3 possible values: a. The value of the Group field A. b. The average User field B value, where each is 1 to 5, translated to the closest choice. c. The average User field C value, where each is 1 to 60, translated to the closest choice. The user can click on two buttons to change the sort to the two other fields. There should be a way to include Goggle Ads or any other ads that relate to the Subject, Topic and Project field value. Inappropriate Content (Screens 9-11) Screens 3, 5 and 6 have a button to jump to screen 9. For all Projects being displayed, screen 9 lists Project fields A, B and C. The user can click on a button next to each Project to report that the content is inappropriate. Screens 7 and 8 have a button to jump to screen 10. Screen 10 lists the Groups that were being displayed and for each the user can choose one of 3 types of inappropriate content. Screen 11 lists all instances of Inappropriate Content reported, listing the same fields that were displayed when the user indicated that it is inappropriate on screen 9 or 10. It also allows me to reinitialize this display to empty. Next to each instance of inappropriate context is a button that if I click then the IP Address when the inappropriate context was entered is banned from this site and a box lets me enter a text reason why I banned them. Any access by a banned IP Address displays a blank screen. This screen also lists all banned IP Addresses and allows me to remove any IP Address from the list. Screen Access Statistics (Screen 12) Each time screen 1 through 8 is visited, the screen number and one of 4 variables is recorded as follows: Screen 1: Source used to get here. Screen 2: Subject Screens 3,4,5: Subject . Topic Screens 6,7,8: Project Screen 12 lists each of the 4 variables in a separate table of rows and columns as follows. Each row except the bottom one represents a value of the variable and the bottom one represents the total. The first column contains the value of the variable (source, subject, [login to view URL] or project) or "TOTAL". For each screen that was visited with this variable there is a column that contains the number of visits. The last column on the right is the total visits to that variable value with the total number of screen visits in the lower right hand corner. The top of each column has the screen number or "TOTAL" except for the first column on the left. So it's variable down the left side, screen number across the top, number of visits in the cell, and the last row and column are totals. System Parameters (Screens 13-16) Screen 13 allows me to add, delete and edit the Subjects and their Topics, including their pictures. A Subject or Topic cannot be deleted if it has any Projects. Screen 14 allows me to choose a Project, display its fields, and delete or suppress it. If deleted it is totally removed from the database. If suppressed it remains but appears only in this lookup. Screen 15 lists user feedback and allows me to reply to their email address or delete the user feedback. If someone (me) tries in screen 4 to add a project with field A equal to *csv* followed by the current day number, month number and year past 2000 e.g. *csv*41212 then it jumps to screen 16 which asks which of screens 11 to 15 to display, or to go back to screen 3. It also lets me change the *csv* to another value that is checked as field A. *csv* is just the initial value when installed. *Confidentiality Agreement* [PERSON] of [COMPANY] of [LOCATION] ("COMPANY") and Charles Volkstorf of Cambridge, Massachusetts ("CUSTOMER"), in conjunction with an ongoing business relationship between the two parties, hereby agree to the following: 1. COMPANY will create specifications, technical designs, computer software and other written, printed or electronic material ("the PRODUCT") solely for the benefit of CUSTOMER as part of his business relationship with CUSTOMER. The PRODUCT is considered work made for hire and CUSTOMER receives exclusive and complete ownership of PRODUCT and all copyright, patent, trade secret and other proprietary rights to the PRODUCT. 2. CUSTOMER will convey confidential and proprietary specifications, technical designs, computer software and other written, printed or electronic material ("the INFORMATION") to COMPANY in pursuance of his developing the PRODUCT. CUSTOMER retains ownership of INFORMATION and all copyright, patent, trade secret and other proprietary rights to the INFORMATION. 3. COMPANY will use the INFORMATION only to produce the PRODUCT for CUSTOMER and will not disclose the INFORMATION to any third party other than his employees who need to know it to produce the PRODUCT and who have been informed of COMPANY's obligations under this agreement. COMPANY will not create or help others to create another computer software system that provides functionality or capabilities the same as or similar to that provided by the PRODUCT or described in the INFORMATION. Agreed By: _________________ _______________ [PERSON] Charles Volkstorf _____________ _____________ Title Title _____________ _____________ Date Date