This database project consists of multiple SQL statements and queries that create tables, insert data, perform modifications, and execute various queries on the database. The project focuses on managing a pharmacy's branch, pharmacists, medicines, customers, and sales.
The project consists of the following tables:
- branch: Represents information about different branches of the pharmacy.
- pharmacist: Contains details about pharmacists working at different branches.
- medicine: Stores information about the available medicines, including their name, company, type, and price.
- customer: Holds data related to customers, including their name, gender, age, and the branch they are associated with.
- sale: Records the details of sales transactions, such as the customer, medicine, amount, and date.
- Name: MST. Rubaiya Raktin Raha
- Roll: 1907111