MAD Study Hub

Home / Past papers / MAD1 End Term / this paper

IIT M DIPLOMA AN1 EXAM ETD1 11 Dec 2022 - 11 Dec 2022

MAD1 End Term32 questions100 marks23 MCQ · 8 MSQ · 1 SADiploma
Elapsed 00:00
Q1MCQ2 marks
Consider the following HTML document with script which is running at the URL http://127.0.0.1:8000, then choose the correct output of the JSON object. question figure Consider the following HTML document with script which is running at the URL http://127.0.0.1:8000, then choose the correct output of the JSON object.
Text of the picture (copyable)
```html
<!DOCTYPE html>
<html>
<body>

<h2>Creating a JSON String</h2>

<p id="demo"></p>

<script>
const txt = '{"name":"Balu", "age":30, "city":"New Delhi"}'
const obj = JSON.parse(txt);
document.getElementById("demo").innerHTML = "Hi\n" + obj.name + 
",\t" + obj.city + "," + obj.age*2;
</script>

</body>
</html>
```
  1. question figure
    text
    Creating a JSON String
    
    Hi Balu, New Delhi,30
  2. question figure
    text
    Creating a JSON String
    
    Hi Balu, 30, New Delhi
  3. question figure
    text
    Creating a JSON String
    Hi Balu, New Delhi,90
  4. question figure
    text
    Creating a JSON String
    Hi Balu, New Delhi, 60
Q2MCQ2 marks
If the given python program is executed using pytest, then identify the status of the test code. question figure If the given python program is executed using pytest, then identify the status of the test code.
Text of the picture (copyable)
File name: test1.py

```python
def dec(x):
    return x-1

def test_answer():
    assert dec(3) == 2
```
  1. passed test1.py test_answer - assert 2 == 3
  2. 2 Failed
  3. 1 passed
  4. Failed test1.py test_answer - assert 2 == 3
Q3MCQ2 marks
Which of the following lines can be used in a template to inherit another base.html template that provides a basic, uniform layout?
  1. {% expand 'base.html'%}
  2. {% include 'base.html'%}
  3. {% extends 'base.html'%}
  4. {% inherits 'base.html' %}
Q4MCQ2 marks
Which of the following routes binds the index() function to the application's root URL and renders the index.html template?
  1. question figure
    text
    ```python
    @app.route('/')
    def index():
        return render_template('index')
    ```
  2. question figure
    text
    ```python
    @app.route('/')
    def index():
        return render_template('index.html')
    ```
  3. question figure
    text
    ```python
    @app.route('/')
    def index():
        return render_template(index.html)
    ```
  4. question figure
    text
    ```python
    @app.route('index.html')
    def index():
        return render_template('/')
    ```
Q5MCQ2 marks
In which of the following options, url_for() function calls will produce URL http://localhost:5000/home?
  1. question figure
    text
    ```python
    @app.route('/home')
    def index():
        return "This is Homepage content"
    
    @app.route('/')
    def homepage():
        return redirect(url_for(index))
    ```
  2. question figure
    text
    ```python
    @app.route('/home')
    def index():
        return "This is Homepage content"
    
    @app.route('/')
    def homepage():
        return redirect(url_for('index'))
    ```
  3. question figure
    text
    ```python
    @app.route('/home')
    def index():
        return "This is Homepage content"
    
    @app.route('/')
    def homepage():
        return redirect(url_for('/home'))
    ```
  4. question figure
    text
    ```python
    @app.route('/home')
    def index():
        return "This is Homepage content"
    
    @app.route('/')
    def homepage():
        return redirect(url_for('home'))
    ```
Q6MCQ2 marks
Read the following statements carefully and mark the correct answer: Statement 1: Continuous integration is the practice of automating the integration of code changes from multiple contributors into a single software project Statement 2: Continuous Delivery refers to automated delivery of “release package” on each successful test
  1. Both statements 1 and 2 are correct
  2. Both statements 1 and 2 are incorrect.
  3. Statement 1 is correct, but statement 2 is incorrect.
  4. Statement 2 is correct, but statement 1 is incorrect.
Q7SA2 marks
Compute the octal representation of the binary number (01000101)2. Note: The answer must be an integer. For ex: If the octal representation is (39)8, then you must write 39 only
Q8MCQ3 marks
Consider the URL given below. https://onlinedegree.com/academics?course=appdev1#week2 Which of the following options correctly describes each component of the URL given above? question figure Consider the URL given below. https://onlinedegree.com/academics?course=appdev1#week2 Which of the following options correctly describes each component of the URL given above?
Text of the picture (copyable)
| URL Component           | Name          |
| :---------------------- | :------------ |
| 1. https                | A. Domain Name |
| 2. onlinedegree.com     | B. Query String |
| 3. /academics           | C. Protocol   |
| 4. ?course=appdev1      | D. Fragment   |
| 5. #week2               | E. Path       |
  1. 1-C, 2-A, 3-D, 4-B, 5-E
  2. 1-C, 2-A, 3-E, 4-B, 5-D
  3. 1-A, 2-C, 3-D, 4-B, 5-E
  4. 1-C, 2-A, 3-B, 4-E, 5-D
Q9MCQ3 marks
Consider the following flask python snippet with all preliminary conditions. question figure Consider the following flask python snippet with all preliminary conditions. If the above program is running in the URL “http://127.0.0.1:8000” then what will be the output for the given URLs in sequence ● http://127.0.0.1:8000 ● http://127.0.0.1:8000/logout ● http://127.0.0.1:8000/home
Text of the picture (copyable)
```python
class User(UserMixin, db.Model):
    id = db.Column(db.Integer, primary_key = True)
    name = db.Column(db.String(30))
    def __init__(self, id, name):
        self.id = id
        self.name = name
@login_manager.user_loader
def firstuser(id):
    return User.query.get(int(id))
@app.route('/')

def index():
    u1 = User.query.filter_by(id = 112).first()
    login_user(u1)
    return current_user.name + 'logged in'
@app.route('/logout')
@login_required
def logout():
    logout_user()
    return 'logged out'
@app.route('/home')
@login_required
def home():
    return "current user is " + current_user.name

def init_db():
    db.create_all()
    new_user = User(112, 'Rose')
    new_user2 = User(113, 'lily')
    db.session.add(new_user)
    db.session.add(new_user2)
    db.session.commit()
if __name__ == '__main__':
    init_db()
    app.run(debug = True)
```
  1. current user is lilylogged outUnauthorized user
  2. Rose logged inlogged outUnauthorized user
  3. Rose logged incurrent user is Roselogged out
  4. lily logged incurrent user is lilylogged out
Q10MCQ3 marks
Which of the following is the correct order of precedence to reflect the effect of style in HTML documents?
  1. internal > inline > external
  2. inline > internal > external
  3. inline > external > internal
  4. external > internal > inline
Q11MCQ3 marks
Which of the following Jinja templates correctly implements a simple if-else statement?
  1. question figure
    text
    ```html
    {% if name %}
        <h1>Hello, {{user_name}}</h1>
    {% else %}
        <h1> What is your name?</h1>
    ```
  2. question figure
    text
    ```html
    {% if name %}
        <h1>Hello, {{name}}!</h1>
    {% else %}
        <h1>What is your name?</h1>
    {% end %}
    ```
  3. question figure
    text
    ```jinja2
    {% if name %}
        <h1>Hello, {{name}}!</h1>
    {% else %}
        <h1>What is your name?</h1>
    {% endif %}
    ```
  4. question figure
    text
    ```html
    {{ if name }}
        <h1>Hello, {%name%}!</h1>
    {{ else }}
        <h1>What is your name?</h1>
    {{ endif }}
    ```
Q12MCQ3 marks
A template named userinfo.html contains the following line inside the body tag: question figure A template named userinfo.html contains the following line inside the body tag: Which of the following code snippets will utilize the template to display Hello Ram when http://localhost:5000/user/Ram is visited on the browser?
Text of the picture (copyable)
```html
<h1> Hello {{user_name}}! </h1>
```
  1. question figure
    text
    ```python
    @app.route('/user/<name>')
    def user():
        return render_template('userinfo.html', user_name=name)
    ```
  2. question figure
    text
    ```python
    @app.route('/user/<name>')
    def user(name):
        return render_template('userinfo.html', user_name=name)
    ```
  3. question figure
    text
    ```python
    @app.route('/user/<user_name>')
    def user(name):
        return render_template('userinfo.html', user_name = name)
    ```
  4. question figure
    text
    ```python
    @app.route('/user/<name>')
    def user(name):
        return render_template('templates/userinfo',user_name=name)
    ```
Q13MCQ3 marks
Which line of code correctly adds the below Hello class as a resource to a Flask application to get data using “http://localhost:5000/hello" URL? question figure Which line of code correctly adds the below Hello class as a resource to a Flask application to get data using “http://localhost:5000/hello" URL?
Text of the picture (copyable)
```python
from flask_restful import Api
api = Api(app)
Class Hello(Resource):
    def get(self):
        return {'User':'Abhishek'}
```
  1. question figure
    text
    ```python
    api.add_resource(Hello, '/hello')
    ```
  2. question figure
    text
    ```python
    api.add_argument(Hello, '/hello')
    ```
  3. question figure
    text
    ```python
    api.resource(Hello, '/hello')
    ```
  4. question figure
    text
    ```python
    api.put_resource(Hello, '/hello')
    ```
Q14MCQ3 marks
A server using the inbuilt http module of Python, is running for a directory My_app whose file structure and content of each file is given below. question figure A server using the inbuilt http module of Python, is running for a directory My_app whose file structure and content of each file is given below.
Text of the picture (copyable)
Folder: My_app
My_app
  |_ home.html
  |_ first.html
  |_ main.html

File: home.html

```html
<h1>Hello from Home!</h1>
```

File: first.html

```html
<h1>Hello from First!</h1>
```

File: main.html

```html
<h1>Hello from Main!</h1>
```

What will be rendered by the browser for the URL: http://localhost:8000/first.html assuming that 8000 is the port of connection?
  1. question figure
    text
    Directory listing for /
    * first.html
    * home.html
    * main.html
  2. question figure
    text
    Hello from First!
  3. question figure
    text
    Hello from Home!
  4. question figure
    text
    Hello from Main!
Q15MCQ3 marks
Match the following: question figure Match the following: Which of the following is the correct?
Text of the picture (copyable)
| | |
|---|---|
| A. API | 1. Servers do not assume anything about the client's state; they only serve responses. |
| B. MVC | 2. An action is assigned to each uniform resource locator. |
| C. Routing | 3. A standard way defined between two applications for them to communicate. |
| D. Stateless | 4. A design pattern that emphasizes the separation of concerns. |
  1. A-1, B-2, C-3, D-4
  2. A-2, B-4, C-1, D-3
  3. A-3, B-4, C-2, D-1
  4. A-4, B-3, C-1, D-2
Q16MSQ3 marksselect all that apply
Which of the following statement(s) is/are false regarding Git?
  1. Git is an example of a centralized version control system.
  2. A file can stay in both working directory and staging area at a given time, whileworking with Git.
  3. Git and GitLab/GitHub are essentially the same.
  4. The command “git checkout -b ” will create the new branchand switches to the new branch created.
Q17MSQ3 marksselect all that apply
Which of the following statement(s) is/are true regarding database migrations?
  1. Flask does not provide support for migrations, as of December 2022.
  2. The database migration allows a developer to make schema changes withoutlosing the data
  3. One of the disadvantages of migration is that a developer can only upgradethe database, and it does not allow rollbacks.
  4. The migration is useful when a business wants to move from an on-premisedatabase to a cloud based database.
Q18MSQ3 marksselect all that apply
Consider the following Model for User. question figure Consider the following Model for User.
Text of the picture (copyable)
```python
class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    email = db.Column(db.String(100),unique=True,index=True)
    name = db.Column(db.String(100))
    password = db.Column(db.String(100))
```
Which of the following methods from the Flask-sqlalchemy package will behave the same as SQL query `select * from User where name='Ram'`?
  1. question figure
    text
    ```python
    User.query.filter(User.name = 'Ram').all()
    ```
  2. question figure
    text
    ```python
    User.query.get(name = 'Ram').all()
    ```
  3. question figure
    text
    ```python
    User.query.filter_by('Ram').all()
    ```
  4. question figure
    text
    ```python
    User.query.filter_by(name = 'Ram').all()
    ```
Q19MCQ4.5 marks
Consider the following constraints for the “student” table: question figure Consider the following constraints for the “student” table: For the above student table, which of the following columns would be the most appropriate for the indexing?
Text of the picture (copyable)
| Column Name | Datatype | Constraints |
|---|---|---|
| RollNo | Integer | Primary Key |
| Name | String | Not Null |
| Section | Integer | Not Null |
| Department | String | Not Null |

In most cases, the query executed in the student table looks like the one below.

```sql
SELECT RollNo, Name, AadhaarNo FROM student WHERE Section = 'B';
```
  1. RollNo
  2. Name
  3. Section
  4. Department
Q20MSQ4.5 marksselect all that apply
question figure
Text of the picture (copyable)
Consider the following Python code snippet:

Filename: module_0.py

