Giter VIP home page Giter VIP logo

🌐 Coding profile :

Linkedin Leetcode Geeks for geeks

πŸ’» Tech Stack:

C++ C CSS3 JavaScript Java HTML5 Python PHP AWS Vercel Angular.js Anaconda Bootstrap Django MySQL MongoDB MicrosoftSQLServer AmazonDynamoDB Canva Figma Sketch Adobe Premiere Pro Adobe Photoshop NumPy Pandas LINUX

πŸ“Š GitHub Stats:



πŸ† GitHub Trophies

✍️ Random Dev Quote


Mahendra Singh Puniya's Projects

dbms-class-test icon dbms-class-test

All the relationships in the above ERD diagram are binary relationships. The cardinality of these relationships is as follows: β€’ Students-Enrollment : One to Many β€’ Enrollment-Classes: Many to One β€’ Classes-Staff: Many to One β€’ Classes-Pool: Many to One β€’ Classes-Level: Many to One As we can see from the above diagram one instructor can take many classes but it is mandatory that each class have an instructor (from staff) while the participation of staff is optional i.e. it is not necessary that an instructor has a class assigned to him/her. Similarly a pool can be used to conduct many classes but it is mandatory for a class to be conducted inside a pool. There can be a pool where no classes are conducted hence it’s participation in the relationship is optional. A class has to be on some level (beginner, intermediate, advanced etc…) and there will be at least one class for every level. In the above diagram we can see that enrollment is a weak entity as it has no unique primary key. One Student can enroll into many classes and many students can enroll for the same class. So we cannot use student id or class id to identify enrollment. So we use a composite key comprising of two foreign keys SID and LessonIndex and assign it as primary key. Thus we can give each enrollment a unique id and convert it into strong entity by identifying it using two strong entities. Since a student has to enroll and a class must have enrolled students we can infer that a class will have at least one student. There can be a situation when one class is conducted more than once in a day for the same group of students. It is possible that due to timing clashes that these classes are conducted by the same instructor in different pools or by different instructors in different pool or by different instructors in different pools. In any case there will be multiple records of that class with a change in only two or three fields. Due to this any updation in record might be tricky. This can be solved by creating another entity which can be identified through a combination of instructor id and lesson id.

desert-national-park icon desert-national-park

This repo. comprises HTML, CSS, and JavaScript code alongside design assets created using Figma. It's a user-friendly,responsive , visually captivating platform that assists both foreign and Indian tourists in exploring the Thar Desert and Desert National Park.

dictionary_app icon dictionary_app

A web-based dictionary application providing word meanings, antonyms, and part of speech information with a user-friendly interface.

ecommerce_suraj_stone_art icon ecommerce_suraj_stone_art

This project repository demonstrates my proficiency in web development by delivering a dynamic website for Suraj Stone Art. Employing HTML, CSS, and JavaScript, I engineered a responsive UI with optimized navigation. Leveraging advanced JavaScript techniques, I integrated custom functionalities to ensure seamless user interactions.

link-generator icon link-generator

"A web application that simplifies communication by generating shareable links from phone numbers and text messages, akin to WhatsApp functionality. Built with HTML, CSS, JavaScript, and React."

mahendra-dev-portfolio icon mahendra-dev-portfolio

Welcome to my portfolio , This project showcases my expertise in web development using Astro, SASS, Bootstrap, and several JavaScript libraries including Curtains.js, Typed.js, and AOS.js. With a modern and interactive design, this portfolio offers visitors a visually engaging experience while highlighting my skills and projects.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    πŸ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. πŸ“ŠπŸ“ˆπŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❀️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.