SAC | Web-Task | 2022-23

Greetings from Students' Alumni Cell!

For the next round of the selection process, you are required to complete atleast 3 questions, one from each group i.e, 1 question from each group.

Group A: General Programming Questions

Que. 1

Given an integer n, print all the Armstrong numbers between the range [1,n] (inclusive).
An Armstrong number is a positive n-digit number that is equal to the sum of the nth powers of their digits.
Example : 1^3 + 5^3 + 3^3 = 153
Available languages: C, C++ (without STL), python, JAVA, JavaScript.

Que. 2

Spiral Question: Given an integer n, Make a spiral matrix
Example 1: Input: 5
Output:
1 2 3 4 5
16 17 18 19 6
15 24 25 20 7
14 23 22 21 8
13 12 11 10 9

Example 2: Input 7
Output:
1 2 3 4 5 6 7
24 25 26 27 28 29 8
23 40 41 42 43 30 9
22 39 48 49 44 31 10
21 38 47 46 45 32 11
20 37 36 35 34 33 12
19 18 17 16 15 14 13
Available languages: C, C++ (without STL), python, JAVA, JavaScript.

Group B: Frontend

Que. 3

Clone the following web-page Profile (Destop Version, First Page). and push it in git.
Requirements : HTML , CSS, Frameworks(such as Bootstrap, Materialize, etc.)

Que. 4

Create a web page which is given below using plain HTML, CSS.
You are also allowed to use frameworks like Bootstrap, Material UI. and Make it responsive.

Group C: Backend

Que. 5

SQL | Employee table questions:
Create an employee table according to your understanding on the columns and answer below questions

Write a query to display employees information from emp table where ename start and end with ‘n’
Write a query to display all employees’ information from emp table where employee ename should contain ‘a’ and ‘i’ without ‘e’
Write a query to display all employees information those who are without comm and with sal.
Display all employees information from that job where average sal of job is less than 1200
Display second highest salaried employee/employees complete information from EMP table.
write all the command in single page(txt file,doc,doc) you can also add screenshots in it(not mandatory) and push it in github repositorie

Que. 6

Nodejs Task | Application for the Jobs:
Create a form that asks for Name, Contact Information(can be Email, Phone number), Qualifications, Cover letter, Availability, and assessment aspects for the application and stores the data in MongoDB. Try ensuring the security aspects, so as to keep the credentials like the MongoDB key, secure. Hosting the application on Heroku and making the page responsive would be a bonus.
You can take reference from below, you need not design the same as given in the images, but ensure the availability of the fields mentioned above, Submit button should not work unless all the fields are filled up.

Refrence Materials

you could refer any sources, the ultimate goal is to learning things ^-^, but make sure to be honest in yourself. here are some links.....We suggest to look it up considering you are new to web dev....

HTML and CSS: https://youtube.com/playlist?list=PL4cUxeGkcC9ivBf_eKCPIAYXWzLlPAm6G
Git and Github: https://youtube.com/playlist?list=PL4cUxeGkcC9goXbgTDQ0n_4TBzOO0ocPR
JavaScript: https://youtube.com/playlist?list=PL4cUxeGkcC9i9Ae2D9Ee1RvylH38dKuET
React: https://reactjs.org/docs/getting-started.html
Node: https://nodejs.dev/learn
PHP: https://www.php.net/manual/en/index.php
SQL: https://docs.data.world/documentation/sql/concepts/basic/intro.html

Submission Format

Make respective github repositories to the questions and share the link to the following google document: form
(We strongly encourage you to upload all your program files (appropriately named) and commit all the changes in respective github repositories)

It is advisable to learn and do task in your pace and insure your work depict your learning or via-versa and do submit all your work before deadline.
Deadline: 23:59, 25 July

All The Best!

puravi-238 / sac-web-task-2022-23 Goto Github PK