Based on the following ER Diagram from the database called “…
Questions
Bаsed оn the fоllоwing ER Diаgrаm from the database called "StudentFinancial." What SQL statement would you use to answer the following question? Image Long Description The "Student" entity is connected to the "Tuition" entity with a one-to-relationship labeled "Pays". Student Entity and Attributes PSUID INT (primary key) FirstName VARCHAR(45) LastName VARCHAR(45) Email VARCHAR(45) Department VARCHAR(45) Tuition Entity and Attributes tuitionID INT (primary key) Student INT (foreign key) SemesterCost INT Scholarships INT DueDate INT What is the total semester cost per due date? SELECT [attributes]FROM Tuition[clause]