Need help identifying and establishing Primary keys and foreign keys

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Need help identifying and establishing Primary keys and foreign keys 

The image is a database schema diagram representing a pharmaceutical management system. It consists of several entities and their relationships, each represented by a colored box with attributes listed inside. Here's a detailed description of the entities and their attributes:

1. **PHARMACY (Blue Box):**
   - **Attributes:**
     - Pharmacy_ID
     - Pharmacy_Name
     - Pharmacy_Address

2. **EMPLOYEES (Gray Box):**
   - **Attributes:**
     - Employee_ID
     - Employee_FName_Lname
     - Employee_Address
     - Employee_DOB
     - Employee_Phone

3. **CUSTOMERS (Light Green Box):**
   - **Attributes:**
     - Customer_ID
     - Customer_FName_LName
     - Customer_Address
     - Customer_Phone
     - Customer_Email

4. **PHARMACIST (Light Green Box):**
   - **Attributes:**
     - Pharmacist_ID
     - Pharmacist_FName_LName
     - Pharmacist_Email
     - Pharmacist_Pos_Title

5. **STAFF (Light Blue Box):**
   - **Attributes:**
     - Staff_ID
     - Staff_FName_LName
     - Staff_Email
     - Staff_Job_Code

6. **PHARMACY TECH (Orange Box):**
   - **Attributes:**
     - Pharm_Tech_ID
     - Employee_ID
     - Pharm_Tech_FName_LName
     - Pharm_Tech_Email

7. **LEVEL (Two Mint Green Boxes):**
   - **Attributes:**
     - Employee_ID
     - Staff_ID

**Relationships:**
- The diagram shows lines indicating relationships between these entities:
  - A relationship between PHARMACY and EMPLOYEES.
  - EMPLOYEES are related to PHARMACIST, STAFF, and PHARMACY TECH, suggesting that these roles are subsets of employees.
  - There is also a relationship that connects EMPLOYEES and CUSTOMERS.

This schema diagram represents various components of a pharmacy’s operational data, highlighting the roles and relationships between staff, customers, and pharmacy locations, crucial for managing daily operations efficiently.
Transcribed Image Text:The image is a database schema diagram representing a pharmaceutical management system. It consists of several entities and their relationships, each represented by a colored box with attributes listed inside. Here's a detailed description of the entities and their attributes: 1. **PHARMACY (Blue Box):** - **Attributes:** - Pharmacy_ID - Pharmacy_Name - Pharmacy_Address 2. **EMPLOYEES (Gray Box):** - **Attributes:** - Employee_ID - Employee_FName_Lname - Employee_Address - Employee_DOB - Employee_Phone 3. **CUSTOMERS (Light Green Box):** - **Attributes:** - Customer_ID - Customer_FName_LName - Customer_Address - Customer_Phone - Customer_Email 4. **PHARMACIST (Light Green Box):** - **Attributes:** - Pharmacist_ID - Pharmacist_FName_LName - Pharmacist_Email - Pharmacist_Pos_Title 5. **STAFF (Light Blue Box):** - **Attributes:** - Staff_ID - Staff_FName_LName - Staff_Email - Staff_Job_Code 6. **PHARMACY TECH (Orange Box):** - **Attributes:** - Pharm_Tech_ID - Employee_ID - Pharm_Tech_FName_LName - Pharm_Tech_Email 7. **LEVEL (Two Mint Green Boxes):** - **Attributes:** - Employee_ID - Staff_ID **Relationships:** - The diagram shows lines indicating relationships between these entities: - A relationship between PHARMACY and EMPLOYEES. - EMPLOYEES are related to PHARMACIST, STAFF, and PHARMACY TECH, suggesting that these roles are subsets of employees. - There is also a relationship that connects EMPLOYEES and CUSTOMERS. This schema diagram represents various components of a pharmacy’s operational data, highlighting the roles and relationships between staff, customers, and pharmacy locations, crucial for managing daily operations efficiently.
Expert Solution
Step 1

Pharmacy

PK: Pharmacy_ID

FK: NA

 

Employees

PK: Employee_ID

FK: NA

 

Customers

PK: Customer_ID

FK: NA

trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education