EKTA ACADEMY
1.
2.
3.
4. The project file must contain a Table of Contents, Acknowledgement, and a Cover Page mentioning the project title, student’s name, roll number, and academic year.
[ Note: The cover page, acknowledgement, and table of contents should be printed, while the rest of the project should be handwritten as per the instructions provided above. ]
**All students are required to submit the project before 25 Falgun 2082 B.S.
Late submissions will not be accepted and will negatively impact internal evaluation, leading to low marks in internal assessment.
Unit-1: Database Management System (DBMS)
Define the following terms:
- Data
- Information
- Database
- DBMS
- List the advantages and disadvantages of DBMS.
- Explain the following database models with examples:
- Hierarchical Model
- Network Model
- Relational Model
- Differentiate between centralized and distributed database systems.
- What is normalization? Explain the normalization process up to Third Normal Form (3NF) with examples.
- Write short notes on:
- Data Dictionary
- Keys in DBMS (Primary Key, Foreign Key, Candidate Key, Alternate Key, Composite Key)
- SQL (Structured Query Language)
- Data Security and its importance in DBMS
Unit-2: Data Communication and Networking
- What is a computer network? Explain its advantages and disadvantages.
- Define network topology. Explain the following types with diagrams:
- Bus Topology
- Star Topology
- Ring Topology
- Mesh Topology
- Hybrid Topology
- Differentiate between LAN, MAN, and WAN.
- Define network architecture. Differentiate between client-server and peer-to-peer networks.
- What is transmission media? Explain:
- Guided Media (Twisted Pair, Coaxial Cable, Fiber Optic Cable)
- Unguided Media (Radio Waves, Microwaves, Infrared)
- Explain the OSI reference model and its seven layers with their functions.
Unit-3: Web Technology II
- What is JavaScript? Explain its features and applications.
- Differentiate between client-side scripting and server-side scripting.
- Explain event handling in JavaScript with an example.
- What is a JavaScript function? Explain function declaration and calling with examples.
- What is jQuery? Explain its features and advantages.
- What is PHP? Explain its advantages and applications.
- Explain the following PHP operators:
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- Assignment Operators
Unit-4: Programming in C
- What is a function? Explain:
- Library Functions
- User-Defined Functions
- Define a pointer in C. Explain its usage with examples.
- Differentiate between call by value and call by reference with examples.
- Differentiate between an array and a structure.
- Differentiate between a structure and a union with examples.
- What is file handling in C? Explain:
- fopen()
- fclose()
- Differentiate between an array and a pointer.
Unit-5: Object-Oriented Programming (OOP)
- What is OOP? Explain its advantages and disadvantages.
- Explain the features of OOP:
- Encapsulation
- Inheritance
- Polymorphism
- Abstraction
- Differentiate between OOP and structured programming.
- Explain the applications of OOP.
Unit-6: Software Process Model (SPM)
- What is SPM? Explain the phases of SDLC.
- Why is SDLC important in system development?
- Explain SDLC models with merits and demerits:
- Waterfall Model
- Agile Model
- Spiral Model
- Prototype Model
- What is a feasibility study? Explain:
- Technical Feasibility
- Economic Feasibility
- Operational Feasibility
- Explain system design tools:
- Data Flow Diagram (DFD)
- Entity Relationship Diagram (ERD)
- Explain testing techniques:
- Unit Testing
- Integration Testing
- System Testing
- Acceptance Testing
- Differentiate between a system analyst and a software engineer.
Unit-7: Recent Trends in Technology
- What is Artificial Intelligence (AI)? Explain its impact on modern society.
- Explain the concept of Big Data and its types.
- What is E-commerce? Explain its advantages and disadvantages.
- What is mobile computing? Explain its features and applications.
- Define the following:
- M-commerce
- Robotics
- E-Learning
- Virtual Reality
- Social Media
- Internet of Things (IoT)
- E-Governance
- Cloud Computing
JavaScript and PHP Programs
- Write a program to JavaScript that illustrate event handling.
- Write a JavaScript to display 1 to 10 using for loop, while loop, and do-while loop.
- Write a JavaScript program to calculate the factorial of a given number.
- Write a JavaScript program to input three numbers and find the largest one.
- Write a program to input any three numbers and find the average in JavaScript.
- Write a program to find area and circumferences of circle in JavaScript.
- Write a program to display all even number from 1 to 100 in JavaScript.
- Write a program to sum of two number using function.
- Write a program to input any number and find its reverse order in JavaScript.
- Write a program to display the Fibonacci series. 1 1 2 3 5 8 13 ……n in JavaScript.
- Design a form with username, address, e-mail, password, and submit button.
Validated the form using JavaScript. - Write a PHP program to check if a string is a palindrome or not.
- Write a PHP code to enter any two number and display their sum, difference and product.
- Write a PHP code to find out area and perimeter of rectangle.
- Create a registration form including Name, Address, Phone No., email address, Qualification, Gender and Country and get the values entered by user using post method and display.
- Write a program in PHP to display all the even numbers from 1 to 100.
- Write a program in PHP to input a number and check it is odd and even.
- Write a program in PHP to display the multiplication table of a number.
- Write a program in PHP to input a number and find its Armstrong or not.
- Write a program in PHP to find the factors of an input a number.
C Programming Programs
- Write a C program to count the number of employees:
- Aged 60 or above
- Aged below 35
- Write a program to input any three numbers and find out which one is the largest number using user defined function.
- Write a program to display the day using the switch statement depending upon the number entered. i.e. input 1 for Sunday, 7 for Saturday using user defined function.
- Write a program to input a number and check whether it is prime or not using function.
- Write a program to display the sum of even and odd numbers from 1 to 50.
- Write a program to enter elements for 3x3 matrixes and Display its sum.
- Write a program to accept 10 different numbers in an array and sort them in descending order.
- Write a program to input a number and find out whether that number is palindrome or not using function.
- Write a program to input the names of N numbers of students and sort them in alphabetical order.
- Write a program to read a number and make the sum of individual digits and print using the recursion technique.
- Write a program that reads different names and address into the computer and rearrange the names into alphabetical order using the structure variables.
- Write a program to read N students' records store them in the data file and display the content inappropriate format by using the fprintf and fscanf function.
- Write a program to calculate the factorial of given number using recursive function.
- Write a program to input radius of circle and find area and circumference of circle.
- Write a program to input any two number and find HCF and LCM using function.
- Write a program to store employee id, name and salary of 100 employee. The program should them display the record of employee in appropriate format whose salary is greater than 50,000 using structure.
- Write a program to display the greatest number among three numbers using pointer.
- Write a program to store Roll number, Name and class of 50 students in a file "student.txt".
- Write a program to input any 10 number in array and find the largest number using among them.
- Write a program to keep the record of students and calculate total and percentage and display all records.
- Write a program to read the marks of any 5 students in a subject and count how many students are pass or fail.