<title>Database Management Systems - DBMS Portfolio</title> <style> body { font-family: Arial, sans-serif; margin: 0; padding: 0; background-color: #000; /* Black Background */ color: #FFD700; /* Yellow Text */ } header { background-color: #1a1a1a; color: #FFD700; padding: 20px 10px; text-align: center; } .nav-links { list-style: none; padding: 0; margin: 20px 0 0; display: flex; justify-content: center; gap: 20px; } .nav-links a { text-decoration: none; color: #FFD700; font-weight: bold; padding: 5px 10px; transition: all 0.3s ease; background-color: transparent; border-radius: 4px; } .nav-links a:hover { color: #000; background-color: #FFD700; /* Yellow Background on Hover */ } section { display: none; /* Hide sections by default */ padding: 20px; } section.active { display: block; /* Show the active section */ } footer { background-color: #1a1a1a; color: #FFD700; text-align: center; padding: 10px; } .github { text-align: center; margin-top: 30px; } .github a { color: #FFD700; /* Yellow color for GitHub links */ text-decoration: none; font-weight: bold; } .github a:hover { color: #00acee; /* Blue on hover */ } .assignment { background-color: #1a1a1a; padding: 15px; margin: 20px 0; border-radius: 8px; box-shadow: 0px 0px 10px rgba(255, 255, 255, 0.2); } .assignment h3 { color: #FFD700; /* Yellow for assignment titles */ } a { color: #FFD700; /* Default yellow color for links */ text-decoration: none; } a:hover { color: #00acee; /* Blue on hover for consistency */ } </style>

Database Management Systems - DBMS Portfolio

Semester: 3 Semester | Department: Computer Science Engineering

Mentor: Guruprasad Konnurmath | Course Code: 15ECSC208

• Home
• About Me
• Learning and Assignments
• Contact

Home

Welcome to my DBMS portfolio. Here, I showcase my journey and accomplishments in learning database management systems.

About Me

I am Pruthvi R, an aspiring database professional passionate about designing efficient, secure, and reliable database systems.

Learning and Assignments

1. ER Model and Relational Algebra

Assignment Name: "ER Model Design for a Library System"

Description: Designed entity types, relationships, and structural constraints to represent library database schema.

Challenges and Solutions: Efficiently handling many-to-many relationships using associative entities.

Reflection: Gained a solid understanding of ER modeling and relational algebra operations like SELECT and JOIN.

2. SQL Database Creation

Assignment Name: Created and queried a SQL database for pharmacy management.

Description: Used DDL and DML operations to create tables, insert data, and perform queries with aggregate functions.

Challenges and Solutions: Writing complex nested queries and debugging logical errors.

Reflection: Developed strong skills in SQL programming and query optimization.

3. Normalization and Transaction Processing

Assignment Name: Hospital Management System Normalization and Transactions.

Description: Normalized hospital database to 3NF and implemented ACID-compliant transaction processing.

Challenges and Solutions: Resolving partial and transitive dependencies for a large dataset.

Reflection: Learned how normalization improves database integrity and transaction management ensures consistency.

Contact

Email: 01fe23bcs228@kletech.ac.in

LinkedIn: linkedin.com/in/yourprofile

GitHub: github.com/yourprofile

GitHub Repository

Check out the code for this portfolio on GitHub:

GitHub Repository Link

<script> function showSection(sectionId) { const sections = document.querySelectorAll("section"); sections.forEach((section) => { section.classList.remove("active"); }); document.getElementById(sectionId).classList.add("active"); } <style>