DD Blog Project
esse quam videri
Using the tables we built in class. Create a public blog roll page where people can view messages posed to the blog. If a user is authenticated then they can post blogs or edit moods. We will be hard coding usernames and passwords this week.
The blog interface requires
- Mood editor page allows you to add and edit moods in the database. Protected by authentication
- A Post to the blog page. Protected by authentication hard code user names.
- A blogroll display page. Be careful which control you use to display the data. Should be publicly accessible no authentication.
The post page should allow people to type in their name (first and last or just first if you like) and post a message. The People table will hold a list of names. If the Posters name doesn't exist then we will INSERT it into the table if it does we should not INSERT it again.
Tables that Follow First normal form
Blog2
| BlogID ((PK) int) | BlogText (varchar(8000)) | recCreationDate (DateTime) | PeopleID int | MoodID int |
|---|---|---|---|---|
| 1 | Blog1 | 03/30/03 | 1 | 1 |
| 2 | Blog2 | 03/30/03 | 1 | 1 |
| 3 | Blog3 | 03/30/03 | 2 | 3 |
| 4 | Blog4 | 03/30/03 | 1 | 2 |
| 5 | Blog4 | 03/30/03 | 3 | 1 |
Mood
| MoodID ((PK) int) | MoodName (varchar(50)) |
|---|---|
| 1 | Happy |
| 2 | Sad |
| 3 | Mad |
| 4 | Afraid |
People
| PeopleID ((PK) int) | PersonName (varchar(50)) | recCreationDate (DateTime) | active (bit) |
|---|---|---|---|
| 1 | Jeff | 10/31/08 | 1 |
| 2 | Sallie | 10/31/08 | 1 |
| 3 | Gary | 10/31/08 | 1 |
| 4 | Sue | 10/31/08 | 1 |
