Sample QuestionS Imagine that you are using Node.js to create a blog for your company. The blog posts are stored in a MySQL database described below, where each line shows a table with its properties,...

1 answer below »
Its an online exam


Sample QuestionS Imagine that you are using Node.js to create a blog for your company. The blog posts are stored in a MySQL database described below, where each line shows a table with its properties, TableName(column1, column2, …), and the primary and foreign keys are underlined. The first column in each table is a primary key and other underlined column names are foreign keys referring to the column with the same name in another table. blog (id, userid, blogtext) user(userid, username, email) i. What is the name of the table that stores blog posts? Answer 8 [2] ii. Write a SQL query to list all blogs. Answer [2] iii. What is the association type between the blog table and the user table? Answer [2] iv. Complete the below code to list all blog posts and related information. [4] Make sure you use space character when it is absolutely necessary and remove all unnecessary spaces from your short answers. app.get('/list', function(req, res) { let sqlquery = "Answer "; db.query(sqlquery, (err, result) => { if (err) { res.redirect('./'); } Answer .send(result) }); }); v. You need to complete the part of the app that will allow users to add/edit/delete/read their blog posts. Complete the piece of code below. [10] ... Which one of the following data types are suitable for SQL databases? Select one: a. unstructured data b. rapidly changing structure c. structured data d. semi-structured data Clear my choice Instructions please this a clear instruction from thr lecturer This paper is in two parts: part A and part B. You should answer ALL questions from part A and ALL questions from part B. There are THREE sections in PartB. Part A carries 40 marks, and each section from part B carries 20 marks. The marks for each part of a question are indicated at the end of the part in [.] brackets. There are 100 marks available on this paper. Part A quiz is timed for 2 hours and Part B quiz is timed for 3 hours. Should you have any technical issues please report your issues using this form as soon as possible. You will not receive a response but it will be considered during the exam board.
Answered 1 days AfterMay 17, 2021

Answer To: Sample QuestionS Imagine that you are using Node.js to create a blog for your company. The blog...

Swapnil answered on May 19 2021
150 Votes
84447/part a.jpg
84447/part b.jpg
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here