Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Write the appropriate SQL query for each of the following questions: Display the number of students acting in ‘Radio Club’ Display the sum of fees of activities organized by the IT club

Write the appropriate SQL query for each of the following questions: Display the number of students acting in ‘Radio Club’ Display the sum of fees of activities organized by the IT club

Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter10: Transaction Management And Concurrency Control
Section: Chapter Questions
Problem 1P
See similar textbooks
icon
Related questions
Question

Write the appropriate SQL query for each of the following questions:

  1. Display the number of students acting in ‘Radio Club’
  2. Display the sum of fees of activities organized by the IT club
The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid, #clubid , fee) Table name: Student studid Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50)NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20) NOT NULL NOT NULL, UNIQUE, Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid Number(3) Primary Key Actdt DATE NOT NULL Place Varchar2(50)INOT NULL durationNbHour Number NOT NULL Table Name: Organize actid Number(3) Primary Key, Foreign key clubID Number(3) Primary key, Foreign key Fee Number(4,2)
Transcribed Image Text:The aim of assignment 1 is to implement a database schema and execute different types of SQL queries in Oracle SQL developer. Given the following relational schema: Student (studid, FirstName, LastName, Email, phoneNumber, DateofBirth, GPA) Club (clubid, ClubName, #studid) MemberOf (#clubid, #studid, joiningDate ) Activities (actid, actdt, place, durationNbHour) Organize (#actid, #clubid , fee) Table name: Student studid Char(9) Primary key FirstName Varchar2(50) NOT NULL LastName Varchar2(50)NOT NULL Email Varchar2(50) NOT NULL, UNIQUE phoneNumber Number(8) NOT NULL, UNIQUE DateofBirth Date NOT NULL GPA Number(1,2) NOT NULL Table name: Club clubID Number(3) Primary key ClubName Varchar2(20) NOT NULL NOT NULL, UNIQUE, Foreign key studid Char(9) Table Name: MemberOf ClubID Number(3) Primary Key, Foreign Key Studid Char(9) Primary Key, Foreign Key joiningDate Date Table Name: Activities Actid Number(3) Primary Key Actdt DATE NOT NULL Place Varchar2(50)INOT NULL durationNbHour Number NOT NULL Table Name: Organize actid Number(3) Primary Key, Foreign key clubID Number(3) Primary key, Foreign key Fee Number(4,2)
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Multiple 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 Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS