Web Technology Assignment Help

This is a solution for Web Technology Assignment Help

Key-Value Databases

Formally a Key Value database is a database which is create without using structured query language, uses an associative array as a basic data model. In Key value databases where only one value is linked to the every single key into the database. It doesn’t use any query languages. So the key values store uses get, put and delete commands to store the data, retrieval of the data and for updating f the data. Due to simplicity of the key value store it makes the key value store very fast and also easy to use. It has several advantages like scalable Portable and also flexible. Next generation database has several mostly addressing points like non relational, distributed, open source and horizontally scalable. There are several resources of the Key value database available like Hadoop/Hbase, Cassandra, Hypertable and cloud Data.

  • Hadoop/Hbase- Hbase provides random and real time based read/write control access over the Big Data. It can be capable to host billions of rows and millions of column. It is an open source means no charges can be paid for using this, multiple versioned, non relational databases.
  • Cassandra – This database provides better scalability and high availability with maintaining its performance. It is also used for mission critical data. It offers strong support for denormalization and materialized views.
  • Hypertable- This database is of high performance, open source means freely available, and big size of database will be easily scalable.
  • Cloud Data- we can say that this database if for everyone means it provides large scale structured Data storage. This is also a free and open source database resource.

As per getting the brief understanding of key value database on to the basis of above four mentioned resources we find that there are lots of advantages and challenges will be occurred into between both of the databases which are as follows.

Advantages of Key value database

S.No. Key value database Relational database
1 Key value database is may scale out easily and store more and more data. It includes billions of rows and millions of columns. RDBMS may not scale out easily on commodity clusters.

 

2 It can be store great volume of data without facing any tolerance. As the database increases it faces tolerance as maintenance of database, portability, and also price will be high.
3 The databases created under key value database system are able to store and process very large amount of files/information which is distributed over several machines. Change in management of data/files and management of and process of larger files is bigger headache for RDBMS.
4 The majority of data in enterprise system is unstructured way and it is capable to maintain unstructured text and so increases information and help enterprise to take and make better decisions. It only stored data/files in structured way using structured query language.

Limitation of key value databases

S.No. Relational database management system Key value databases
1 All the information is stored, retrieve and update is done using the SQL. All the information is arranged systematically so the retrieval of information is fast as compare to key value database. It has no features like structured query languages. So retrieval of information on real time is not easy.
  It creates databases for a long time and provides an updated backup files support to the every corporation in their own system. The database which is created is for a limited period.
  It provides ACID properties like consistency, durability etc. Consistency and disability properties are not found in Key value Databases.

Read more about Information Technology Assignment Help

 Initial Data Details

In this individual assignment we have to develop a dynamic web application as described below using PHP, MySQL, JavaScript and CSS.

  • We have to create Database using the SQL on to the server which consist three tables, after that connect that database with the web database application.
  • We have to generate data file for initial password using md5 () PHP or My SQL function and later we have to use PHP password hash () or crypt functions.
  • We have to develop a web application that will ask email/username to tutor and a password from the guest.
  • After fulfilling the entire requirement we have to cross check the created database using a query through the command line.
  • We have to create a page using PHP and CSS that will displays a list of movies so that whenever a user clicked on specific movies then they will be redirect to the movie review page.
  • We have to use JavaScript to validate the input, enforcing that the comment field is at least 10 characters in length.
  • We have to write PHP code to add the review to the database.
  • We have to create a signup page to for the reviewers where they must have to fill their name, email address and passwords and reviewers should be capable to login and logout at every time.
  • We have to design movie review page using condition that whenever a movie get 3 reviews then it will display on the top of the this page. Average is calculated using SQL query.
  • The page of movie list must have to contain three reviews with the reviewers in increasing order.

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 1 movie list data

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 2 review data

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 3 reviewer data

The query used to test your database

To test the developed database I have generated some SQL queries. First of all we have to get detail about how many approach is available in Sql to test a Database. Generally SQL query uses” SELECT” command to develop test over the database. Read more about PHP Assignment Help

Select*from <tablename> where <condition>

The three most important of commands are as follows:

  1. DDL : Data definition language

Syntax:

  • Create table: Create table<tablename> (field1 datatype(field size) ,……………..fieldn datatype(field size))
  • Delete entire table: Drop table <tablename>. – this command cannot be rolled back
  1. DML: Data manipulation language

Syntax:

  • To insert a row into a DB: INSERT INTO <table name> (field1, field2, field3)  VALUES  (‘val1’, ‘val2’…’valn’);
  • Delete specific row/rows from a table: DELETE FROM TABLENAME WHERE <required condition>.
  • Update rows: UPDATE <tablename> SET field1 = ‘updated value’ WHERE field2 = ‘N’;
  1. DCL: data control language

Syntax:

  • Grant syntax:
    Grant select/update
    On <table name>
    To <user id1, user id2…useridn>;
  • Revoke syntax:
    Revokeselect/update
    on <table name>
    from<user id1, user id2…useridn>;

Read more about Computing and System Development Assignment 

Review Table

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 4 Review table

  • Test Review Table

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 1.2 Test Review table

  • Movies List

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 5 Movies list

  • Reviewer Table

Web Technology Assignment Help, programming assignments help, android assignment help, assignment help, database assignment help

Figure 6 Reviewer table

A list of parts of the assignment that we have completed or not completed

  • We have created Database design using the SQL on to the server which consist three tables, after that connect that database with the web application.
  • We have generated data file for initial password using md5 () PHP or My SQL function and later we have to use PHP password hash () or crypt functions.
  • We have developed a web application that will be asked email/username to tutor and a password from the guest.
  • We have cross check the created database using a query through the command line.
  • We have created a page using PHP and CSS that will displays a list of movies so that whenever a user clicked on specific movies then they will be redirect to the movie review page.
  • We have to use JavaScript to validate the input, enforcing that the comment field is at least 10 characters in length.
  • We have written PHP code to add the review page to the database.
  • We have created a signup page to for the reviewers where they must have to fill their name, email address and passwords and reviewers should be capable to login and logout at every time and also apply validation rules on it.
  • We have designed movie review page using condition that whenever a movie get 3 reviews then it will display on the top of the this page. Average is calculated using SQL query.
  • The page of movie list must have to contain three reviews with the reviewers in increasing order.
  • We have used the radio button to giving a review to for a movie and the movie that will get minimum 3 reviews then it will be popped on the top of the movies list.

Details of specific assistance

We have successfully completed this assignment using PHP, CSS and MySQL. To complete this assignment I have taken help from my lecturer who has detailed knowledge about these web design and development of database development tools and techniques. He has taught me how to create a form using PHP, how to apply validation using Java Server page, how to apply validation on login and password using md5 () tool.

References

sarathi, Partha. “A Deep Dive Into Nosql: A Complete List Of Nosql Databases”. Big Data Made Simple – One source. Many perspectives.. N.p., 2014. Web. 27 Aug. 2016.

Fowler, Adam. “10 Advantages Of Nosql Over RDBMS – Dummies”. dummies. N.p., 2016. Web. 27 Aug. 2016.

ISSAC, LUKE P. “SQL Vs Nosql Database Differences Explained With Few Example DB”. Thegeekstuff.com. N.p., 2016. Web. 27 Aug. 2016.

Buckler, Craig. “SQL Vs Nosql: The Differences”. SitePoint. N.p., 2015. Web. 27 Aug. 2016.

Read more about Assignment Help Australia 

Top Grade Assignment help provide technical assignment writing service based on case study requirements in affordable prices and we are providing most flexible online assignment writing help, so book your Assignment with us, order now

 

About the Author

Alice