1
ITC3150
Database Websites
Signature Assignment
Purpose of Assignment
The signature assignment will leverage all of the skills learned (as outlined below in the course
outcomes section) during the course to create a working PHP-MySQL-based blogging website.
Program Student Learning Outcomes:
Course Outcomes
1. Explore contemporary tools in developing database websites
2. Develop web pages using PHP syntax for basic programming structures ( i.e. conditionals, iterations,
a
ays, functions, objects etc. )
3. Connect to and maintain data in a relational database Design and implement forms and controls
that demonstrate an awareness of user-centered design
4. Access and manage file I/O from PHP pages
5. Handle exceptions, including user data entry e
ors appropriately
6. Authenticate users and manage user sessions in a PHP application
7. Demonstrate an awareness of security best practices in PHP development
Assignment Description
.
A blogging database will be provided as outlined in the ERD below
2
The entities in the DB are
- Users
- Posts
- Tags
The relationships are
- 1:M A user may make zero or more posts. A post is made by a single user
- M:N A post may have zero or more tags. A tag can be used by zero or more posts.
Students will have to
1. Install the database in MySQL
2. Create a web application that has the following functionality
a. Allows users to create an account
. Allows users to login
c. Allows administrators to login
d. Allows users to search the database by keywords/authors/tags/dates
e. Allows users to create a new blog entry with attributes:
i. Blog content
ii. Blog date
iii. Blog author
iv. Blog tags
f. Allows users to
owse the blog entries
g. Allows users to display a blog entry
h. Allows users to logout
i. Allows administrators to edit and/or delete a post
Criteria for Success
All functionality will be tested. The test procedure will be posted on Canvas allowing you to test
your solution before submission.
Deliverables
A ZIP of all PHP source files, MySQL database files and required documentation shall be
submitted Canvas.
The MWB (MySQL Workbench) file shall include
1. ERD
2. Views: SQL queries providing required functionality
Some SQL queries will be provided
3
Others will be developed by the student
A framework for the PHP and HTML sources will be developed week by week.
Ru
ic(s)
Criteria
(examples shown
elow)
Above
Standard
100:85 %
Standard
85:70 %
Below Standard
70:0 %
Notes
User Account
Creation
All or some
e
or paths are
coded.
User is able to
successfully create an
account
Code will not
work, e
ors out
Not
implemented
Account Login
All or some
e
or paths are
coded
User is able to
successfully login
Code will not
work, e
ors out
Not
implemented
Search Blog
Entries by Author
Name and also
y Tag
All or some
e
or paths are
coded
User is able to
successfully search by
some or all means
Code will not
work, e
ors out
Not
implemented
Search by
author name
was not
assigned
during the
semester
Create Blog
Entries
All or some
e
or paths are
coded
User can successfully
create a new blog entry
Code will not
work, e
ors out
Not
implemented
Browse Blog
Entries
All or some
e
or paths are
coded
User is able to scroll
through all blog entry
summaries
Code will not
work, e
ors out
Not
implemented
Browse Blogs
was not
assigned
during the
semester
Display Selected
Blog
All or some
e
or paths are
coded
User is able to display the
contents of a selected
log
Code will not
work, e
ors out
Not
implemented
Display blogs
was not
assigned
during the
semester
Logout All or some
e
or paths are
coded
Logout works co
ectly Code will not
work, e
ors out
Not
implemented
Logout was not
assigned
during the
semester
Admin Administrator
is able to
delete a post
Administrator functionality
is provided but with e
ors
Administrator
functionality is
missing