Retail Database Management System

Overview

This project is a relational database management system developed using Microsoft Access as part of the Database Systems unit at Australian Catholic University.

The database manages customers, employees, departments, invoices, products, brands, vendors, supplies, and salary history. It also includes defined relationships and 15 queries for retrieving and analysing business data.

Features

• Relational database design
• Primary and foreign key relationships
• Customer, employee, product, invoice, and vendor data management
• 15 Microsoft Access queries
• Filtering, aggregation, and multi-table query operations
• Data integrity through defined table relationships

Technologies Used

• Microsoft Access
• SQL
• Relational Database Design
• Database Management Systems

Database Objects

Tables and Queries — Part 1

Tables and Queries — Part 2

Database Relationships

Relationship Diagram — Part 1

Relationship Diagram — Part 2

Repository Contents

• retail-database-management-system.mdb — complete Microsoft Access database
• database-objects-part1.png — tables and queries preview
• database-objects-part2.png — remaining queries preview
• relationships-part1.png — first section of the relationship diagram
• relationships-part2.png — second section of the relationship diagram

Skills Demonstrated

• Database Design
• SQL Query Design
• Microsoft Access
• Relational Databases
• Primary and Foreign Keys
• Data Integrity
• Problem Solving