This repository contains coursework, queries, and assignments from the Database Systems course at FAST NUCES.
Database Systems covers the principles of designing, building, and querying relational databases. The course combines theory (ER modelling, normalisation) with practical SQL programming.
- Entity-Relationship (ER) modelling
- Relational model and schema design
- SQL — DDL, DML, DCL
- Joins, subqueries, and aggregate functions
- Normalisation (1NF, 2NF, 3NF, BCNF)
- Transactions and ACID properties
- Indexing and query optimisation basics
- Clone the repository
git clone https://github.com/talha586/Data-Base-System.git
- Open any
.sqlfile in your database tool (MySQL Workbench, pgAdmin, DB Browser, etc.) - Run the queries against your local database instance
Muhammad Talha — CS Student at FAST NUCES, Lahore