SQL Server Database Schema for Medical Store System

Database: Medical_Store_System

Tables:

1. Drugs:

`Drug_ID` (int, primary key)

`Drug_Name` (string)

`Generic_Name` (string)

`Dosage_Form` (string)

`Strength` (string)

`Quantity` (int)

`Unit_Price` (decimal)

2. Drug_Types:

`Drug_Type_ID` (int, primary key)

`Drug_Type_Name` (string)

3. Customers:

`Customer_ID` (int, primary key)

`Customer_Name` (string)

`Phone_Number` (string)

`Address` (string)

`City` (string)

`State` (string)

`Zip_Code` (string)

4. Prescriptions:

`Prescription_ID` (int, primary key)

`Customer_ID` (int, foreign key)

`Drug_ID` (int, foreign key)

`Doctor_Name` (string)

`Prescription_Date` (datetime)

`Quantity` (int)

5. Invoices:

`Invoice_ID` (int, primary key)

`Customer_ID` (int, foreign key)

`Invoice_Date` (datetime)

`Total_Amount` (decimal)

6. Invoice_Details:

`Invoice_Details_ID` (int, primary key)

`Invoice_ID` (int, foreign key)

`Drug_ID` (int, foreign key)

`Quantity` (int)

`Unit_Price` (decimal)

`Amount` (decimal)