Database Systems - AI-Enhanced Database Assignment

Student Information

Name:

Roll No:

Batch:

Date:

Instructor:

SECTION 1: STUDENT-CREATED DATABASE PROBLEM

1.1 Problem Title:

1.2 Scenario Description (Real-World Context):

(Write 5–8 lines describing the system you designed)

1.3 Entities & Attributes:

Entity Name

Attributes (comma separated)

1.4 Relationship Description:

1.5 Type of Task Chosen:

ER Diagram

SQL (DDL + DML)

Subqueries

Views

Triggers

Stored Procedure

MongoDB

SECTION 2: AI INTERACTION

2.1 AI Tool Used:

ChatGPT

Claude

Gemini

2.2 Prompt(s) Used:

2.3 AI Response:

(Paste or Attach Screenshot)

Or upload screenshot:

SECTION 3: AI GENERATED SOLUTION

(Paste SQL / ER Diagram / MongoDB Queries here)

-- Paste AI-generated SQL/DDL here -- Or describe the ER diagram

Or upload diagram/image:

SECTION 4: STUDENT CRITICAL ANALYSIS

Is the AI solution correct? Why?

Any missing constraints or normalization issues?

Identify at least 3 strengths of the AI solution:

1

2

3

Identify at least 3 weaknesses/errors:

1

2

3

How would you improve this solution manually?

SECTION 5: REFLECTION

What did you learn from using AI in Database Design?

SECTION 6: CONCLUSION

Summarize your experience of combining AI with Database problem-solving:

BONUS CREATIVE ADD-ON (Optional)

AI vs Human Comparison

AI Mistake Hunt

Prompt Optimization Game

Progressive Prompt Enhancement

EVALUATION (For Instructor Use)

Criteria	Marks	Score
Original Problem Design	20
Prompt Quality	10
AI Solution Usage	15
Critical Analysis	30
Creativity & Presentation	15
Reflection	10
Total	100

Instructor Remarks:

Instructor's Signature: