DBMS PRACTICAL ASSIGNMENT (1)
Assignment:
Create a Signup Form with three fields (Name, Email, and Country) using HTML, CSS, and
PHP. Store the form data in a MySQL database using PHPMyAdmin.
Requirements:
1. Create a MySQL database named "signup_db" with a table named "users" having columns:
❖ id (primary key, auto-increment)
❖ name (varchar, 50)
❖ email (varchar, 100)
❖ country (varchar, 50)
❖ Password (varchar, 300)
2. Design a simple signup form using HTML and CSS.
3. Use PHP to connect to the MySQL database and insert form data into the "users" table.
4. Validate form data (e.g., email format, empty fields).
5. Display a success message after successful signup.
DBMS THEORY ASSIGNMENT (2)
Question:
Design and describe the architecture of a dynamic website that incorporates HTML5, CSS3,
JavaScript, and PHP. The website should include the following features:
✓ A responsive navigation menu
✓ A contact form with validation
✓ A database-driven blog section
Requirements:
1. Explain the role of each technology (HTML, CSS, JavaScript, PHP) in the website's
development.
2. Describe the HTML5 structure and semantic elements used.
3. Discuss the CSS3 styling and responsive design techniques employed.
4. Outline the JavaScript functionality for form validation and Ajax requests.
5. Explain the PHP scripting for database interaction, form processing, and content generation.
Grading Criteria:
✓ Accuracy and depth of technical knowledge (60 points)
✓ Clarity and coherence of writing (20 points)
✓ Completeness and organization of the design architecture (20 points)
PROGRAMMING ASSIGNMENT (1) PRACTICAL
Assignment: Guess the Number Game using Python Tkinter
Objective: Create a simple GUI-based game using Python Tkinter where the user has to guess a
randomly generated number between 1 and 100.
Requirements:
1. Create a window with Tkinter with the following widgets:
✓ Label to display the guess result (too high, too low, or correct)
✓ Entry field for user input
✓ Button to submit the guess
✓ Button to reset the game
2. Generate a random number between 1 and 100 when the game starts.
3. When the user submits their guess:
✓ Check if the guess is higher or lower than the generated number.
✓ Display "Too High!" or "Too Low!" accordingly.
✓ If the guess is correct, display "Congratulations! You won!" and disable the submit
button.
4. Implement the reset button to restart the game with a new random number.
Functional Requirements:
✓ Handle invalid user input (e.g., non-numeric characters).
✓ Display error messages for invalid input.
✓ Ensure the game window is responsive and easy to use.
Submission Requirements:
❖ Submit your Python code (.py file) using Tkinter.
❖ Ensure your code is well-organized, readable, and follows standard naming conventions.
❖ Include comments to explain your code logic.
Grading Criteria:
❖ Correctness and functionality (40%)
❖ Code organization and readability (20%)
❖ Error handling and user experience (20%)
❖ Code commenting and documentation (20%)
PROGRAMMING ASSIGNMENT (1) THEORY
Assignment: Common Python Libraries
Objective: To understand and describe the most commonly used libraries in Python
programming.
Requirements:
1. Introduction (brief overview of Python libraries)
2. Describe the following libraries, including their purpose, features, and applications:
✓ NumPy
✓ Pandas
✓ Matplotlib/Seaborn
✓ Scikit-learn
✓ Requests
✓ BeautifulSoup
✓ Tkinter
✓ Flask/Django
3. Compare and contrast at least two libraries from the above list (e.g., Matplotlib vs. Seaborn)
4. Discuss the importance of libraries in Python's popularity and ecosystem
5. Conclusion (summary of key points)
Guidelines:
✓ Report should be 5-7 pages long (excluding references)
✓ Use proper headings, subheadings, and formatting
✓ Include diagrams, flowcharts, or illustrations to support explanations
✓ Cite at least 5 reputable sources (academic papers, official documentation, or industry
blogs)
✓ Use Harvard citation style
Evaluation Criteria:
✓ Depth and accuracy of technical information (40%)
✓ Clarity and coherence of writing (30%)
✓ Organization and structure of the report (20%)
✓ Use of visual aids and supporting materials (10%)
Submission:
Please submit your report in PDF format.
Grading:
Content (40%)
✓ Technical accuracy and depth (20%)
✓ Clarity and coherence (10%)
✓ Organization and structure (10%)
Presentation (30%)
✓ Visual aids and supporting materials (15%)
✓ Formatting and citation style (10%)
✓ Overall readability (5%)
Critical Thinking (30%)
✓ Comparison and contrast of libraries (15%)
✓ Discussion of library importance (10%)
✓ Conclusion and summary (5%)
ALL ASSIGNMENTS (DUE DATE: 20/11/2024)