Map the Below ER diagram to a relational database. Make sure you show the primary
keys and map all the relationships.

 

 

Part III
Create queries demonstrating INSERT, CREATE, UPDATE, SELECT, and DESC for the following
data below. DO NOT CREATE TABLES IN ORACLE. Show Queries in word.
Database is Pensacola High School
Site(SiteID, SuborgID, Addr)
Staff(StaffID, FirstName, LastName, DOB, SiteID)
Student(StudentID, FirstName, LastName, Addr, SiteID)
Class (ClassID, ClassName, StaffID, StudentID, SiteID)

1. display a query displaying all students
2. display a query showing all classes for a student with an ID of 2.
3. display a query showing all Staff with name LIKE Smith.
4. display a query showing classes and student info for the student with ID of 5 and ClassID of 21.
5. display a query showing a class for student with ID of 5 and staffID of 7. Ensure to include
student.FirstName student.Lastname staff.firstName staff.lastName, StudentID, StaffID, ClassID
and ClassName. Hint use Inner Join query.

 

i have provided the answer to part 1

 

Dssn D_Name D_Specialization D_Address D_Phone Doctors 1 Has N Dependents Pssn P_Name P_Phone P_Address 1 (1,N) Sees Patients DependentID Dependent Name InsuranceID 1 Has (0,N) Insurance P_Sex P_Age Insurance_Name Insurance Coverage