Maria's Portfolio

SQL Database Implementation & ERD

This assignment focuses on implementing and analyzing a relational database using SQL Server. It includes creating and populating a database, constructing an ERD to define table relationships, and writing SQL scripts for table creating, data manipulation, and metadata retrieval. The work demonstrates proficiency in defining primary keys, handling data types, and executing queries to manage and inspect database structures. By combining conceptual design with hands-on SQL execution, this project highlights both theoretical understanding and practical database development skills.

Tiny College ERD Design (Crow’s Foot Notation)

This project presents a comprehensive Entity-Relationship Diagram for a college system using Crow’s Foot notation. It models real-world academic structures including schools, departments, professors, courses, classes, and students, while capturing complex relationships such as advising, enrollment, and departmental hierarchy. The design incorporates business rules like optional relationships, cardinality constraints, and many-to-many associations. This deliverable demonstrates the ability to translate detailed requirements into a structures visual database model that supports both operational functionality and future scalability.

Database Normalization Process

This picture demonstrates a few examples of the step-by-step transformation of datasets from First Normal Form (1NF) through Third Normal Form (3NF). Within several practice problems, it highlights how functional dependencies are identified and resolved to eliminate redundancy, improve data integrity, and ensure efficient database structure. Each stage visually breaks down attributes, keys, and dependencies, showing how complex data can be decomposed into well-structured relational tables. This work reflects a strong understanding of normalization theory and its practical application in designing scalable and maintainable databases.