staff (ID, fname, lname, role) patient (pID, pFname, pLname, bdate, address, phone) appointment (aptID, patientID, staffID, aptDate, aptTime) procedures (procNum, pName, price) aptDetail (aptID, procNo) The dental practice has a number of staff with different care-giving roles (role) suclh as 'dentist', 'hygienist' and 'dental nurse'. Also stored in the staff table are: a unique staff id (ID) and the staff's name (fname and 1name). Details stored on patients in the patient table are: a unique ID (pID), name (pFname and pLname), birth date (bdate), address (address) and phone number (phone). Each patient may have zero or more appointments listed in the appointment table. Each appointment has a unique ID (aptID). Also stored is the patient ID (patientID), the ID of the staff member booked for the appointment (staffID), and the date and time of the appointment (aptDate and aptTime). A staff member may have many appointments. The foreigr keys in the table are patientID and staffID. The dental practice stores a list of the procedures it carries out (e.g., named as cleaning', 'filling', 'extraction', etc.), and their cost, in the procedures table. Details stored are a unique procedure number (procNum), the name of procedure (pName) and the price of the procedure (price). Details of the procedures that each patient receive, per appointment, are recorded in the aptDetail table by listing the appointment IID (aptID) and the procedure number (procNo) for one or more proceedures. The foreign keys in the table are aptID and procNo staff (ID, fname, lname, role) patient (pID, pFname, pLname, bdate, address, phone) appointment (aptID, patientID, staffID, aptDate, aptTime) procedures (procNum, pName, price) aptDetail (aptID, procNo) The dental practice has a number of staff with different care-giving roles (role) suclh as 'dentist', 'hygienist' and 'dental nurse'. Also stored in the staff table are: a unique staff id (ID) and the staff's name (fname and 1name). Details stored on patients in the patient table are: a unique ID (pID), name (pFname and pLname), birth date (bdate), address (address) and phone number (phone). Each patient may have zero or more appointments listed in the appointment table. Each appointment has a unique ID (aptID). Also stored is the patient ID (patientID), the ID of the staff member booked for the appointment (staffID), and the date and time of the appointment (aptDate and aptTime). A staff member may have many appointments. The foreigr keys in the table are patientID and staffID. The dental practice stores a list of the procedures it carries out (e.g., named as cleaning', 'filling', 'extraction', etc.), and their cost, in the procedures table. Details stored are a unique procedure number (procNum), the name of procedure (pName) and the price of the procedure (price). Details of the procedures that each patient receive, per appointment, are recorded in the aptDetail table by listing the appointment IID (aptID) and the procedure number (procNo) for one or more proceedures. The foreign keys in the table are aptID and procNo
