Question

Part A) 20 Points Create within MYSQL a database called assignment. Create within this database the table posts that will store topic, data and timestamp of user-generated posts. Part B) 50 Points Develop for the nodejs platform a post method that accepts 2 parameters (topic and data) and saves them together with a timestamp (date and time) in a MySQL database table called posts (this table should be in the database assignment). Please make sure to create the database and table before developing the nodejs code. To simplify your task you may use the npm modules mysql, express and body-parser. No other libraries are to be used. Obviously, you are free to use any standard nodejs module. Part C) 20 Points Develop a webpage called posting.html that allows a user to see all posts, and allows the creation of new posts. Allow the user to decide if the posts should be ordered according to topic or time in ascending or descending order. No javascript libraries are allowed for this part.

          Part A)
20 Points
Create within MYSQL a database called assignment. Create within this database the table posts
that will store topic, data and timestamp of user-generated posts.
Part B)
50 Points
Develop for the nodejs platform a post method that accepts 2 parameters (topic and data) and
saves them together with a timestamp (date and time) in a MySQL database table called posts
(this table should be in the database assignment). Please make sure to create the database and
table before developing the nodejs code. To simplify your task you may use the npm modules
mysql, express and body-parser. No other libraries are to be used.
Obviously, you are free to use any standard nodejs module.
Part C)
20 Points
Develop a webpage called posting.html that allows a user to see all posts, and allows the
creation of new posts.
Allow the user to decide if the posts should be ordered according to topic or time in ascending
or descending order.
No javascript libraries are allowed for this part.

Part A)
20 Points
Create within MYSQL a database called assignment. Create within this database the table posts
that will store topic, data and timestamp of user-generated posts.
Part B)
50 Points
Develop for the nodejs platform a post method that accepts 2 parameters (topic and data) and
saves them together with a timestamp (date and time) in a MySQL database table called posts
(this table should be in the database assignment). Please make sure to create the database and
table before developing the nodejs code. To simplify your task you may use the npm modules
mysql, express and body-parser. No other libraries are to be used.
Obviously, you are free to use any standard nodejs module.
Part C)
20 Points
Develop a webpage called posting.html that allows a user to see all posts, and allows the
creation of new posts.
Allow the user to decide if the posts should be ordered according to topic or time in ascending
or descending order.
No javascript libraries are allowed for this part.

Added by Jonathan N.

Question

Please give Ace some feedback