Data Design Final 2011
Classified site. The website should by able to host classified posts by category by location. The posts should be readable by everyone but only people with accounts should be able to post. The the most current x number of posts should show in a location/category. A user should be able to edit their own posts but not others posts. Admins can edit everyone posts. Admins can also edit categories and location.
Optional (extra credit) posts have pictures. Posts use a rich text editor.
Site Skeleton
Default Page
- Show Cities and Categories
Posts Page
- Shows Posts by City or Category
New User
- Add a new User to the
Logon
- Check user name and password
Protected Pages New Post
- People post new posts in a city and a category
Admin\Categories
- Create Update Delete Categories
Admin\Cities
- Create Update Delete Cities
Admin\Edit posts
- edit posts
UserName PostTitle PostDetail PostCategory CityName RecCreationDate
People
PeopleID
UserName
Password
IsAdmin
Post
PeopleID
PostTitle
PostDesc
PostCategoryID
CityID
RecCreationDate
PostCatetgories
PostCategotyID
PostCategoryName
City
CityID
CityName