I have Just been asked to set up a database, and all the details I received are listed below. I have never attempted a Web based application, and I need to know if I can use my existing Alpha 5 version 9, to make and then upload the application, if I manage to put it together.
I would also really appreciate any comments about the difficulty this challenge might offer, and my chief concern is with the last paragraph,
This is all the information I have for the project at this point, but my main question is whether i need to upgrade to a newer version, than I have at present.
-----------------------
User table
UserID | UserName | password | Security question | Security Answer
Business table
BizID | UserID | Business Name | BizCategory | Short Description | Profile Link
Category table
CatID | Category | Type (Parent, or if sub cat, then category this sub category is listed under)
Detail table* **
DetailID | BizID | Long Description | Image Link | Webpage | UNewsPaidTo* | SammiesListPaidTo**
Comments/Ratings Table
CommentID | UserID | BizID | Rating | Comment | BizOwnerResponse
This is rudimentary, based on what I did years ago with a PHP/MySQL database. With that in mind, let me ramble on about how it would work.
Administrators would be able to add data to any table. The detail table and Category table would be exclusively for the Administrators. Would like to see it set up so we can add by the business, and it would automatically add to the other tables as well. For example, if we add:
Business Name: UNews
Owner: BiTraci_UNews
Category: Other � Media
Short Description: UNews is a newspaper covering events, people and places.
This would populate the business table, and also create the user in the user database, with a generic password. If the person in question later wanted to modify the information themselves, they could reset the password, and the new temporary password would be sent to their email address(if possible).
Users can also submit their businesses themselves, by creating a user name and password, and then submitting the information.
Users would be able to register at the site, and make comments on businesses listed, as well as rate the businesses. If they so choose, business owners could respond to any comments, and would have the right to request that inflammatory comments be removed, if they are without merit, at a maximum of 1 comment removal per calendar month. Users would also rate the businesses, from one to five stars along with the comments, or they could simply rate the business without commenting.
I would also really appreciate any comments about the difficulty this challenge might offer, and my chief concern is with the last paragraph,
This is all the information I have for the project at this point, but my main question is whether i need to upgrade to a newer version, than I have at present.
-----------------------
User table
UserID | UserName | password | Security question | Security Answer
Business table
BizID | UserID | Business Name | BizCategory | Short Description | Profile Link
Category table
CatID | Category | Type (Parent, or if sub cat, then category this sub category is listed under)
Detail table* **
DetailID | BizID | Long Description | Image Link | Webpage | UNewsPaidTo* | SammiesListPaidTo**
Comments/Ratings Table
CommentID | UserID | BizID | Rating | Comment | BizOwnerResponse
This is rudimentary, based on what I did years ago with a PHP/MySQL database. With that in mind, let me ramble on about how it would work.
Administrators would be able to add data to any table. The detail table and Category table would be exclusively for the Administrators. Would like to see it set up so we can add by the business, and it would automatically add to the other tables as well. For example, if we add:
Business Name: UNews
Owner: BiTraci_UNews
Category: Other � Media
Short Description: UNews is a newspaper covering events, people and places.
This would populate the business table, and also create the user in the user database, with a generic password. If the person in question later wanted to modify the information themselves, they could reset the password, and the new temporary password would be sent to their email address(if possible).
Users can also submit their businesses themselves, by creating a user name and password, and then submitting the information.
Users would be able to register at the site, and make comments on businesses listed, as well as rate the businesses. If they so choose, business owners could respond to any comments, and would have the right to request that inflammatory comments be removed, if they are without merit, at a maximum of 1 comment removal per calendar month. Users would also rate the businesses, from one to five stars along with the comments, or they could simply rate the business without commenting.
Comment