{"id":617,"date":"2015-08-17T10:03:45","date_gmt":"2015-08-17T10:03:45","guid":{"rendered":"http:\/\/assignmenttask.com\/tutorhelp\/?p=617"},"modified":"2022-10-13T05:01:23","modified_gmt":"2022-10-13T05:01:23","slug":"world-wide-web-technology-with-individual-assignment","status":"publish","type":"post","link":"https:\/\/assignmenttask.com\/tutorhelp\/world-wide-web-technology-with-individual-assignment\/","title":{"rendered":"World Wide Web Technology With Individual Assignment Help"},"content":{"rendered":"

CRICOS Provider No. 00103D Insert file name here Page 1 of 4
\nITECH3224\/6224 World Wide Web Technology 2
\n1517\/1520 Assignment 1 \u2013 “Microblog”<\/p>\n

Introduction<\/p>\n

This is an individual assignment in which you are required to develop a dynamic web application as described below using PHP, MySQL, JavaScript and CSS.
\nDetails of the weight of the assignment and due date are given in the course description.
\nTask Description
\nApplication
\nFor this assignment, you will create a web-based microblogging platform, similar in functionality to “Twitter”. You will have to come up with your own fancy name.
\nDatabase Structure
\nThe web application uses a relational database to create a micro-blogging platform. The database has the following structure:
\nUser(id, name, email, password) Post(id, user_id, post_date, in_reply_to, text) Follow(user_id, follower_id)
\nEach record in the Post table refers to a single post made by a user. Primary keys are indicated with underlines or bold formatting, and foreign keys are italicized.
\nThe following constraints should be applied in implementing the application:
\n\u2022 The user_id and follower_id fields in the Follow table form a compound primary key, and both refer to the id field in the User table. The user id field should be an integer primary key, and should automatically increment.
\n\u2022 The post_date field may be stored as either strings, or using MySQL datetime types, and must include time as well as date.
\nCRICOS Provider No. 00103D ITECH3224 6224 Assignment 1 1517-1520.docx Page 2 of 4
\n\u2022 The text field in the Post table should be limited to 160 characters.
\n\u2022 The in_reply_to field in the Post table is a nullable foreign key that refers to the id field on the same table. If this field is null, then the post is not a reply to another post \u2013 if it is non-null then the post is a reply to the post with the matching id.
\n\u2022 The password field should be a VARCHAR field of at least 125 characters. The name and email fields should be VARCHAR of a length that you determine to be reasonable and sufficient.
\nInitial data
\nWhen the database is created it should be populated with data of your own invention. Include this data as part of your written report. Each table should have between 3 and 6 records initially.
\nInclude yourself as a user, using your student id as the name, and your real email address. Invent other users as necessary \u2013 perhaps use characters from your favourite movie or band.
\nCreating the database
\nCreate an SQL file that creates a database on the server, creates the three tables above, and populates them with your initial data.
\nPassword data should be hashed using, at minimum, the crypt() PHP function. If available, prefer to use the PHP password_hash() function to generate password hashes. It is acceptable for all initial User records to share the same password for testing. Use of MD5 is not acceptable.
\nInclude a user that can login as \u2018tutor\u2019 with password \u2018guest\u2019.
\nTest your database by writing queries on the command line that display all initial data using SELECT statements, and include the queries in your report.
\nUser accounts
\nWrite an HTML form that allows new users to sign up. The form should request a username, email address and password. The password must be hashed before storing it in the database.
\nUsing PHP, validate that the username is unique, and the password is at least 5 characters.
\nWrite PHP code to allow users to log in and log out. This will require the use of sessions or cookies.
\nGlobal timeline
\nWrite PHP and HTML code to display a list of the last 10 posts from all users, sorted in descending date order \u2013 that is, the most recent posts are at the top. This timeline of posts should be visible to anybody without logging in.
\nIf posts are in reply to another post, include a link to the original.
\nCreating posts
\nLogged-in users should be able to create new posts. Write PHP code to support this. Use both PHP and Javascript to limit the length of the post to 160 characters.
\nFollowing
\nWrite HTML and PHP code to allow logged-in users to follow other users. This should create a new entry in the Follow table. This may require you to create a way to view an individual user, or list of all users.
\nCRICOS Provider No. 00103D ITECH3224 6224 Assignment 1 1517-1520.docx Page 3 of 4
\nUsers who are logged in should see posts only from users that they follow, instead of the global timeline. This list should again be limited to the last 10 posts.
\nReplying
\nCreate a link on each post that allows a logged-in user to reply to a post. This should allow them to create a new entry in the Post table, with the in_reply_to foreign-key field set appropriately.
\nAggregate data
\nComplete the following using SQL aggregation such as COUNT and SUM, subqueries or nested SELECT statements, inner joins and (left or right) outer joins.
\n\u2022 Create a page that contains a list of the top 10 most-followed users, with their number of followers ordered in descending order. Similarly create a page that contains a list of the top 20 most popular posts by number of replies.
\n\u2022 For each post in the timeline that has replies, display the number of replies with the post.
\n\u2022 Display the number of posts that have been made in the last 24 hours at the top of the global timeline.
\nAdditional task for ITECH6224 Students
\nOn the topic of \u201cDatabase Sharding\u201d identify four (4), relevant, independent resources. Use these resources to write a discussion of the advantages and limitations of database sharding, where it is appropriate to use, and alternatives. Write this in your own words, and take care to cite appropriately. Word count should be about 500 words.<\/p>\n

Note: Wikipedia is not a suitable resource, but may be used to get an overview of the subject
\nFurther details
\nDocumentation
\nInclude a written report containing:
\n\u2022 Initial data details
\n\u2022 The SQL queries you used to test your database
\n\u2022 A list of parts of the assignment you have completed or not completed.
\n\u2022 Details of specific assistance you received from people other than your lecturer or tutor, and the names of those assisting.
\nAssignment support
\nThis assignment is supported by the first 5 lectures and the first 6 labs. Work on the assignment should be spread over a number of weeks after the relevant lab has been mastered.
\nRefer to the Course Description for details of submission to Moodle, late assignments, extensions, special consideration, plagiarism, student support, presentation of academic work and adopted reference style.
\nSubmission
\nAll files should be zipped and uploaded to Moodle by the due date and time. Check with your tutor as to whether a hard copy is required in addition to the electronic submission.
\nCRICOS Provider No. 00103D ITECH3224 6224 Assignment 1 1517-1520.docx Page 4 of 4
\nITECH3224\/6224 World Wide Web Technology 2
\nAssignment 1 Marking Guide
\nName ID Marker
\nCriterion
\nMaximum
\nObtained
\nInitial data \u2013 Requirements satisfied
\n1
\nCreating the database: Table structure, data types, field lengths, initial data entry
\n1
\nUser accounts
\n– Sign-up form is well designed and functional
\n– Server-side validation or username and password
\n– Appropriate password hashing
\n3
\n1
\n1
\n1
\nGlobal timeline
\n– Most recent 10 posts listed in descending order.
\n2
\n2
\nCreating posts
\n– Users can create new posts
\n– Use of PHP and JavaScript to limit post length
\n2
\n1
\n1
\nFollowing and Replying
\n– Logged-in users can follow others, and see only posts from those they follow
\n– Users can reply to other users’ posts
\n3
\n2
\n1
\nAggregate data
\n– Most followed, most popular posts
\n– Replies per post, total in last 24 hrs
\n3
\n1
\n2
\n–
\nWritten task (ITECH6224 only)
\n– Content
\n– Writing style
\n– Adherence to academic standards
\n5
\n3
\n1
\n1
\nDocumentation
\n– Initial data
\n– Completion of tasks
\n– Assistance statement
\n3
\n1
\n1
\n1
\nQuality of code \u2013 layout, naming scheme, etc. HTML is valid
\n2
\nTotals
\n– ITECH3224
\n– ITECH6224
\nFinal scaled mark (correct to 1 decimal place)
\n20
\n25
\n20
\nComments:<\/p>\n

\"Assignment<\/a><\/p>\n

 ===========ABOUT ASSIGNMENT TASK<\/strong> ===========<\/p>\n

 AssignmentTask.com<\/strong><\/a> provides high-quality assignments help<\/a> at wide range from Australia \u2013 UK & USA academic experts and also guarantees to make sure delivery assignments on time @ reasonable rate. OUR ASSIGNMENT EXPERT WRITERS MAKES EFFORTS TO DELIVER BEST QUALITY ASSIGNMENT HELP, <\/strong><\/em>ESSAY HELP<\/strong><\/a>, CASE STUDY HELP AND DISSERTATION EDITING HELP<\/strong><\/em> on each Order. 100% satisfaction is our primary motto. Our customers get 24 x 7 hours live chat supports.<\/p>\n","protected":false},"excerpt":{"rendered":"

CRICOS Provider No. 00103D Insert file name here Page 1 of 4 ITECH3224\/6224 World Wide Web Technology 2 1517\/1520 Assignment 1 \u2013 “Microblog” Introduction This is an individual assignment in which you are required to develop a dynamic web application Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[305],"tags":[451,479,363,485,486,487,453,488,283,452],"class_list":["post-617","post","type-post","status-publish","format-standard","hentry","category-science","tag-assignment-help-tasks","tag-computer-science","tag-federation-university","tag-germany","tag-heidelberg","tag-itech32246224-world-wide-web-technology","tag-sample-assignment-report","tag-science-tech","tag-undefined","tag-writing-assignment-topics"],"_links":{"self":[{"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/comments?post=617"}],"version-history":[{"count":3,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/posts\/617\/revisions"}],"predecessor-version":[{"id":1020,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/posts\/617\/revisions\/1020"}],"wp:attachment":[{"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/media?parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/categories?post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttask.com\/tutorhelp\/wp-json\/wp\/v2\/tags?post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}