```python
import sys

arguments = sys.argv

courses = {'MAD 1': '1002', 'MAD-2': '2003', 'BDM': '205', 'SysCom': '304'}

def operate():
    arg_1 = arguments[1]
    arg_2 = courses[arg_1]
    return f"The function output is: {len(arg_1 + arg_2)}"

print(operate())
```

The above file will yield the output as "The function output is: 9", for which of the following command line inputs?
  1. python module_0.py MAD 1
  2. python module_0.py MAD-2
  3. python module_0.py BDM
  4. python module_0.py SysCom
Q21MSQ4.5 marksselect all that apply
question figure
Text of the picture (copyable)
Consider two software packages A and B spend exactly $T_A(N) = 2N^2 + 9$ and $T_B(N) = N^3$ milliseconds to process N data items. Analyze the software packages and select the correct statement(s).
  1. Software package A is slower than Software package B for inputs in the rangeN ∈ [0,3]
  2. Software package B is slower than Software package A for inputs in the rangeN ∈ [0,3]
  3. Software package B is faster than Software package A for all N > 3.
  4. Time taken by both the software packages A and B is the same when N = 3.
Q22MSQ4.5 marksselect all that apply
Consider the following Python code snippet. question figure Consider the following Python code snippet. If the above application is running locally on URL: http://127.0.0.1:5000, select the correct statement(s).
Text of the picture (copyable)
```python
from flask import Flask, abort, redirect, url_for, render_template
app = Flask(__name__)

data_science = ['ML-techniques', 'ML-foundations', 'PDSA']
programming = ['Java', 'MAD-I', 'System-Commands', 'ML-practices']

@app.route('/courses/<course>')
def find_course(course):
    if course in data_science:
        return f"<h2>Data Science course found, {course}!</h2>"
    elif course in programming:
        return f"<h2>Programming course found, {course}!</h2>"
    else:
        abort(401)

@app.errorhandler(401)
def page_not_found(error):
    return "<h2>No course found!</h2>"

app.run()
```
  1. question figure
    text
    For the URL, "http://localhost:5000/courses/PDSA", the browser will render:
    **Programming course found, ML-techniques!**
  2. question figure
    text
    For the URL, "http://localhost:5000/courses/ML-practices", the browser will render:
    **Data Science course found, ML-practices!**
  3. question figure
    text
    For the URL, "http://localhost:5000/courses/MAD-2", the browser will render:
    **No course found!**
  4. question figure
    text
    For the URL, "http://localhost:5000/courses/Java", the browser will render:
    **Programming course found, Java!**
Q23MSQ4.5 marksselect all that apply
Consider the following two tables, user1 and logstable: question figure Consider the following two tables, user1 and logstable: Which of the following query/ queries will return the log ID and log name, which are created by user ‘Shaun’?
Text of the picture (copyable)
user1:

| userid | username | password |
|---|---|---|
| U1 | Mack | UabZa |
| U2 | Jack | ZeFad |
| U3 | Shaun | UsTZb |

logstable:

| logid | userid | logname |
|---|---|---|
| 1 | U1 | Playing |
| 2 | U2 | Studying |
| 3 | U3 | Swimming |
| 4 | U1 | Running |
| 5 | U3 | Studying |
| 6 | U2 | Dancing |
  1. question figure
    text
    ```sql
    select logid, logstable.logname from user1 inner join logstable on user1.userid = logstable.userid where user1.username = 'Shaun'
    ```
  2. question figure
    text
    ```sql
    select logid, logstable.logname from user1 natural join logstable
    where user1.username = 'Shaun'
    ```
  3. question figure
    text
    ```sql
    select logid, logstable.logname from user1 inner join logstable on
    user1.username = logstable.logname where user1.username = 'Shaun'
    ```
  4. question figure
    text
    ```sql
    select logid, logstable.logname from user1, logstable WHERE
    user1.username = 'Shaun'
    ```
Comprehension passage - the questions below it refer to this
Consider the following jinja2 template, and answer the given subquestions. question figure Consider the following jinja2 template, and answer the given subquestions.
Q24MCQ3 marks
What will be the output on the terminal for: question figure What will be the output on the terminal for:
Text of the picture (copyable)
```python
data = {'a': 'programming', 'b': 'mathematics', 'd': 'statistics'}
```
  1. question figure
    text
    Data science combines programming abilities and competence in
    mathematics, statistics to draw important insights from data.
  2. question figure
    text
    Data science combines programming abilities and competence in
    mathematics and statistics to draw important insights from data.
  3. question figure
    text
    Data science combines programming abilities and competence in
    Mathematics, to draw important insights from data.
  4. question figure
    text
    KeyError: 'c'
