DBProject First Semester
-
Updated
Dec 21, 2017 - PLSQL
DBProject First Semester
This is a complete Database Systems project which is divided into three phases: first one is “ER Modeling”, second phase is “Relational Model” and the third phase is “Schema Refinement”.
In this project, we are designing the database for the Graphics Design School named ‘Nexus’. A proper methodology of database systems has been followed starting with designing an ER Diagram for the database till the normalization of the schema till 3NF.
The project implements the Amazon's e-commerce database system which fulfils all the functional requirements for an e-commerce website. The database is created by designing the Extended Entity Relation (EER) model of Amazon as an E-commerce website. EER is then converted to relational tables using the set of well defined rules and after applying…
Courses Database - Fiverr Project
Computer Conference Database - Fiverr Project
SQL project shows data modeling, implemented using MySQL, including the schema design, ERD, data dictionary, data insertion, and querying for a HR management system.
The project employed Oracle PL/SQL Developer; an RDBMS was engineered for streamlined university course enrolment. It commenced with precise ERD and DFD design using Lucidchart, enforcing data integrity via constraints, triggers, and sequences. Graphical reports showcased student performance and faculty acclaim, revolutionizing enrolment procedures
Add a description, image, and links to the erdiagram topic page so that developers can more easily learn about it.
To associate your repository with the erdiagram topic, visit your repo's landing page and select "manage topics."