Create a database schema for a dental clinic. The dental clinic has five relations, Patients, Doctors, staff, Appointments, Payments. You are free to choose the attributes for each relation, and you are required to show the Primary keys.
Giving the following schema create an ER diagram for this Supermarket database, and show the primary keys, multivalued attributes, composite attributes, and relationship types.
Supermarket has CUSTOMERS (CustomerID , First_Name, Last_Name)
Supermarket has EMPLOYEES (EmployeeID, Name, Email, PhoneNo, Address, Salary)
Each Employee purchase PRODUCTS (ProductID, Product_Type)
Employee creates INVOICES( InvoiceID, Amount_Paid, Invoice_Date)