Q25MCQ3 marks
What will be the output on the terminal for: question figure What will be the output on the terminal for:
Text of the picture (copyable)
```python
data = {'b': 'mathematics','c': 'statistics', 'd': 'programming'}
```
  1. question figure
    text
    Data science combines {{a}} abilities and competence in
    mathematics, statistics to draw important insights from data.
  2. question figure
    text
    Data science combines programming abilities and competence in
    mathematics, statistics to draw important insights from data.
  3. question figure
    text
    Data science combines abilities and competence in
    mathematics, statistics to draw important insights from data.
  4. question figure
    text
    ```
    KeyError: 'a'
    ```
Comprehension passage - the questions below it refer to this
Consider the below graph, and answer the given subquestions. The bandwidth vs. time graph for a period of one hour between 12 noon to 1 p.m in the afternoon is shown below. [Use relations: 1 Byte = 8 bits, 1 GB = 1000 MB and so on.] question figure Consider the below graph, and answer the given subquestions. The bandwidth vs. time graph for a period of one hour between 12 noon to 1 p.m in the afternoon is shown below. [Use relations: 1 Byte = 8 bits, 1 GB = 1000 MB and so on.]
Q26MCQ2 marks
What is the network bandwidth (in Mbps) of the network at exactly 12:30 pm?
  1. 5
  2. 6
  3. 7
  4. 8
Q27MCQ4.5 marks
What is the total amount of data (in GigaBytes) consumed by the only user connected to the network between 12:15 pm to 12:30 pm? [Assuming that the user is using the entire bandwidth from 12:15 p.m to 12:30 p.m]
  1. 81
  2. 8.1
  3. 1.0125
  4. 10.125
Comprehension passage - the questions below it refer to this
Consider the below model definitions, and answer the given subquestions. Consider the following model classes “Movies” and “Producers” corresponding to tables “movies” and “producers”, respectively, in the SQLite database. question figure Consider the below model definitions, and answer the given subquestions. Consider the following model classes “Movies” and “Producers” corresponding to tables “movies” and “producers”, respectively, in the SQLite database.
Q28MCQ3 marks
The tables “movies” and “producers” are related to each other by which of the following relationships
  1. One-to-one
  2. One-to-many
  3. Many-to-Many
  4. Many-to-One
Q29MSQ4.5 marksselect all that apply
question figure
Text of the picture (copyable)
If an object "p1" that represents an
existing record in the table "producer" is
defined as

```
p1 = Producer.query.get(2),
```

The correct way to create a new record in
the "movies" table that is produced by the
producer represented by object 'p1' using
terminal is.
  1. question figure
    text
    ```python
    >>> mov = Movies(movie_name = 'The movie', movie_year = 2001)
    >>> p1.movie.append(mov)
    >>> db.session.commit()
    ```
  2. question figure
    text
    ```python
    >>> mov = Movies(movie_name = 'The movie', movie_year = 2001)
    >>> mov.producers.append(p1)
    >>> db.session.commit()
    ```
  3. question figure
    text
    ```python
    >>> mov = Movies(movie_name = 'The movie', movie_year = 2001,
    producers = p1)
    >>> db.session.add(mov)
    >>> db.session.commit()
    ```
  4. question figure
    text
    ```python
    >>> mov = Movies(movie_name = 'The movie', movie_year = 2001)
    >>> p1.producers.append(mov)
    >>> db.session.commit()
    ```
Comprehension passage - the questions below it refer to this
question figure
Q30MCQ3 marks
question figure
Text of the picture (copyable)
If the curl request shown below.

```
curl http://127.0.0.1:5000/api/v1/5001 -X GET
```

retrieves the employee_id only with status 200 OK, what will come in place of GET-FUNCTION in the code?
  1. question figure
    text
    ```python
    def get(self):
        return {'employee_Id': employee_id}
    ```
  2. question figure
    text
    ```python
    def get(self, employee_id):
        return {'employee_Id': employee_id}
    ```
  3. question figure
    text
    ```python
    def get(self):
        args = parser.parse_args()
        return {'Id_no.': args['employee_id']}
    ```
  4. question figure
    text
    ```python
    def get(self):
        args = parser.parse_args()
        return args
    ```
Q31MCQ3 marks
question figure
Text of the picture (copyable)
If the curl request shown below.

