Found 96 repositories(showing 30)
Oracle database project design and creation for a manufacturing company using ER Diagrams and SQL.
Yunfeng01
This is a rental management database system using Oracle Form Builder and SQL. It's a 3 people project. We design the ER diagram, relation diagram and create table using SQL query. Then, connect the database with Oracle Form Builder interface.
MojithaR
A comprehensive Online Auction System project focusing on designing and implementing secure, high-performance database solutions using relational query languages and database programming techniques. Covers requirements analysis, ER diagrams, relational schemas, SQL queries, performance, and security considerations.
liliaferrouk
In this Database capstone project, I'll be: creating an ER Diagram data model and implement it in MySQL Workbench using forward engineering, Using SQL to create virtual tables, stored procedures and prepared statements for Little Lemon restaurant, Visualizing the sales data of a restaurant and implement a database client in Python.
QuantumAlchemist03
A relational database system designed to support the operations of Together Culture Cambridge. It handles event management, member engagement, and various logistical aspects of community organization activities. Built using SQL, the project features complex ER diagrams, normalized tables, and optimized queries for efficient data handling
This group project utilized 6 datasets containing environmental, fiscal, and demographic data on countries found in the United Nations' 2017 World Happiness dataset. All datasets were cleaned, explored and visualized and sql was used in Python to create a database. Spark regression analysis was used to determine which variables within the databases were most predictive of overall World Happiness Scores. A PDF report of findings is included as well as the 6 datasets used. Additionally, a ER diagram is included to visualize the relational database created.
Performed SWOT Analysis on the indian ed-tech firm Byju's. Used ER diagram hierarchy to solve and perform SQL query operations.
Kathrin-92
Project: Creating a Database for Renting Appartements and Bedrooms using SQL. Also includes a ER diagram!
abrarhussain39
A database project to create a database system from scratch, from deciding business goals to drawing ER diagrams,ER to relational mapping, SQL and using java command line for project
astamkad
Capstone project for the Meta Database Certificate. Includes a normalized ER diagram, SQL script for database implementation, and version-controlled project files for Little Lemon restaurant. Built using MySQL Workbench and Git to demonstrate end-to-end database design and management skills.
SarKaushik
SQL proficiency with projects like advanced app database design using MS Access. Notably, I optimized Video Rental app configs, created ER diagrams, and employed analytics for actionable insights. Contributed to Hotel Reservation using web forms and participated in Supply Chain Management, utilizing Oracle SQL, ASP.NET, PL/SQL, and MS Access
JustinClarke
a DBMS project using SQL (Semester 5, team of five). Created a hotel management database customer details. - Drew an ER Diagram - Formed the relational schema - Added data into tables - Executed queries and did normalization of tables
cephascard0207
The LibraryDB_mysql_STARTER-KIT project provides a complete setup for a simple library database using MySQL Workbench and SQL, featuring a detailed query script and an ER diagram to visualize table relationships. It is designed for beginners and students to easily understand and implement database structures and relationships.
It is a database management system project using the Ipl 2020 dataset. The kaggle website provided the dataset. In this project, my project partner and I collected information about 26 matches, including point tables, venues, teams, umpires, and owners. We then manually drew relational models and Er diagrams, recorded the data in MySQL, and resolved 10 SQL queries.
FadyEssam27
A project for the database subject , the project is a database for the problem corner in stack overflow, There were 2 phases of the project, The first phase include an ER diagram and relational schema, the second phase includes applying the schema in sql using oracle sql developer (with sql and pl/sql)and a form that allows the user to interact easily with the database like a small basic system and this done by oracle forms builder, The last thing was a report about the project using oracle reports, The report idea is to display the activity of each user ( his questions, answers , votes and badges )
evanboddu
In this project, I took the home credit data which is about loan of a customer. This dataset has everything about a customer, what documents that customer provided, what is the credit limit of that customer and so on. There were around 9 excel files and I created a database using SQL Shell. I have a report of all my findings and also a ER Diagram that would help look at the connections and relationships between each table.
sans25-cool
Prepared database for Netflix after gathering user requirements. Used ER diagram hierarchy to solve and perform SQL query operations.
PayalSurana-02
A database project for managing a restaurant system using SQL, ER diagrams, normalization, and MS Access.
jyotitutorials21
DBMS lab project implementing a college database using Oracle SQL*Plus with ER diagram, schema creation and data insertion.
maq27-ship-it
A comprehensive SQL project featuring 10 real-world database systems with schema design, queries, and ER diagrams using MySQL..
DikeshChavhan
Mini E-Commerce database & analytics project using MySQL + SQL + Power BI, including schema design, KPIs, ER diagram and dashboard.
vinaydoddapaneni
A mini SQL and Power BI project using IMDb Top Movies data. Includes database design, SQL queries, ER diagram, and Power BI visualizations.
Aditya-ARC
SQL-based Instagram-style database project using Oracle syntax; 25+ normalized tables, ER diagrams, analytics, and business logic queries.
Saiful101
Database Lab Project and SQL queries for CSE370 (Database and Management Systems). Includes ER/EER diagram, schema design, table creation, joins, and query solutions using MySQL.
LeonardoIshida
This project uses the airbnb public database to make ER and ERD diagrams, SQL queries using PostgreSQL and remodelling the entire database into a more concise one.
Argho-Dey
Alumni Management System database project using Oracle SQL and Java (JDBC) featuring ER diagram, normalization, relational schema design, and SQL queries for managing alumni, events, donations, and networking groups.
Hamza-47K
Database design and implementation based on an ER diagram, converted to a relational schema and normalized up to 3NF. Project Contents - ER Diagram - Relational Schema - Normalization (1NF, 2NF, 3NF) - SQL script (tables, keys, constraints) - Sample data and queries Technologies Used - Oracle SQL - Relational Database Design
jeeshanshaikh9892
Added MySQL-based Banking System Database project including ER diagram, SQL queries (Joins, Subqueries), and PowerPoint documentation. This project manages customers, accounts, loans, and transactions efficiently using relational database design.
amirashhf
A project to design and implement a relational database for an airline ticket reservation system using SQL, including schema design, ER diagram, and query implementation.
Keerthana661997
A collection of SQL projects showcasing data analysis, database design, and query optimization. Includes sample datasets, ER diagrams, and real-world case studies using MySQL.