Map the Below ER diagram to a relational database. Make sure you show the primary keys and
Question:
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
Database Design Using Entity Relationship Diagrams
ISBN: 9781032017181
3rd Edition
Authors: Sikha Saha Bagui, Richard Walsh Earp