comp1350-database-design-project

Database design project for COMP1350 including conceptual, logical and physical design.

Database Design Project

This project was completed for COMP1350 as a group assignment.

Overview

The project involved designing a database from a business scenario through three stages:

• Conceptual design
• Logical design
• Physical design

Work Completed

• Identified business rules and assumptions
• Created an ER diagram using Crow’s Foot notation
• Included entities, attributes, identifiers, relationships, constraints and cardinality
• Extended the model by introducing a new business rule and additional entity
• Performed logical transformation from ER model to relational tables
• Defined primary keys and foreign keys
• Produced a physical design with MySQL-compatible data types

Skills Demonstrated

• Database modelling
• ER diagram design
• Relational schema design
• Primary and foreign key mapping
• Systems analysis
• Team collaboration

Note

This was a university group project. Uploaded here as part of my academic portfolio.

My Contribution

Contributed to database modelling, business rules analysis, and documentation as part of a group project.