```
curl http://127.0.0.1:5000/api/v1 -X POST -d "{\"employee_id\" : \"2003\",
\"employee_name\" : \"Suresh\"}" -H "Content-Type: application/json"
```

retrieves the employee_id only with status 200 OK, what will come in place of
POST-FUNCTION in the code?
  1. question figure
    text
    ```python
    def post(self):
        return {'employee_Id': employee_id}
    ```
  2. question figure
    text
    ```python
    def post(self, employee_id):
        return {'employee_Id': employee_id}
    ```
  3. question figure
    text
    ```python
    def post(self):
        args = parser.parse_args()
        return {'Id_no.': args['employee_id']}
    ```
  4. question figure
    text
    ```python
    def post(self):
        args = parser.parse_args()
        return args
    ```
Q32MCQ4.5 marks
question figure
Text of the picture (copyable)
What will be the response from the server for the request:

```
curl http://127.0.0.1:5000/api/v1 -X PUT -d "{\"employee_id\": \"2003\", \"employee_name\": \"Suresh\"}" -H "Content-Type: application/json"
```
  1. question figure
    text
    ```json
    {
        "employee_id": "2003",
        "employee_name": "Suresh"
    }
    ```
  2. question figure
    text
    ```json
    {
        "employee_name": "Suresh"
    }
    ```
  3. question figure
    text
    ```json
    {
      "employee_id": "2003"
    }
    ```
  4. question figure
    text
    None of these

Answer key

  1. Q1 (MCQ, 2 marks): D
  2. Q2 (MCQ, 2 marks): C
  3. Q3 (MCQ, 2 marks): C
  4. Q4 (MCQ, 2 marks): B
  5. Q5 (MCQ, 2 marks): B
  6. Q6 (MCQ, 2 marks): A
  7. Q7 (SA, 2 marks): 105
  8. Q8 (MCQ, 3 marks): B
  9. Q9 (MCQ, 3 marks): B
  10. Q10 (MCQ, 3 marks): B
  11. Q11 (MCQ, 3 marks): C
  12. Q12 (MCQ, 3 marks): B
  13. Q13 (MCQ, 3 marks): A
  14. Q14 (MCQ, 3 marks): B
  15. Q15 (MCQ, 3 marks): C
  16. Q16 (MSQ, 3 marks): A, C
  17. Q17 (MSQ, 3 marks): B, D
  18. Q18 (MSQ, 3 marks): A, D
  19. Q19 (MCQ, 4.5 marks): C
  20. Q20 (MSQ, 4.5 marks): B, D
  21. Q21 (MSQ, 4.5 marks): A, D
  22. Q22 (MSQ, 4.5 marks): C, D
  23. Q23 (MSQ, 4.5 marks): A, B
  24. Q24 (MCQ, 3 marks): C
  25. Q25 (MCQ, 3 marks): C
  26. Q26 (MCQ, 2 marks): C
  27. Q27 (MCQ, 4.5 marks): C
  28. Q28 (MCQ, 3 marks): C
  29. Q29 (MSQ, 4.5 marks): A, B
  30. Q30 (MCQ, 3 marks): B
  31. Q31 (MCQ, 3 marks): C
  32. Q32 (MCQ, 4.5 marks): D

Concepts this paper tests

Auto-generated summary from the source site. Handy as a checklist; the lessons above explain each idea from scratch.

Here’s a structured summary of core topics, concepts, principles, and equations essential for the "Diploma Level: Modern Application Development 1" exam, followed by Mermaid knowledge graphs to visualize relationships.


1. Core Topics & Concepts

A. Web Development Fundamentals

1. HTML & JavaScript Basics

2. Flask (Python Web Framework)

3. Testing (Pytest)

4. URL Structure

5. CSS Precedence


B. Version Control (Git)


C. Databases & SQL

1. SQL Queries

2. Database Migrations


D. Continuous Integration/Delivery (CI/CD)


E. Performance Analysis


F. Networking


G. Python Command-Line Arguments


2. Key Equations (Mathematics/Performance)

ConceptEquation
Time Complexity\(O(N^2)\) vs. \(O(N^3)\)
Bandwidth to Data\(\text{Data (bits)} = \text{Bandwidth (bps)} \times \text{Time (s)}\)
Bits to Bytes\(1 \, \text{Byte} = 8 \, \text{bits}\)
Binary to OctalGroup binary digits into sets of 3 (right to left).

Graph 2: Git & Version Control

Graph 3: Database & SQL

Graph 4: CI/CD & Testing

Graph 5: Performance & Networking